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 RowQuery()
{
DBContext_CFL _context = DBContext_CFL.Instance;
var _con = _context.Connection.Connection;
string query = "SELECT * FROM defunt;";
NpgsqlCommand _command = new NpgsqlCommand(query);
_command.Connection = _con;
NpgsqlDataReader _reader = _command.ExecuteReader();
using (_reader)
{
while (_reader.Read())
{
int n = _reader.FieldCount;
}
}
}
private void LoadProject()
{
GraphProject _project = null;
DBContext_CFL dbContext = DBContext_CFL.instance;
_project = new DBLoader <GraphProject>
(dbContext.Connection, dbContext).First
(new DBSelect <GraphProject>("*").Where("ProjectName = 'Configuration entreprise'"));
if (_project != null)
{
foreach (ShapeTypeInfo _shapeInfo in _project.ShapeInfos)
{
__graphControl.TypesDescription.CompleteShapeTypeInfo(_shapeInfo);
}
}
__graphControl.Project = _project;
}
