private async Task <List <WorkOrder> > GetWorkOrdersWithProduct(MightyOrm <WorkOrder> db)
{
var data = await db.QueryAsync(@"SELECT TOP 500 WO.*, P.*
FROM [AdventureWorks2014].[Production].[WorkOrder] AS WO
INNER JOIN[Production].[Product] AS P ON P.ProductID = WO.ProductID");
return(await data.ToListAsync());
}
public async Task <List <Orders> > GetOrders()
{
var db = new MightyOrm <Orders>("AdventureWorks2014");
var data = await db.QueryAsync(@"SELECT TOP 500 [WorkOrderID] AS Id, P.Name AS ProductName, [OrderQty] AS Quantity, [DueDate] AS Date
FROM [AdventureWorks2014].[Production].[WorkOrder] AS WO
INNER JOIN[Production].[Product] AS P ON P.ProductID = WO.ProductID");
return(await data.ToListAsync());
}