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