private void button1_Click(object sender, EventArgs e)
{
using (EF40Entities context = new EF40Entities())
{
//
}
}
private void Window_Loaded(object sender, RoutedEventArgs e)
{
context = new EF40Entities();
soh = context.SalesOrderHeaders.OrderBy(o => o.AccountNumber).ToList();
System.Windows.Data.CollectionViewSource salesOrderHeaderViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("salesOrderHeaderViewSource")));
// Load data by setting the CollectionViewSource.Source property:
// salesOrderHeaderViewSource.Source = [generic data source]
salesOrderHeaderViewSource.Source = soh;
}
private void Window_Loaded(object sender, RoutedEventArgs e)
{
context = new EF40Entities();
soh = context.SalesOrderHeaders.OrderBy(o => o.AccountNumber).ToList();
listBox1.ItemsSource = soh;
//combo
sp = context.SalesPersons.OrderBy(s => s.SalesPersonID).ToList();
comboBox1.ItemsSource = sp;
}
private void button2_Click(object sender, EventArgs e)
{
try
{
context = new EF40Entities();
var query = from con in context.Contacts
select con;
foreach (var asdf in query)
{
listBox1.Items.Add(asdf.FirstName);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString());
}
finally
{
context = null;
}
}
public BlogRepository(EF40Entities context)
{
_context = context;
}
