internal TestData()
{
using (EfContext con = new EfContext(_conf))
{
if (con.Database.Exists())
{
con.Database.Delete();
}
con.Database.Create();
Product p1 = new Product()
{
Name = "Testanlage"
};
Product p2 = new Product()
{
Name = "A2017-0000"
};
Product p3 = new Product()
{
Name = "A2017-0001"
};
Product p4 = new Product()
{
Name = "A2017-0002"
};
Product p5 = new Product()
{
Name = "A2090-0000"
};
con.Add(p1);
con.Add(p2);
con.Add(p3);
con.Add(p4);
con.Add(p5);
con.Complete();
Customer c1 = new Customer()
{
Name = "GmbH 1", Products = new List <Product>()
{
p2, p3
}
};
Customer c2 = new Customer();
c2.Name = "GmbH 2";
Customer c3 = new Customer()
{
Name = "GmbH 3",
Products = new List <Product>()
{
p4
}
};
Customer c4 = new Customer()
{
Name = "GmbH 4"
};
Customer c5 = new Customer()
{
Name = "Intern",
Products = new List <Product>()
{
p1
}
};
p2.Owner = c1;
p3.Owner = c1;
p4.Owner = c3;
p1.Owner = c5;
con.Add(c1);
con.Add(c2);
con.Add(c3);
con.Add(c4);
con.Add(c5);
con.Complete();
}
}
public void EfContextTests_CRUD_Customer()
{
using (TestData td = new TestData())
{
Customer c1 = new Customer()
{
Name = "GmbH Test"
};
string newName = "Tested";
using (EfContext con = new EfContext(new TestConfig()))
{
con.Set <Customer>().Add(c1);
con.SaveChanges();
}
using (EfContext con = new EfContext(new TestConfig()))
{
Customer loaded = con.Set <Customer>().Find(c1.Id);
Assert.IsNotNull(loaded);
Assert.AreEqual(c1.Name, loaded.Name);
loaded.Name = newName;
con.SaveChanges();
}
using (EfContext con = new EfContext(new TestConfig()))
{
Customer loaded = con.Set <Customer>().Find(c1.Id);
Assert.AreEqual(loaded.Name, newName);
con.Set <Customer>().Remove(loaded);
con.SaveChanges();
}
using (EfContext con = new EfContext(new TestConfig()))
{
Customer loaded = con.Set <Customer>().Find(c1.Id);
Assert.IsNull(loaded);
}
}
using (EfContext con = new EfContext(new TestConfig()))
{
if (con.Database.Exists())
{
con.Database.Delete();
}
con.Database.Create();
Product p1 = new Product()
{
Name = "Testanlage"
};
Product p2 = new Product()
{
Name = "A2017-0000"
};
Product p3 = new Product()
{
Name = "A2017-0001"
};
Product p4 = new Product()
{
Name = "A2017-0002"
};
Product p5 = new Product()
{
Name = "A2090-0000"
};
con.Add(p1);
con.Add(p2);
con.Add(p3);
con.Add(p4);
con.Add(p5);
con.Complete();
Customer c1 = new Customer();
c1.Name = "GmbH 1";
c1.Products = new List <Product>()
{
p2, p3
};
Customer c2 = new Customer();
c2.Name = "GmbH 2";
Customer c3 = new Customer();
c3.Name = "GmbH 3";
c3.Products = new List <Product>()
{
p4
};
Customer c4 = new Customer();
c4.Name = "GmbH 4";
Customer c5 = new Customer();
c5.Name = "Intern";
c5.Products = new List <Product>()
{
p1
};
p2.Owner = c1;
p3.Owner = c1;
p4.Owner = c3;
p1.Owner = c5;
con.Add(c1);
con.Add(c2);
con.Add(c3);
con.Add(c4);
con.Add(c5);
con.Complete();
}
}
