Best ORM for C #

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, ... Read more

How to get rid of duplicate joines with intersecting ForeignKey in Django?

Noticed such a nasty thing. Suppose there is a model that is connected by two others with the same ForeignKey. class File(models.Model):<br/> &nbsp;&nbsp;&nbsp;&nbsp;#some stuff<br/> &nbsp;&nbsp;&nbsp;&nbsp;pass<br/> <br/> class ServerFile(models.Model):<br/> &nbsp;&nbsp;&nbsp;&nbsp;<b>file = models.ForeignKey('File')</b><br/> &nbsp;&nbsp;&nbsp;&nbsp;#some stuff<br/> <br/&... Read more

Where to find an article about creating your own ORM

I remember on Habré there was an article about creating ORM. The article was unique in capacity. But I read from the phone and did not save the bookmarks. In fact, there was an introduction to the object model and the structure of the tables (5-6 pieces) Maybe you can remember and find? Or at least help to choose the best article in this topic. Thank you in advance. Read more

Generator of model classes (and / or mappers) for Zend Framework

Are there solutions to generate ready-made model classes with CRUD functionality (create, read, update, delete) or ORM mappers for an application implemented on the Zend Framework SQL dump of the base, just as it is implemented, for example, in the Yii framework? Read more

Working with the database in OOP applications in php 5.3

Tell us, who uses what for working with the database (MySQL)? Do you use ORM? If so, which one? If not, how do you solve the many-to-many connectivity problem through the third table? Do you create an object for the third table? I ask, because I have not been tormented for the first week - what to choose. Doctrine is recommended everywhere. I used it for my bike a year or two ago (the version was then 1 stable). Seemed unnecessarily redundant and terribly inhibitory. Then the compilation... Read more


Greetings! Write, please, with what ORM have you worked with and what advantages / disadvantages do they have? Read more

Help with ORM in Kohana 3.1

The scheme is quite nontrivial, and I can not translate it into ORM. Writing via Query Builder will not work, as you have to shovel hundreds of lines with ORM objects. The Owner field refers to the users table of the Auth module, if interested. The problem is in the three fields of the events table that refer to the PRIMARY KEY days table. How to describe them? Constantly pops up an error when trying to write. Here are the models without the damn fields:  class Model_Event e... Read more

ORM Hibernate: Problem with mapping

Good day! For several weeks, unsuccessfully trying to solve the problem with Hiberneyt (( I re-read a bunch of documentation, google everything I could ... Tell me, please, what is the error? What am I doing wrong?  Схема БД: Mapping: (I use lombok library to generate getters / setters) User.java Copy Source | Copy HTML @Entity @Table(name = "users") public @Data class User {       // Base Mapping       @Id     @GeneratedValue(strategy = Gen... Read more

What is ORM for?

No, I don’t understand why replacing SQL with my own? Why do we need a class whose methods take the name of a table, accept the condition for the phrases WHERE, GROUP BY, HAVING. In essence, the SQL language was replaced by its own language. And besides, this language is limited to the methods that the ORM provides. Neither you need to pee hierarchical requests, nor you make an internal select. So what's the profit? Read more

Validation Kohana 3.1 + Standard ORM

Show with an example how you validate data when creating two related models. Introductory: There is an ORM user model and an ORM user_contacts model. In theory, the entire validation, we must describe the filters in the models using function rules () and function filters (). We must catch validation errors using the try {} catch () {} construct. The user_contacts model cannot be created without the user model. Data is entered and sent at one time (one form for two models). In the user model,... Read more

Useful Links