I have always had a special liking for Orm. I have also used many ORM products during the development process. They have indeed brought us a lot of convenience and also brought us a lot of trouble:
1. It is annoying to define a model, whether it is to have a table first, then generate the Model Code; or define the model code first, and then generate the table in reverse order.
2. The associated query is complex. Although you can set crawling rules, it is still complicated.
3. I don't like persistent context (objectcontext [EF], session [nhib]) very much. Of course many people like this thing very much.
Based on the above reasons, microorm. net has been created. At present, there are some open-source micro-ORM products that will not be compared with these products here.
Home: http://code.google.com/p/micro-orm-net/
Features:
Dynamic & lightweight: Developed Based on. NET 4.0. dynamicobject is widely used.
Non-stronugly typed result support: the returned value can be dynamicobject, that is, a dynamic object.
Stronugly typed result support: the returned value can also be of the model type.
Multiple Database Support (currently only support SQL Server)
The following is a list of articles:
Microorm. Net (1) Overview
Microorm. Net (2) Basics and Dynamic Features
Microorm. Net (3) database, table, column, expression, math & mathe
Microorm. Net (4) Table. Query ()-Where
Microorm. Net (5) Table. Query ()-select
Microorm. Net (6) Table. Query ()-join & order
Microorm. Net (7) Table. Query ()-group by & having
Microorm. Net (8) Table. Query ()-distinct, skip & take
Microorm. Net (9) insert
Microorm. Net (10) Update
Microorm. Net (11) Delete
Microorm. Net (12) transactionscope & codescope
Microorm. Net (13) Discuss Table. Query ()-Where
Microorm. Net (14) Roadmap
Comparison between microorm. NET and existing ORM Products
Last point: many developers will ask if there are any large companies using one item to seek confidence. Currently, microorm. net is only used by my own projects. If you are afraid, you should not use it. If you are not afraid, microorm is used. net bug or reasonable needs, I will try my best to help you solve it.