static async System.Threading.Tasks.Task Main(string[] args)
{
using var db = new NorthwindContext();
//var procs = new NorthwindContextProcedures(db);
var sret = new OutputParameter <string>();
var returned = new OutputParameter <string>();
await db.GetProcedures().OutputFailAsync(sret, returned);
if (sret.Value != "yes")
{
Console.Error.WriteLine($"AssertEqual failed. Expected: \"yes\". Actual: {sret.Value}.");
}
var spacesResult = await db.GetProcedures().SpacesAsync();
if (spacesResult.Length != 1)
{
Console.Error.WriteLine($"AssertEqual failed. Expected: 1. Actual: {spacesResult.Length}.");
}
var output1 = new OutputParameter <string>();
var output2 = new OutputParameter <string>();
var output3 = new OutputParameter <int>();
var result = await db.GetProcedures().TestMethodOutputNoResultAsync(0, null, output1, output2, output3);
var result2 = await db.GetProcedures().CustOrderHistDupeAsync("ALFKI");
if (result2.Length != 11)
{
Console.Error.WriteLine($"AssertEqual failed. Expected: 11. Actual: {result2.Length}.");
}
var return1 = new OutputParameter <int>();
var test = await db.GetProcedures().ReturnValueAsync(return1);
if (return1.Value != 42)
{
Console.Error.WriteLine($"AssertEqual failed. Expected: 42. Actual: {return1.Value}.");
}
var rowsResult = await db.GetProcedures().CategoryUpdateAsync("Beverages", 1);
if (rowsResult != 1)
{
Console.Error.WriteLine($"AssertEqual failed. Expected: 1. Actual: {rowsResult}.");
}
var rowsResult2 = await db.GetProcedures().CategoryUpdateAsync("Beverages", int.MinValue);
if (rowsResult2 != 0)
{
Console.Error.WriteLine($"AssertEqual failed. Expected: 0. Actual: {rowsResult2}.");
}
var udfTest = db.Categories
.Where(c => c.CategoryName == NorthwindContext.GetCustInfo("x", null))
.ToList();
}
static async System.Threading.Tasks.Task Main(string[] args)
{
using (var db = new NorthwindContext())
{
var res = db.Shippers.ToList();
//var procs = new NorthwindContextProcedures(db);
var sret = new OutputParameter <string>();
var returned = new OutputParameter <string>();
await db.GetProcedures().OutputFailAsync(sret, returned);
if (sret.Value != "yes")
{
Console.Error.WriteLine($"AssertEqual failed. Expected: \"yes\". Actual: {sret.Value}.");
}
var spacesResult = await db.GetProcedures().SpacesAsync();
if (spacesResult.Count != 1)
{
Console.Error.WriteLine($"AssertEqual failed. Expected: 1. Actual: {spacesResult.Count}.");
}
var output1 = new OutputParameter <string>();
var output2 = new OutputParameter <string>();
var output3 = new OutputParameter <int>();
var result = await db.GetProcedures().TestMethodOutputNoResultAsync(0, null, output1, output2, output3);
var result2 = await db.GetProcedures().CustOrderHistDupeAsync("ALFKI");
if (result2.Count != 11)
{
Console.Error.WriteLine($"AssertEqual failed. Expected: 11. Actual: {result2.Count}.");
}
var return1 = new OutputParameter <int>();
var test = await db.GetProcedures().ReturnValueAsync(return1);
if (return1.Value != 42)
{
Console.Error.WriteLine($"AssertEqual failed. Expected: 42. Actual: {return1.Value}.");
}
var rowsResult = await db.GetProcedures().CategoryUpdateAsync("Beverages", 1);
if (rowsResult != 1)
{
Console.Error.WriteLine($"AssertEqual failed. Expected: 1. Actual: {rowsResult}.");
}
var rowsResult2 = await db.GetProcedures().CategoryUpdateAsync("Beverages", int.MinValue);
if (rowsResult2 != 0)
{
Console.Error.WriteLine($"AssertEqual failed. Expected: 0. Actual: {rowsResult2}.");
}
var udfTest = db.Categories
.Where(c => c.CategoryName == NorthwindContext.GetCustInfo("x", null))
.ToList();
var tvfTest = db.ProductsWithMinimumInStock(5)
.OrderBy(p => p.ProductName)
.ToList();
var query = db.Suppliers
.Where(s => db.Split("ALFKI;DADAD", ";").Any(split => split.Value == s.CompanyName));
var sql = query.ToQueryString();
var list = "ALFKI;DADAD";
var suppliers = db.Suppliers
.Where(s => db.Split(list, ";").Any(split => split.Value == s.CompanyName))
.ToList();
}
}
