LINQ2SQL performance compared to regular DAL vs. NHibernate

Given a simple high traffic user web application (no fancy reporting / BI):

If my maximum goal is performance (not simplicity of maintainability, simplicity of queries, etc.), I would suggest that in most cases a DAL roll would be the best option.

However, if I were to choose Linq2SQL or NHibernate, about what we would like to talk about performance? 10%? 20%? 200%? Of the two, which would be faster?

Does anyone have real numbers in the world that could shed light on this? (and yes, I know that Stackoverflow works on Linq2SQL ..)

+3
source share
2 answers

( SQL ADO.NET), - , , DAL , ORM, Linq-to-SQL NHibernate.

, , , . , Rico Mariani Linq-to-SQL raw SQL, , Linq-to-SQL 90% SQL.

: http://blogs.msdn.com/ricom/archive/2007/07/05/dlinq-linq-to-sql-performance-part-4.aspx

, , , - : .

Entity Framework Linq-to-SQL DataReader DataTable.

NHibernate, .

+3

- ORM ado.net 1-2% CPU .

ORM DAL - .

+3

Source: https://habr.com/ru/post/1722484/


All Articles