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