NHibernate: How to map a column on a referenced table to a primitive in my object? -


If I have an existing table schema

  + ------- - ----------- + ------------------- + | Address | Country | + ------------------- + + ------------------- + | Line 1 | + --- & gt; | Country ID | | Line 2 | | | Name | | City | | + ------------------- + | State | | | ZIP | | | CountryID | --- + + ------------------- +  

... and my class is as follows

< Former> public class address {public virtual string line 1 {receipt; Set; } Public Virtual String Line2 {get; Set; } Public virtual string city {get; Set; } Public virtual string state {get; Set; } Public virtual string postal code (get); Set; } Public virtual string country {get; Set; }}

... How can I configure my mapping so that country [string] property contains the [Name] column Join [country] table

You can get it by mapping Are opinions But object-oriented approach will be to create a country object and map multiple relationships between address and country:

  public class address {public virtual string line 1 {get; Set; } Public Virtual String Line2 {get; Set; } Public virtual string city {get; Set; } Public virtual string state {get; Set; } Public virtual string postal code (get); Set; } Public virtual country country {get; Set; }}  

You will then use the name through the name. country name. In FluentNHibernate you will use to mapping the relationship in your address mapping: context (x => x country; country id);


Comments

Popular posts from this blog

sql - dynamically varied number of conditions in the 'where' statement using LINQ -

asp.net mvc - Dynamically Generated Ajax.BeginForm -

Debug on symbian -