public Application_StateProvinceQuery <Application_CityQuery <K, T>, T> JoinApplication_StateProvince(JoinType joinType = JoinType.Inner, bool preloadEntities = false)
{
var joinedQuery = new Application_StateProvinceQuery <Application_CityQuery <K, T>, T>(Db);
return(Join(joinedQuery, string.Concat(joinType.GetJoinString(), " [Application].[StateProvinces] AS {1} {0} ON", "{2}.[StateProvinceID] = {1}.[StateProvinceID]"), o => ((Application_City)o)?.Application_StateProvince, (e, fv, ppe) =>
{
var child = (Application_StateProvince)ppe(QueryHelpers.Fill <Application_StateProvince>(null, fv));
if (e != null)
{
((Application_City)e).Application_StateProvince = child;
}
return child;
}
, typeof(Application_StateProvince), preloadEntities));
}
public Application_StateProvinceQuery <Application_CountryQuery <K, T>, T> JoinApplication_StateProvinces(JoinType joinType = JoinType.Inner, bool attach = false)
{
var joinedQuery = new Application_StateProvinceQuery <Application_CountryQuery <K, T>, T>(Db);
return(JoinSet(() => new Application_StateProvinceTableQuery <Application_StateProvince>(Db), joinedQuery, string.Concat(joinType.GetJoinString(), " [Application].[StateProvinces] AS {1} {0} ON", "{2}.[CountryID] = {1}.[CountryID]"), (p, ids) => ((Application_StateProvinceWrapper)p).Id.In(ids.Select(id => (System.Int32)id)), (o, v) => ((Application_Country)o).Application_StateProvinces.Attach(v.Cast <Application_StateProvince>()), p => (long)((Application_StateProvince)p).CountryID, attach));
}
