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}"); }