public object GetAllLists()
{
var lists = new List<List>();
using (var command = new SqlCeCommand())
{
command.Connection = GetSqlCeConnection();
command.CommandText = GET_ALL_LISTS;
SqlCeDataReader reader = command.ExecuteReader();
while (reader.Read())
{
var l = new List
{
ID = (Guid) reader["ID"],
Name = reader["Name"] as string,
Description = reader["Description"] as string,
CreatedDate = (DateTime) reader["CreatedDate"],
UserID = (Guid)reader["UserID"],
ServiceMetadata = new OfflineEntityMetadata()
{
IsTombstone = (bool)reader["IsTombstone"],
Id = reader["_MetadataID"] as string
}
};
lists.Add(l);
}
}
return lists;
}