How to do CROSS APPLY in SqlKata

[ahmad-moussawi]

[ahmad-moussawi]

Just use the Join method and pass "CROSS APPLY" or whatever method you like in the last parameter

var another = new Query("Race")
    .WhereColumns("Race.PlayerId", "=", "Player.id")
    .Select("Race.Score")
    .OrderByDesc("Race.Date")
    .Limit(1);
var query = new Query("Player").Join(another.As("LastRace"), j => j, "CROSS APPLY");