public void InsertUser(SqlCeOfflineEntity entity)
{
var user = (User)entity;
using (var command = new SqlCeCommand())
{
command.Connection = GetSqlCeConnection();
command.CommandText = INSERT_USER;
command.Parameters.Add("@ID", SqlDbType.UniqueIdentifier).Value = user.ID;
command.Parameters.AddWithValue("@Name", user.Name);
if (null == user.ServiceMetadata.Id)
{
command.Parameters.Add("@MetadataId", SqlDbType.NVarChar, 250).Value = DBNull.Value;
}
else
{
command.Parameters.Add("@MetadataId", SqlDbType.NVarChar, 250).Value = user.ServiceMetadata.Id;
}
command.ExecuteNonQuery();
}
}