# Vitorm TODO


# SqlServer  Select 
 select  IIF([t0].[FatherId] is not null,true,false) as c13, [t0].[FatherId] is not null as c14, [t0].[Name] as c15
 from [dbo].[User] as t0



# group then orderBy aggregate column
> [QueryTranslator] not suported MethodCall: Sum
``` csharp
using var dbContext = DataSource.CreateDbContext();
var userQuery = dbContext.Query<User>();
{
    var query =
         userQuery
        .GroupBy(user => new { user.fatherId, user.motherId })
        .OrderBy(m => m.Sum(m => m.id))
        .Select(userGroup => new
        {
            userGroup.Key.fatherId,
            userGroup.Key.motherId,
            sumId = userGroup.Sum(m => m.id),
        });


    var sql = query.ToExecuteString();
    var rows = query.ToList();
    var count = query.Count();
}
```



# order by calculated column
users.Select(user => new { user.id, fid = user.fatherId ?? -1 }).OrderBy(m => m.fid)



# DbContext.QueryProcedure<Entity>(arg)  
# DbFunction.PrimitiveSql