The essence of the problem is as follows: it is required to store information on the state of the object in the database (for example, we monitor the valve at the pump station of the second lift). The parameters of the observed unit can be many - it is temperature, vibration, current values, the percentage of rotation. In addition, it is necessary to save the so-called temporary "snapshots" (values of all parameters) of the state of the unit with a given frequency, for example, once a minute, or upon an event (when opening the valve), in order to be able to analyze any abnormal situations.
I want to work with data as objects at the highest level, having the functions of a query and recording their state without deep diving into SQL. I thought about using ORM, as in my opinion they are intended for this purpose. In general, advise any standing system.
Answers
But it has one global flaw - it is not free (I do not consider the Express version seriously, the restriction of 8 model objects is too constraining).
Next - anyone who approaches this issue, certainly faces a fork - the 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-ovsky goodies. NHibernate, as mentioned above, is better to use with Fluent-NHibernate, if you don’t like writing tons of XML :)
In addition, if you need to use the ActiveRecord pattern (it can be very applicable in your case) - you should definitely watch NHibernate and SubSonic.
Because I only used it, I can’t recommend another one ... I can also try EntityFramework, but after using NHibernate, I didn’t like the configuration of displaying objects on the base.