what is best practice in ORM (Entity / Nhibernate) ? RRS feed

  • General discussion

  • In our organisation we are planning to use ORM Model (Nhibernate or entity framework).we handle with large volume of data

    whare the best practices in this case?

    can we use large complex queries in ORM.(Is it a best practice )?


    In the ORM model queries should be straight forward and the complex logic should be business component for better unit testing.


    if there are complex queries, can we stick with and storeprocs?

    Please let me know if you need any more iformation on this

    Thanks in advance.



    Tuesday, January 15, 2013 8:48 AM

All replies

  • Hi,

    You can get starting from:

    If you care about the performance of Entity Framework, I recommend you take a look at this page:

    Wednesday, January 16, 2013 8:12 AM
  • I saw EF on complex queries and it was ok. A SQL query larger that 150kb, that I and others would never write manually (just because it is impossible to write such tangled thing manually without defects) had execution time less than half of second on small database and commodity server. Sure, we  precompiled LINQ query. Unfortunatelly, I did not use EF on databases larger than 10-20Gb so I cannot say how it will behave on large volumes.
    Thursday, January 17, 2013 1:11 PM