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 ()





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





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.
Hide comments


  • Allowed HTML tags: <em> <strong> <blockquote> <br> <p>

Plain text

  • No HTML tags allowed.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Lines and paragraphs break automatically.