public void UpdateStatus(SqlCeOfflineEntity entity)
{
var status = (Status) entity;
using (var command = new SqlCeCommand())
{
command.Connection = GetSqlCeConnection();
command.CommandText = UPDATE_STATUS;
command.Parameters.Add("@ID", SqlDbType.Int).Value = status.ID;
command.Parameters.AddWithValue("@Name", status.Name);
if (null == status.ServiceMetadata.Id)
{
command.Parameters.Add("@MetadataId", SqlDbType.NVarChar, 250).Value = DBNull.Value;
}
else
{
command.Parameters.Add("@MetadataId", SqlDbType.NVarChar, 250).Value = status.ServiceMetadata.Id;
}
command.ExecuteNonQuery();
}
}