public Warehouse_StockItemQuery <Purchasing_PurchaseOrderLineQuery <K, T>, T> JoinWarehouse_StockItem(JoinType joinType = JoinType.Inner, bool preloadEntities = false)
{
var joinedQuery = new Warehouse_StockItemQuery <Purchasing_PurchaseOrderLineQuery <K, T>, T>(Db);
return(Join(joinedQuery, string.Concat(joinType.GetJoinString(), " [Warehouse].[StockItems] AS {1} {0} ON", "{2}.[StockItemID] = {1}.[StockItemID]"), o => ((Purchasing_PurchaseOrderLine)o)?.Warehouse_StockItem, (e, fv, ppe) =>
{
var child = (Warehouse_StockItem)ppe(QueryHelpers.Fill <Warehouse_StockItem>(null, fv));
if (e != null)
{
((Purchasing_PurchaseOrderLine)e).Warehouse_StockItem = child;
}
return child;
}
, typeof(Warehouse_StockItem), preloadEntities));
}
public Warehouse_StockItemQuery <Warehouse_ColorQuery <K, T>, T> JoinWarehouse_StockItems(JoinType joinType = JoinType.Inner, bool attach = false)
{
var joinedQuery = new Warehouse_StockItemQuery <Warehouse_ColorQuery <K, T>, T>(Db);
return(JoinSet(() => new Warehouse_StockItemTableQuery <Warehouse_StockItem>(Db), joinedQuery, string.Concat(joinType.GetJoinString(), " [Warehouse].[StockItems] AS {1} {0} ON", "{2}.[ColorID] = {1}.[ColorID]"), (p, ids) => ((Warehouse_StockItemWrapper)p).Id.In(ids.Select(id => (System.Int32)id)), (o, v) => ((Warehouse_Color)o).Warehouse_StockItems.Attach(v.Cast <Warehouse_StockItem>()), p => (long)((Warehouse_StockItem)p).ColorID, attach));
}
