I have a User table and a Country table.

My Country table is filled with all the countries around the world.

Country(id,country_name)

When i register a user with my c#.net website i want them to choose a country and i want that country to be stored in my user table(fk_country_id).

In my User mapping file i have a many to one relationship between the user table and the country table.

In my User class I have a getter and setter for my country object.

However, i'm not sure how i can save the selected country value in my user table.

I thought this would work(but it doesn't):

User newUser = new User();
newUser.Country.Id= System.Convert.ToInt32(drpdwnCountry.SelectedValue);

where Country is my object being returned in my User class.

Can someone please help me with this?

Thanks in advance.

Assuming that your mapping files are correct, the following code should be work:


Perhaps this article will help you: http://blogs.hibernatingrhinos.com/nhibernate/archive/2008/04/01/your-first-nhibernate-based-application.aspx

thanks i'll give it a try

Create a DaoFactory for Country like CountryDao

and try like this

User newUser = new User();
newUser.Country= CountryDao.getbyId(System.Convert.ToInt32(drpdwnCountry.SelectedValue),false);


try Mapping File like this

<many-to-one name="StatusId" column="statusId" class="HospiceCare.Core.Domain.Country, HospiceCare.Core" />

Please change to your Style..

Hope this will help you

Regards
Feroz.K

Create a DaoFactory for Country like CountryDao

and try like this

User newUser = new User();
newUser.Country= CountryDao.getbyId(System.Convert.ToInt32(drpdwnCountry.SelectedValue),false);


try Mapping File like this

<many-to-one name="StatusId" column="statusId" class="HospiceCare.Core.Domain.Country, HospiceCare.Core" />

Please change to your Style..

Hope this will help you

Regards
Feroz.K