|
|
Object Relational Mapping
Object relational mapping is the technique for converting data between incompatible
type systems in relational databases and object-oriented programming languages.
That means it creates a "virtual object database" that can be used from within the
programming language.
Some Object Relational Mapping Software
NHibernate: This is an ORM tool that eliminates thousands of lines
of code and stored procedures, thus allowing developers to focus more on the core
of a project: its domain model and business logic. It provides all the CRUD operations
through ISession interface. The ISession also supports transactions through ITransaction
interface. NHibernate can be used with any DBMS. It provides limited support for
query creation.
An over view of how to use NHibernate can be found
here.
More detailed information and best practices can be found
here.
LINQ: This is not a complete ORM tool and is provided as a built-in
feature in Visual Studio 2008 and the .NET Framework 3.5 for ORM support. The visual
studio 2008 gives full design time support for creating a LINQ data model project.
It is primarily used with SQL Server and supports creation of queries (compiler
checks the syntax).
An over view of how to use LINQ can be found
here.
It completely depends on the type of the project which technique to use. It is really
nice to combine Linq with all the power in NHibernate. A reference for the same
can be found
here.
|