internal static void CompileWhereAndSelectExpressions(AdventureWorks adventureWorks)
{
Expression linqExpression = adventureWorks.Products
.Where(product => product.Name.Length > 10)
.Select(product => product.Name).Expression;
(SelectExpression DatabaseExpression, IReadOnlyDictionary <string, object> Parameters)result =
adventureWorks.Compile(linqExpression);
result.DatabaseExpression.WriteLine();
result.Parameters.WriteLines(parameter => $"{parameter.Key}: {parameter.Value}");
}
internal static void CompileSelectAndFirstExpressions(AdventureWorks adventureWorks)
{
var selectQueryable = adventureWorks.Products
.Select(product => product.Name).Expression;
Func <IQueryable <string>, string> firstMethod = Queryable.First;
MethodCallExpression linqExpression = Expression.Call(
method: firstMethod.Method, arg0: selectQueryable);
(SelectExpression DatabaseExpression, IReadOnlyDictionary <string, object> Parameters)compilation =
adventureWorks.Compile(linqExpression);
compilation.DatabaseExpression.WriteLine();
compilation.Parameters.WriteLines(parameter => $"{parameter.Key}: {parameter.Value}");
}
