public void TestToList()
{
using (var ctx = new ConvertorContext(_options))
using (var db = ctx.CreateLinqToDbConnection())
{
ctx.Database.EnsureDeleted();
ctx.Database.EnsureCreated();
var resut = db.InsertWithInt64Identity(new SubDivision()
{
Code = "C1", Id = new Id <SubDivision, long>(0), Name = "N1", PermanentId = Guid.NewGuid()
});
resut = db.InsertWithInt64Identity(new SubDivision()
{
Code = "C2", Id = new Id <SubDivision, long>(1), Name = "N2", PermanentId = Guid.NewGuid()
});
resut = db.InsertWithInt64Identity(new SubDivision()
{
Code = "C3", Id = new Id <SubDivision, long>(2), Name = "N3", PermanentId = Guid.NewGuid()
});
var ef = ctx.Subdivisions.Where(s => s.Id == 1L).ToArray();
var ltdb = ctx.Subdivisions.ToLinqToDB().Where(s => s.Id == 1L).ToArray();
var id = new Nullable <Id <SubDivision, long> >(0L.AsId <SubDivision>());
var ltdb2 = ctx.Subdivisions.ToLinqToDB().Where(s => s.Id == id).ToArray();
var ids = new[] { 1L.AsId <SubDivision>(), 2L.AsId <SubDivision>(), };
public void TestToList()
{
using (var ctx = new ConvertorContext(_options))
using (var db = ctx.CreateLinqToDbConnection())
{
ctx.Database.EnsureDeleted();
ctx.Database.EnsureCreated();
var resut = db.InsertWithInt64Identity(new SubDivision()
{
Code = "C1", Id = new Id <SubDivision, long>(0), Name = "N1", PermanentId = Guid.NewGuid()
});
resut = db.InsertWithInt64Identity(new SubDivision()
{
Code = "C2", Id = new Id <SubDivision, long>(1), Name = "N2", PermanentId = Guid.NewGuid()
});
resut = db.InsertWithInt64Identity(new SubDivision()
{
Code = "C3", Id = new Id <SubDivision, long>(2), Name = "N3", PermanentId = Guid.NewGuid()
});
db.GetTable <SubDivision>()
.Where(s => s.Id == 1)
.Set(s => s.ParentId, new Id <SubDivision, long>(11))
.Update();
db.GetTable <SubDivision>()
.Where(s => s.Id == 2)
.Set(s => s.ParentId, () => new Id <SubDivision, long>(33))
.Update();
var ef = ctx.Subdivisions.Where(s => s.Id == 1L).ToArray();
var ltdb = ctx.Subdivisions.ToLinqToDB().Where(s => s.Id == 1L).ToArray();
var all = ctx.Subdivisions.ToLinqToDB().ToArray();
}
}
