public List<Item> GetAllItems(Guid listId)
{
var items = new List<Item>();
using (var command = new SqlCeCommand())
{
command.Connection = GetSqlCeConnection();
command.CommandText = GET_ALL_ITEMS;
command.Parameters.Add("@ListID", SqlDbType.UniqueIdentifier).Value = listId;
SqlCeDataReader reader = command.ExecuteReader();
while (reader.Read())
{
var i = new Item
{
ID = (Guid)reader["ID"],
Name = reader["Name"] as string,
Description = reader["Description"] as string,
ListID = (Guid)reader["ListID"],
Priority = reader["Priority"] as int?,
Status = reader["Status"] as int?,
UserID = (Guid)reader["UserID"],
ServiceMetadata = new OfflineEntityMetadata()
{
IsTombstone = (bool)reader["IsTombstone"],
Id = reader["_MetadataID"] as string
}
};
items.Add(i);
}
}
return items;
}