Best ORM to use with C# 4.0 [closed]

by

UPDATE 2016

Six years later things are VERY different. NHibernate is all but abandoned, other alternatives were abandoned (eg Subsonic), Entity Framework is perhaps the most common full-featured ORM, and people have been moving to micro ORMs like Dapper for years, to map from queries to objects with a minimum of overhead.

The application scenarios have also changed. Instead of loading and caching one big object graph at the expense of memory and performance, Web Services and REST APIs need to service a high number of smaller requests. This means that a full ORM’s overhead is no longer acceptable.

This means that patterns and techniques like Active Record, transaction per request etc have become throughput and scalability killing anti-patterns

One of the most important features nowadays is asynchronous execution , to reduce thread and CPU waste due to waits. NHibernate never made this transition.

Original Answer

Define “best”: Is it the most mature, the one with more documentation, bigger community, more mainstream?

NHibernate is more mature, feature rich, with a more advanced community and not likely to be discontinued when MS decides to break compatibility again. Entity Framework is more mainstream and is supported out-of-the-box. You will find more beginner books for EF, more advanced books for NH.

A good option would be to try one of the simpler ORMs like Subsonic and move to more advanced ORMs once you understand how ORMs work, what are the various pitfalls, what SELECT N+1 means [:P]

Just don’t try to create your own ORM, there are several dozens out there already! Subsonic, Castle ActiveRecord, NH, EF (of course), LLBLGenPro…

More Related Contents:

  1. sort in Ascending Order [closed]
  2. What are the true benefits of ExpandoObject?
  3. C# Create New T()
  4. How to get DateTime from the internet?
  5. Using a custom type discriminator to tell JSON.net which type of a class hierarchy to deserialize
  6. Random number in long range, is this the way?
  7. Start may not be called on a promise-style task. exception is coming
  8. How does one configure HttpClient not to automatically redirect when it receives a 301 HTTP Status Code?
  9. How do I check if a property exists on a dynamic anonymous type in c#?
  10. Convert an int to bool with Json.Net [duplicate]
  11. Does not contain a constructor that takes 0 arguments
  12. C# 4.0 optional out/ref arguments
  13. C# operator overload for `+=`?
  14. Dynamically implementing an interface in .NET 4.0 (C#)
  15. HttpClient vs HttpWebRequest
  16. Checking for diacritics with a regular expression
  17. Is there a Threadsafe Observable collection in .NET 4?
  18. Converting a LEFT OUTER JOIN to Entity Framework
  19. TPL TaskFactory.FromAsync vs Tasks with blocking methods
  20. Entity Framework and forced Inner Join
  21. How to create a method at runtime using Reflection.emit
  22. Drag-and-Drop multiple Attached File From Outlook to C# Window Form
  23. Redirect from asp.net web api post action
  24. Change C++/CLI project to another framework than 4.0 with vs2010
  25. Contract-First SOA: Designing Business Domain: WCF
  26. Is there such thing CASE expression in JPQL?
  27. How to use different datasources in a Query using cakephp3?
  28. How do you join two tables on a foreign key field using django ORM?
  29. Can you use optional parameters in code targeting .NET 3.5?
  30. Json.NET adding backslash while returning json serialized string

Leave a Comment