public Purchasing_SupplierQuery <Purchasing_PurchaseOrderQuery <K, T>, T> JoinPurchasing_Supplier(JoinType joinType = JoinType.Inner, bool preloadEntities = false)
{
var joinedQuery = new Purchasing_SupplierQuery <Purchasing_PurchaseOrderQuery <K, T>, T>(Db);
return(Join(joinedQuery, string.Concat(joinType.GetJoinString(), " [Purchasing].[Suppliers] AS {1} {0} ON", "{2}.[SupplierID] = {1}.[SupplierID]"), o => ((Purchasing_PurchaseOrder)o)?.Purchasing_Supplier, (e, fv, ppe) =>
{
var child = (Purchasing_Supplier)ppe(QueryHelpers.Fill <Purchasing_Supplier>(null, fv));
if (e != null)
{
((Purchasing_PurchaseOrder)e).Purchasing_Supplier = child;
}
return child;
}
, typeof(Purchasing_Supplier), preloadEntities));
}
public Purchasing_SupplierQuery <Application_CityQuery <K, T>, T> JoinPurchasing_Suppliers_PostalCityID_Application_Cities(JoinType joinType = JoinType.Inner, bool attach = false)
{
var joinedQuery = new Purchasing_SupplierQuery <Application_CityQuery <K, T>, T>(Db);
return(JoinSet(() => new Purchasing_SupplierTableQuery <Purchasing_Supplier>(Db), joinedQuery, string.Concat(joinType.GetJoinString(), " [Purchasing].[Suppliers] AS {1} {0} ON", "{2}.[CityID] = {1}.[PostalCityID]"), (p, ids) => ((Purchasing_SupplierWrapper)p).Id.In(ids.Select(id => (System.Int32)id)), (o, v) => ((Application_City)o).Purchasing_Suppliers_PostalCityID_Application_Cities.Attach(v.Cast <Purchasing_Supplier>()), p => (long)((Purchasing_Supplier)p).PostalCityID, attach));
}
