SmartDeviceProject1.SqlCeStorageHandler.UpdateTag C# (CSharp) Method

UpdateTag() public method

public UpdateTag ( SqlCeOfflineEntity entity ) : void
entity SqlCeOfflineEntity
return void
        public void UpdateTag(SqlCeOfflineEntity entity)
        {
            var tag = (Tag)entity;

            using (var command = new SqlCeCommand())
            {
                command.Connection = GetSqlCeConnection();
                command.CommandText = UPDATE_TAG;
                command.Parameters.Add("@ID", SqlDbType.Int).Value = tag.ID;
                command.Parameters.AddWithValue("@Name", tag.Name);

                if (null == tag.ServiceMetadata.Id)
                {
                    command.Parameters.Add("@MetadataId", SqlDbType.NVarChar, 250).Value = DBNull.Value;
                }
                else
                {
                    command.Parameters.Add("@MetadataId", SqlDbType.NVarChar, 250).Value = tag.ServiceMetadata.Id;
                }

                command.ExecuteNonQuery();
            }
        }