SmartDeviceProject1.SqlCeStorageHandler.GetAllLists C# (CSharp) Method

GetAllLists() public method

public GetAllLists ( ) : object
return object
        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;
        }

Usage Example

Beispiel #1
0
 private void RefreshLists()
 {
     var storageHandler = new SqlCeStorageHandler();
     ListBoxLists.DataSource = storageHandler.GetAllLists();
     ListBoxLists.DisplayMember = "Name";
 }