private Orders GetOrder(MightyOrm <Orders> db, int id)
{
return(db.Query(@"SELECT [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
WHERE WorkOrderID = @0", id).FirstOrDefault());
}
public List <Orders> GetOrders()
{
var db = new MightyOrm <Orders>("AdventureWorks2014");
return(db.Query(@"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").ToList());
}
public dynamic QueryDynamic()
{
Step();
return(_dynamicModel.Query("select * from Posts where Id = @0", _connection, i).First());
}
public Post Query()
{
Step();
return(_model.Query("select * from Posts where Id = @0", _connection, i).First());
}