public StatesReference(IDexCMSCoreContext context)
{
IA = context.States.Where(x => x.Abbreviation == "IA").Select(x => x.StateID).Single();
OH = context.States.Where(x => x.Abbreviation == "OH").Select(x => x.StateID).Single();
UT = context.States.Where(x => x.Abbreviation == "UT").Select(x => x.StateID).Single();
TX = context.States.Where(x => x.Abbreviation == "TX").Select(x => x.StateID).Single();
ID = context.States.Where(x => x.Abbreviation == "ID").Select(x => x.StateID).Single();
ME = context.States.Where(x => x.Abbreviation == "ME").Select(x => x.StateID).Single();
NV = context.States.Where(x => x.Abbreviation == "NV").Select(x => x.StateID).Single();
KS = context.States.Where(x => x.Abbreviation == "KS").Select(x => x.StateID).Single();
HI = context.States.Where(x => x.Abbreviation == "HI").Select(x => x.StateID).Single();
AK = context.States.Where(x => x.Abbreviation == "AK").Select(x => x.StateID).Single();
OR = context.States.Where(x => x.Abbreviation == "OR").Select(x => x.StateID).Single();
WY = context.States.Where(x => x.Abbreviation == "WY").Select(x => x.StateID).Single();
VT = context.States.Where(x => x.Abbreviation == "VT").Select(x => x.StateID).Single();
AZ = context.States.Where(x => x.Abbreviation == "AZ").Select(x => x.StateID).Single();
AL = context.States.Where(x => x.Abbreviation == "AL").Select(x => x.StateID).Single();
FL = context.States.Where(x => x.Abbreviation == "FL").Select(x => x.StateID).Single();
GA = context.States.Where(x => x.Abbreviation == "GA").Select(x => x.StateID).Single();
MT = context.States.Where(x => x.Abbreviation == "MT").Select(x => x.StateID).Single();
IN = context.States.Where(x => x.Abbreviation == "IN").Select(x => x.StateID).Single();
MO = context.States.Where(x => x.Abbreviation == "MO").Select(x => x.StateID).Single();
MI = context.States.Where(x => x.Abbreviation == "MI").Select(x => x.StateID).Single();
MD = context.States.Where(x => x.Abbreviation == "MD").Select(x => x.StateID).Single();
IL = context.States.Where(x => x.Abbreviation == "IL").Select(x => x.StateID).Single();
NE = context.States.Where(x => x.Abbreviation == "NE").Select(x => x.StateID).Single();
NY = context.States.Where(x => x.Abbreviation == "NY").Select(x => x.StateID).Single();
KY = context.States.Where(x => x.Abbreviation == "KY").Select(x => x.StateID).Single();
AR = context.States.Where(x => x.Abbreviation == "AR").Select(x => x.StateID).Single();
CO = context.States.Where(x => x.Abbreviation == "CO").Select(x => x.StateID).Single();
DE = context.States.Where(x => x.Abbreviation == "DE").Select(x => x.StateID).Single();
VA = context.States.Where(x => x.Abbreviation == "VA").Select(x => x.StateID).Single();
OK = context.States.Where(x => x.Abbreviation == "OK").Select(x => x.StateID).Single();
WI = context.States.Where(x => x.Abbreviation == "WI").Select(x => x.StateID).Single();
TN = context.States.Where(x => x.Abbreviation == "TN").Select(x => x.StateID).Single();
LA = context.States.Where(x => x.Abbreviation == "LA").Select(x => x.StateID).Single();
MN = context.States.Where(x => x.Abbreviation == "MN").Select(x => x.StateID).Single();
NJ = context.States.Where(x => x.Abbreviation == "NJ").Select(x => x.StateID).Single();
NM = context.States.Where(x => x.Abbreviation == "NM").Select(x => x.StateID).Single();
CA = context.States.Where(x => x.Abbreviation == "CA").Select(x => x.StateID).Single();
WA = context.States.Where(x => x.Abbreviation == "WA").Select(x => x.StateID).Single();
CT = context.States.Where(x => x.Abbreviation == "CT").Select(x => x.StateID).Single();
MS = context.States.Where(x => x.Abbreviation == "MS").Select(x => x.StateID).Single();
ND = context.States.Where(x => x.Abbreviation == "ND").Select(x => x.StateID).Single();
SD = context.States.Where(x => x.Abbreviation == "SD").Select(x => x.StateID).Single();
PA = context.States.Where(x => x.Abbreviation == "PA").Select(x => x.StateID).Single();
RI = context.States.Where(x => x.Abbreviation == "RI").Select(x => x.StateID).Single();
WV = context.States.Where(x => x.Abbreviation == "WV").Select(x => x.StateID).Single();
MA = context.States.Where(x => x.Abbreviation == "MA").Select(x => x.StateID).Single();
NH = context.States.Where(x => x.Abbreviation == "NH").Select(x => x.StateID).Single();
NC = context.States.Where(x => x.Abbreviation == "NC").Select(x => x.StateID).Single();
SC = context.States.Where(x => x.Abbreviation == "SC").Select(x => x.StateID).Single();
DC = context.States.Where(x => x.Abbreviation == "DC").Select(x => x.StateID).Single();
}
public SettingDataTypesReference(IDexCMSCoreContext Context)
{
Text = Context.SettingDataTypes.Where(x => x.Name == "Text").Select(x => x.SettingDataTypeID).Single();
Date = Context.SettingDataTypes.Where(x => x.Name == "Date").Select(x => x.SettingDataTypeID).Single();
Bool = Context.SettingDataTypes.Where(x => x.Name == "Bool").Select(x => x.SettingDataTypeID).Single();
Html = Context.SettingDataTypes.Where(x => x.Name == "Html").Select(x => x.SettingDataTypeID).Single();
Int = Context.SettingDataTypes.Where(x => x.Name == "Int").Select(x => x.SettingDataTypeID).Single();
Multiline = Context.SettingDataTypes.Where(x => x.Name == "Multiline").Select(x => x.SettingDataTypeID).Single();
FourDigitWhole = Context.SettingDataTypes.Where(x => x.Name == "FourDigitWhole").Select(x => x.SettingDataTypeID).Single();
Email = Context.SettingDataTypes.Where(x => x.Name == "Email").Select(x => x.SettingDataTypeID).Single();
Password = Context.SettingDataTypes.Where(x => x.Name == "Password").Select(x => x.SettingDataTypeID).Single();
Url = Context.SettingDataTypes.Where(x => x.Name == "Url").Select(x => x.SettingDataTypeID).Single();
}
public CountriesReference(IDexCMSCoreContext context)
{
USA = context.Countries.Where(x => x.Name == "United States").Select(x => x.CountryID).Single();
}
