public void XOnDeleteCascade()
{
#if CLR4
using (ModelFirstModel1Container ctx = new ModelFirstModel1Container())
{
if (ctx.DatabaseExists())
{
ctx.DeleteDatabase();
}
ctx.CreateDatabase();
ctx.SaveChanges();
}
#endif
using (ModelFirstModel1Container ctx = new ModelFirstModel1Container())
{
Student s = new Student();
s.Name = "Einstein, Albert";
s.Kardexes.Add(new Kardex()
{
Score = 9.0
});
ctx.AddToStudents(s);
ctx.SaveChanges();
}
using (ModelFirstModel1Container ctx = new ModelFirstModel1Container())
{
var a = from st in ctx.Students select st;
Student s = a.First();
s.Kardexes.Load();
Assert.Equal("Einstein, Albert", s.Name);
Kardex k = s.Kardexes.First();
Assert.Equal(9.0, k.Score);
ctx.DeleteObject(s);
ctx.SaveChanges();
}
using (ModelFirstModel1Container ctx = new ModelFirstModel1Container())
{
var q = from st in ctx.Students select st;
Assert.Equal(0, q.Count());
var q2 = from k in ctx.Kardexes select k;
Assert.Equal(0, q2.Count());
}
}
public void OnDeleteCascade()
{
#if CLR4
using (ModelFirstModel1Container ctx = new ModelFirstModel1Container())
{
if (ctx.DatabaseExists())
ctx.DeleteDatabase();
ctx.CreateDatabase();
ctx.SaveChanges();
}
#endif
using (ModelFirstModel1Container ctx = new ModelFirstModel1Container())
{
Student s = new Student();
s.Name = "Einstein, Albert";
s.Kardexes.Add(new Kardex() { Score = 9.0 });
ctx.AddToStudents(s);
ctx.SaveChanges();
}
using (ModelFirstModel1Container ctx = new ModelFirstModel1Container())
{
var a = from st in ctx.Students select st;
Student s = a.First();
s.Kardexes.Load();
Assert.AreEqual( "Einstein, Albert", s.Name );
Kardex k = s.Kardexes.First();
Assert.AreEqual(9.0, k.Score);
ctx.DeleteObject( s );
ctx.SaveChanges();
}
using (ModelFirstModel1Container ctx = new ModelFirstModel1Container())
{
var q = from st in ctx.Students select st;
Assert.AreEqual(0, q.Count());
var q2 = from k in ctx.Kardexes select k;
Assert.AreEqual(0, q2.Count());
}
}