public DbContext()
: base("TestovaciDB")
{
Jelineksoft.Entity.Settings.ConnectionString = @"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=P:\Jelineksoft\JelinekPetr.Entities\Jelineksoft.Entity.TestApp\TestDB.mdf;Integrated Security=True;Connect Timeout=30";
Jelineksoft.Entity.Settings.DefaultProvider = new Jelineksoft.Entity.Providers.MSSQLProvider( );
Jelineksoft.Entity.Settings.SetDBNullToDefaultClassValue = false; //When in DB table is null value, setter in class property set default column value
Jelineksoft.Entity.Settings.Log.LogSQLToConsole = true;
TableOrder = new TableOrder();
TableOrderItem = new TableOrderItem();
}
static void Main(string[] args)
{
Console.WriteLine("Writing to DB Orders...");
var db = new DbContext();
for (var i = 0; i < 100; i++)
{
var o = new TableOrder.TableOrderRow();
o.DbHelpers.IsNew = true;
o.DateCreate = DateTime.Now;
o.Number = "Nr. " + i.ToString();
o.Save();
for (var x = 0; x < 10; x++)
{
var oi = new TableOrderItem.TableOrderItemRow();
oi.Description = "Item nr. " + x.ToString();
oi.OrderId = o.Id;
oi.Quantity = x * 5;
oi.Save();
}
}
Console.WriteLine("Writing to DB Orders... OK");
Console.WriteLine("Selecting from DB Orders...");
var xo = new TableOrder();
xo.AddFrom(xo);
xo.AddOrderBy(xo.DateCreate, OrderByEnum.Desc);
xo.LoadData();
foreach (var oo in xo.TypedRows)
{
Console.WriteLine($"Id: {oo.Id} Number: {oo.Number}");
var xi = new TableOrderItem();
xi.AddFrom(xi);
xi.AddWhere(xi.OrderId, oo.Id);
xi.LoadData();
foreach (var ii in xi.TypedRows)
{
ii.OrderRef = oo;
Console.WriteLine($" ItemId: {ii.Id} Description: {ii.Description} Quantity: {ii.Quantity}");
}
}
}