# Vit.Orm
Compatible with QueryBuilder ( ref to DynamicQueryable )
>source address: [https://github.com/serset/Vit.Orm](https://github.com/serset/Vit.Orm "https://github.com/serset/Vit.Orm")    

![](https://img.shields.io/github/license/Serset/Vit.Orm.svg)  
![](https://img.shields.io/github/repo-size/Serset/Vit.Orm.svg)  ![](https://img.shields.io/github/last-commit/Serset/Vit.Orm.svg)  
 

| Build | NuGet |
| -------- | -------- |
|![](https://github.com/serset/Vit.Orm/workflows/ki_multibranch/badge.svg) | [![](https://img.shields.io/nuget/v/Vit.Orm.svg)](https://www.nuget.org/packages/Vit.Orm/) ![](https://img.shields.io/nuget/dt/Vit.Orm.svg) |




complex-query-operators https://learn.microsoft.com/en-us/ef/core/querying/complex-query-operators
sqlite/transactions  https://learn.microsoft.com/en-us/dotnet/standard/data/sqlite/transactions

--------------
# cur

# support Mysql



# sqlite upgrade to latest version
# remove depency of Dapper
# try to make it clean


# support SqlServer
# support ElasticSearch
# support ClickHouse


# DbContext.QueryProcedure<Entity>(arg)

--------------
# TODO

# sqlite nested transaction
# Save SaveRange



#region #4 cross database join
{
    var dbContext = DataSource.BuildInitedDatabase(System.Reflection.MethodBase.GetCurrentMethod()?.Name ?? "_");
    var users2 = dbContext.Query<User>();

    var query = (from user in users
                from father in users2.Where(father => user.fatherId == father.id).DefaultIfEmpty()
                select new
                {
                    user,
                    father
                });  

    var userList = query.ToList();
    Assert.AreEqual(4, userList.Count);
    Assert.AreEqual(3, userList.First().user.id);
}
#endregion

##   where (`t0`.`id` + 1 = 4) and (`t0`.`fatherId` = cast(5 as integer))

# will cause column mismatch if using inner select like:
select `t2`.`id`,`t2`.`name`,`t2`.`birth`,`t2`.`fatherId`,`t2`.`motherId`,`t3`.`name`
 from 
 (
	 select `t0`.`id`,`t0`.`name`,`t0`.`birth`,`t0`.`fatherId`,`t0`.`motherId`,`t1`.`id`,`t1`.`name`,`t1`.`birth`,`t1`.`fatherId`,`t1`.`motherId`
	 from `User` as t0
	 left join `User` as t1 on `t0`.`fatherId` = `t1`.`id`
 ) as t2
 left join `User` as t3 on `t2`.`motherId` = `t3`.`id`