ORM in .NET

ORM in .NET

What is ORM?

ORM stands for Object Relational Mapping. ORM is used to transparently relate objects to Backend data store.

ORM.NET Solution

Object Population

Let us consider the primary decisions that needs to taken for object population.

Represents internal class data as Dataset

Create all the properties with their appropriate types

Perform all translations within properties

Represents collections as specialized classes

Techniques involved in Object Population

Built-in features of ADO.NET Dataset /DataAdapter / Command Builder are used

Text Box: DataSet ds = new DataSet ();

SqlDataAdapter sda = new SqlDataAdapter (command);

SqlCommandBuilder cmdBuilder = new SqlCommandBuilder (sda);

sda. Fill(ds, tableName);

Object Persistence

ADO.NET handles the persistence behind the scenes.

Text Box: Protected void Synchronize ()

{

DataAdapter.Update(ParentDataSet);

ParentDataSet.AcceptChanges();

}

Issues and Limitations

Database Tables would be retrieved individually

1. No joins should be used

2. May degrade retrieval performance

3. Datarelations may need to be created

Properties returning collections need to be aware of the table relations

Data source transparency is hard to achieve

Specialized collection classes may cause maintenance and support issues

May choose to flatten the database Increases performance / Eliminates the needs for joins

Conclusion

Easy to implement and maintain solution.

No third-party tools required.

Based on out-of-the-box .Net functionality.

Plumbing code and base classes are written once.

Most data retrieval and persistence code is eliminated.

Comments

Plain text