I guess one way to explain is that an ORM is NOT a data access layer. Its purpose is to retreive and persist objects and, if possible, make them queryable.
While NHibernate is possibly the best ORM out there when it comes to handling legacy databases, if you have an existing database and just want easy access to it, using an ORM is likely not your best option. The case explained here, with 75000 records, is something that is highly unlikely in an object domain. If you need it, take the performance penalty or sidestep NHibernate. It's perfectly fine to do that. /G 2012/3/20 Harshil Hameed <[email protected]> > why Nhibernate ,what are the 'nhibernate scenario' ,pls let me know,we > already start a project with Nhibernate, > > there is any ORM tool which give average performance compare to ADO.NET. > i am a great fan of ORM.pls.., > > > Regards, > Harshil > > > > > On Tue, Mar 20, 2012 at 3:14 PM, Mark Cranness <[email protected]>wrote: > >> On 19 March 2012 16:46, Chinna <[email protected]> wrote: >> > I have been evaluating the performance of NHibernate and ADO.NET. I >> > have created a test application which has an Employee table with >> > 75,000 records. When I try to get data using NHibernate it is very >> > slow compare to ADO.NET, it’s about 290% (approx.) slower. >> >> See: http://ormbattle.net/ , which reports a similar slowdown for >> NHibernate cf. SqlClient (see Performance scorecard > Multiple >> Operations > Create Instance). >> >> It's the price you pay for the power that an ORM gives. >> >> -- >> You received this message because you are subscribed to the Google Groups >> "nhusers" group. >> To post to this group, send email to [email protected]. >> To unsubscribe from this group, send email to >> [email protected]. >> For more options, visit this group at >> http://groups.google.com/group/nhusers?hl=en. >> >> > -- > You received this message because you are subscribed to the Google Groups > "nhusers" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]. > For more options, visit this group at > http://groups.google.com/group/nhusers?hl=en. > -- You received this message because you are subscribed to the Google Groups "nhusers" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/nhusers?hl=en.
