2

I want to select one of the above orm. What is the difference between nhibernate and entity framework in batching?

masoud ramezani
  • 22,228
  • 29
  • 98
  • 151

2 Answers2

4

NHibernate can:

  • Send multiple updates/inserts/deletes at once
  • Load multiple proxies of a type at once
  • Load multiple collections of a type at once
  • Execute object oriented DML statements
  • Manually group queries in a single roundtrip (multiqueries, futures)

EF can:

  • None of the above
Diego Mijelshon
  • 52,548
  • 16
  • 116
  • 154
3

The difference is that EF natively doesn't have any command batching so every update, insert or delete is executed in separate round trip to the database - but in my previous question are some links to workarounds. EF also doesn't have any alternative to NHibernate future queries (way to batch multiple queries to single database round trip).

Community
  • 1
  • 1
Ladislav Mrnka
  • 360,892
  • 59
  • 660
  • 670
  • 1
    Is this still the case 2 years later with the lack of future queries? – Mike Cole Apr 09 '13 at 21:51
  • 1
    @MikeCole: If we talk about EF the answer is yes. There are some open source projects making this little bit better but it is still far from real built-in solution. – Ladislav Mrnka Apr 09 '13 at 22:02