(fluent) nhibernate conditional table mapping strategy
- by grenade
I have no control over database schema and have the following (simplified) table structure:
CityProfile
Id
Name
CountryProfile
Id
Name
RegionProfile
Id
Name
I have a .Net enum and class encapsulating the lot:
public enum Scope { Region, Country, City }
public class Profile {
public Scope Scope { get; set; }
public int Id { get; set; }
public string Name { get; set; }
}
I am looking for a mechanism that allows me to map to the correct table, something like:
public class ProfileMap : ClassMap<Profile> {
public ProfileMap() {
switch (x => x.Scope) { // <--Invalid code here!
case Scope.City: Table("CityProfile"); break;
case Scope.Country: Table("CountryProfile"); break;
case Scope.Region: Table("RegionProfile"); break;
}
Id(x => x.Id);
Map(x => x.Name);
}
}
Or have I approached this wrong?
