The best ORM for C#

0 like 0 dislike
23 views
The essence of the problem: you want to store in the database information about the state of the object (for example, monitor the valve at the pumping station of the second lifting). Parameters for the observed unit can be a lot is temperature, vibration, currents, percent of rotation. In addition, you must keep the so-called temporary "casts" (all parameter values) the unit status with a specified frequency, such as once per minute, or event (when opening the valve), then to have the ability to analyse any emergency situations.
I want to work with data as objects at the highest level, with query function, and record their condition without in-depth immersion in SQL. I thought about using an ORM, since in my opinion they it is intended to do. In General, advise any standing system.
by | 23 views

5 Answers

0 like 0 dislike
Interesting, but what about ORM for .NET I can definitely say that the best (really the best), than were given to use is LightSpeed from MindScape. In the first place because when designing I follow the paradigm of Domain-Driven Design, and there it is supported on 5+, and also thanks amazing speed.
But it has one global drawback — it is not free (Express version of I is not taken seriously, a limit of 8 objects the model is too constrained).
\r
Further — anyone who approaches this issue, is bound to face a fork — Entity Framework or NHibernate. Here is a matter of taste, personal preferences, and approach to development. NHibernate is much more Mature and "ready" than EF, but EF has visual designers and other MS-ovskie Goodies. NHibernate, as mentioned above, it is better to use Fluent-NHibernate, if you don't like to write tons of XML :)
\r
In addition, if you need to use the ActiveRecord pattern (it may be applicable in your case) — have to look at NHibernate and SubSonic.
by
0 like 0 dislike
above recommend NHibernate, but I believe that the author, who is not familiar with ORM, NHibrenate excess. The authors recommend to use Entity Framework 4, which is your one-stop visual editor and full support for LINQ (which is lame NHibernate).
by
0 like 0 dislike
Used NHibernate, Entity Framwork, Linq2Sql, Gentle.Net. IMHO NHibernate is currently the most flexible and the most advanced ORM. Immediately recommend to use it in conjunction with FluentNhibernate. ENtityFramework gradually is selected according to the capabilities of NHibernate, so if there is a desire to use anything directly from MS, use it.
by
0 like 0 dislike
NHibernate.
Since I use only them, the other I can not advise... you can Still try EntityFramework, but I do it after using NHibernate, did not like the display configuration of the objects in the database.
by
0 like 0 dislike
Perhaps it's all the same from a task depends heavily on the answer. For small projects it is suggested to BLToolkit. So I recommend the website ormbattle.net
by

Related questions

0 like 0 dislike
2 answers
0 like 0 dislike
1 answer
asked Mar 26, 2019 by alemiks
0 like 0 dislike
5 answers
0 like 0 dislike
2 answers
0 like 0 dislike
1 answer
110,608 questions
257,186 answers
0 comments
1,134 users