. Net – complex query of ORM (especially NHibernate) performance

Our company is rewriting the existing application from scratch This application and other tasks perform complex SQL queries against order and invoice data to generate sales reports Queries are built dynamically based on user selected criteria, so if multiple criteria are selected, they can be very complex At present, the performance is decent, but not very big

Now, for the new version, we want to use an ORM, possibly NHibernate, because it is obviously the only application that supports Oracle Lite (the application uses Oracle or Oracle Lite, depending on whether it runs in connected mode or disconnected mode) But I'm worried about the performance of NHibernate generated queries I cooperated with other orm in the previous (LINQ to SQL, Entity Framework), but the query is very simple, so there is no performance problem

So before I decide to use ORM or simple SQL, I want to know how these tools deal with situations such as external connections, sub queries, etc Do you think ORM (especially NHibernate) is applicable to the above reporting situation? Should I worry about the performance of complex queries?

Any feedback will be appreciated

Solution

See this chart There are no DataObjects Net, but the results compared with EF and NHibernate are shown here

The LINQ test code of EF is here; The versions of other tools can be found in the same folder All this CS files are generated by a single T4 template, so the test is exactly the same The model used is Northwind

More links:

> LINQ test description > FAQs.