Using `System.String Concat` in `LINQ to Entities` generates `CAST`s instead of `CONCAT`

fields.Add("or (LastName + \", \" + MiddleName + \" \" + FirstName).Contains(@1)");

fields.Add("or string.Concat(LastName, \", \", MiddleName, \" \", FirstName).Contains(@1)");

Expression GenerateStringConcat(Expression left, Expression right) {
    return Expression.Call(
        null,
        typeof(string).GetMethod("Concat",
            new[] { typeof(object), typeof(object) }),
        new[] { left, right });
}

Expression GenerateStringConcat(Expression left, Expression right) {
    return Expression.Call(
        null,
        typeof(string).GetMethod("Concat",
            new[] { typeof(string), typeof(string) }),
        new[] { left, right });
}

SqlFunctions.StringConvert((double)factInitiative.Location_Idx) + ";" + factInitiative.Dim_Location.Location_Name

let strings = [ "tomatoes"; "bananas"; "apples" ]
let fullString = String.concat ", " strings
printfn "%s" fullString

[<CompiledName("Concat")>]
let concat sep (strings : seq<string>) =  
    String.Join(sep, strings)

let concatWithSpace xs = 
  String.concat " " xs

result = result
.OrderByDescending(t => (t.second_id== null || t.second_id.Trim() == 
 string.Empty))
.ThenBy(t => t.second_id)
.ThenBy(t => t.first_id)
.Select(t => t.primary_key)
.Skip(pageSize * pageNumber)
.Take(pageSize)
.ToList();