Best ORM for C#

Question

ORM

The essence of the task is as follows: it is required to store information about the state of the object in the database (for example, we monitor the valve at the pumping station of the second lift). There can be many parameters for the observed unit - these are temperatures, vibrations, current values, percentage of rotation. In addition, it is necessary to save the so-called temporary “casts” (values ​​of all parameters) of the state of the unit with a given frequency, for example, once a minute, or by event (when the valve is opened), in order to be able to analyze any emergency situations later.
I want to work with data as with objects at the highest level, having the functions of querying and recording their state without deep immersion in SQL. I thought about using an ORM, because in my opinion that's what they are designed for. In general, advise some worthwhile system.

Answer 1

It's interesting, but it's about the ORM for .NET that I can say for sure that the best (really the best) that I have been able to use is LightSpeed ​​from MindScape. First of all, because when designing, I follow the Domain-Driven Design paradigm , and there it is supported on 5+, and also due to the amazing speed of work.
But it has one global drawback - it is not free (I do not seriously consider the Express version, the limitation of 8 model objects is too restrictive).
Further - anyone who approaches this issue will certainly come across a fork - Entity Framework or NHibernate. It is already a matter of taste, personal preferences, and the approach to development used. NHibernate is much more seasoned and "ready" than EF, but EF has visual designers, and other MS goodies. NHibernate, as mentioned above, is better to use with Fluent-NHibernate, unless you are a fan of writing tons of XML :)
In addition, if you need to use the ActiveRecord pattern (may be very applicable in your case), be sure to look at NHibernate and SubSonic.

Answer 2

NHibernate is recommended above, but I think that for an author who is not yet familiar with ORM, NHibernate is redundant. I recommend the author to use Entity Framework 4, which has the most convenient visual editor and full LINQ support (which NHibernate is lame in).

Answer 3

NHibernate.
Since I only used it, I can’t advise another ... You can also try EntityFramework, but after using NHibernate, I didn’t like the configuration for mapping objects to the base.

Answer 4

Probably the answer here depends on the problem. For small projects, I highly recommend BLToolkit. I also recommend ormbattle.net