private void buttonExe_Click(object sender, RoutedEventArgs e)
{
DBContext_CFL _context = DBContext_CFL.Instance;
Defunt dft = null;
//var select = new DBSelect<Defunt>("*")
// .Where
// (
// new MemberPath(()=>dft.Identite), "=", new DBSelect().From("identite").Where
// (
// new MemberPath(()=>((Identite)null).Nom), "=", new DBValue("DUPONT3"),
// "or", new MemberPath(()=>dft.Identite.Nom), "=", new DBValue("DUPONT2")
// ),
// "or",
// new MemberPath(()=>dft.Pouvoir), "=", new DBSelect().From("pouvoir").Where
// (
// new MemberPath(()=>dft.Pouvoir.Identite), "=", new DBSelect().From("identite").Where
// (
// new MemberPath(()=>((Identite)null).Nom), "==", new DBValue("POUVOIR4"),
// "and", new MemberPath(()=>((Defunt)null).Pouvoir.Identite.Prenom), "==", new DBValue("Pouvoir4")
// )
// )
// )
// ;
DBSelect _select = new DBSelect("*").From("defunt")
.Where
(
new DBOnList(() => ((Defunt)null).OperationsFuneraires)
.Contains
(
new DBSelect().From("inhumation").Where
(
new MemberPath(() => ((Inhumation)null).date), "=", new DBValue(new DateTime(2017, 12, 6))
)
)
);
string query = _select.Query();
List <Base> dfts = new DBLoader(_context.Connection, _context).IncludeCascade().ToList(_select);
}
private void PopulateDB()
{
DBContext_CFL _context = DBContext_CFL.Instance;
Defunt dft = null;
for (int _i = 0; _i < 10; _i++)
{
dft = new Defunt();
dft.Identite.Nom = "DUPONT" + _i.ToString();
dft.Identite.Prenom = "Jean" + _i.ToString();
dft.Pouvoir.Qualite = Qualite.Fils;
dft.Pouvoir.Identite.Nom = "POUVOIR" + _i.ToString();
dft.Pouvoir.Identite.Prenom = "Pouvoir" + _i.ToString();
_context.GetOrAttach(dft);
}
_context.SaveChanges();
}
private void buttonB_Click(object sender, RoutedEventArgs e)
{
Defunt _defunt = Dft;
}
