public async Task GetColumnNamesForTable()
        {
            var expected = CustomersColumnNames();

            await using var context = new NorthwindContext();

            var customersColumnNames = context
                                       .GetEntityProperties("Customers")
                                       .Select(sqlColumn => sqlColumn.Name)
                                       .OrderBy(x => x);

            CollectionAssert.AreEqual(customersColumnNames.ToArray(), expected);
        }
コード例 #2
0
        private void ModelNamesListBox_SelectedIndexChanged(object sender, EventArgs e)
        {
            ColumnDescriptionsListView.Items.Clear();

            var results = _northWindContext.GetEntityProperties(ModelNamesListBox.Text);

            foreach (var sqlColumn in results)
            {
                ColumnDescriptionsListView.Items.Add(new ListViewItem(sqlColumn.ItemArray));
            }

            ColumnDescriptionsListView.AutoResizeColumns(ColumnHeaderAutoResizeStyle.HeaderSize);
            ColumnDescriptionsListView.FocusedItem       = ColumnDescriptionsListView.Items[0];
            ColumnDescriptionsListView.Items[0].Selected = true;
        }