Veeresh Rudrappa

If your database is stored in a different machine than your development machine then you can connect to it from your application over the network. You might have just bought a new laptop and might not want to the take the strain of setting up the database on your new machine all over again. So Let us see how to connect to PostgreSql over the network in few easy steps.

In my previous blog I showed how to set up NHibernate with PostgreSql. Now let us move on and build a small application and learn how to do the NHibernate Mappings. I have come up with a small ASP.NET MVC 3 project just to illustrate the usage of NHibernate. In the process you will also learn:

1. How to create Database, Tables, Schema and roles in PostgreSql
2. How create a MVC 3 project and use HTML helper forms.
3. How to map model objects and save them into Database
4. How to define many to one relationship in NHibernate.

With this blog and the previous one, you should be all set to build and develop any large scale project.

If you are looking for an Object Relational Mapping Solution for your .NET project then NHiberante is one framework I can vouch for. There are other ORM solutions for .NET like SubSonic , LLBLGen. NHibernate is open source and can be downloaded from here. If you are new to NHibernate, setting it up with your ASP.NET Application could be tricky. In this tutorial I will be showing you how to integrate NHibernate, PostgreSQL with ASP.NET MVC 3 application.