public bool BdContientCustomer()
{
CompanyContext ctx = new CompanyContext(@"Data Source=vm-sql.iesn.be\stu3ig;Initial Catalog=DBIG3A4;Persist Security Info=True;User ID=IG3A4;Password=pwUserdb21");
//foreach(Customer cust in ctx.Customers)
//{
// i++;
//}
return ctx.Customers.Any();
}
public void insertionFonctionnelle()
{
Database.SetInitializer(new DropCreateDatabaseAlways<CompanyContext>());
CompanyContext ctx = new CompanyContext(@"Data Source=vm-sql.iesn.be\stu3ig;Initial Catalog=DBIG3A4;Persist Security Info=True;User ID=IG3A4;Password=pwUserdb21");
Customer cust = new Customer();
ctx.Customers.Add(cust);
ctx.SaveChanges();
var i = BdContientCustomer();
Assert.AreEqual(true, i);
}
void MainWindow_Loaded(object sender, RoutedEventArgs e)
{
_context = new CompanyContext(@"Data Source=vm-sql.iesn.be\stu3ig;Initial Catalog=DBIG3A4;Persist Security Info=True;User ID=IG3A4;Password=pwUserdb21");
_customer = _context.Customers.First();
Formulaire.DataContext = _customer;
}