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