static async System.Threading.Tasks.Task Main(string[] args) { using (var db = new NorthwindContext()) { var orders = await db.GetProcedures().CustOrderHistAsync("ALFKI"); var retVal = new OutputParameter <int>(); var multi = await db.GetProcedures().MultiSetAsync(new DateTime(2021, 12, 24), 7.6m, retVal); //var list = new[] { "ALFKI", "BERGS", "VAFFE" }; var list = new[] { 10253L, 10255L, 10260L }; var customersQuery = db.Orders .Where(s => db.AsSplit(list).Contains(s.OrderId)) .Select(o => new { o.OrderDate, o.CustomerId }); #if DEBUG Console.WriteLine(customersQuery.ToQueryString()); #endif var result = customersQuery.ToList(); foreach (var item in result) { Console.WriteLine($"{item.CustomerId} : {item.OrderDate}"); } var productCount = new OutputParameter <int?>(); var description = new OutputParameter <string>(); var outputRes = await db.GetProcedures() .OutputScenariosAsync(2021, productCount, description); } }