private void boxForTableList_SelectedIndexChanged(object sender, EventArgs e)
{
lstDataView.Items.Clear();
if (boxForTableList.SelectedIndex == 1)
{
using (var context = new Sales.EntityServices.AppContext())
{
foreach (var record in context.Customers.ToList())
{
lstDataView.Items.Add($"{record.Name} : {record.FamilyName}");
}
}
}
else if (boxForTableList.SelectedIndex == 2)
{
using (var context = new Sales.EntityServices.AppContext())
{
foreach (var record in context.Sellers.ToList())
{
lstDataView.Items.Add($"{record.Name} : {record.FamilyName}");
}
}
}
else if (boxForTableList.SelectedIndex == 3)
{
using (var context = new Sales.EntityServices.AppContext())
{
foreach (var record in context.Sales.ToList())
{
lstDataView.Items.Add($"{record.Customer.Name} {record.Customer.FamilyName} : {record.Seller.Name} {record.Seller.FamilyName}");
}
}
}
}
public MainForm()
{
InitializeComponent();
using (var context = new Sales.EntityServices.AppContext())
{
tableNames =
context.Database.SqlQuery <string>("SELECT name FROM sys.tables where name!='__MigrationHistory' ORDER BY name").ToList();
}
foreach (var name in tableNames)
{
boxForTableList.Items.Add(name);
}
}
