. NET (C #) Mainstream ORM Overview

• Sqlsugar (Domestic)
• Dos.orm (Domestic)
• Chloe (Domestic)
• Stackexchange/dapper (Foreign)
• Entity Framework (EF) (foreign)
• NHibernate (Foreign)
• Servicestack/servicestack.ormlite (Foreign)
• LINQ2DB (Foreign)
• Massive (Foreign)
• Petapoco (Foreign)

Sqlsugar

Sqlsugar is a. NET-based ORM framework developed by Chinese developers, and is a high-performance, lightweight ORM framework that can run on. NET 4.+ &. NET core, numerous. NET Framework, the most easily used database access technology.

Characteristics:

• Open Source, free
• Development and maintenance of domestic developers;
• Support for. NET Core;
• Support the mainstream database, such as: SQL server,mysql,oracle,sqlite, etc.;
• Maintain updates in a timely manner

Recommended level: ★★★★☆

Petapoco

Petapoco: The ORM Framework for lightweight Poco objects and database mappings.

Characteristics:

• Open Source, free

Recommended level: ★★★★☆

Linq2db

LINQ2DB is also a fast, lightweight, type-safe ORM Framework for Poco objects and database mappings. In terms of architecture, LINQ2DB is a further encapsulation of micro-orm such as Dapper, Petapoco, but it is not as cumbersome as the Entity Framework. It does not implement state tracking, it needs to handle the state changes of the entity itself, and so on.

Recommended level: ★★★★☆

Dos.orm

Dos.orm (formerly Hxj.data) was released in 2009, officially open source in 2015. Nbear and Mysoft were consulted during the development process, absorbing some of their essences, adding new ideas, and referencing EF's lambda syntax for a number of extensions. This component has been applied in hundreds of mature projects. Official website: Http://ITdos.com/Dos/ORM/Inde ...

Characteristics:

• Open Source, free
• Easy to get started, 0 learning costs. Easy to use, write C # According to your SQL writing habits. NET code. Powerful features
• High performance, close to handwritten SQL
• Small size (less than 150kb, only one DLL)
• Perfect support for SQL Server (2000 to latest version), Mysql,oracle,access,sqlite and other databases
• Supports a large number of lambda expressions, the highest level of domestic ORM support, open source China ORM ranked top three
• No need for XML configuration like NHibernate, no need for various database connection drivers like EF
• Follow the MIT open Source agreement, except for no change of name, other optional custom modifications

Recommended level: ★★★☆☆

Servicestack.ormlite

The goal of Servicestack.ormlite is to provide a convenient, non-intrusive, non-configurable RDBMS-agnostic type of encapsulation that maintains a high degree of alignment with SQL and presents an intuitive API to generate predictable SQL.
Servicestack.ormlite Purpose: Fast, simple, Typed ORM for. NET

Characteristics:

• Open source, charge (free version only supports single Library 10 sheets)

Recommended level: ★★★☆☆

Entity Framework (EF)

The ADO-Entity Framework is an object-relational (O/R Mapping) solution developed by Microsoft on the basis of ADO. The framework was once part of the. NET Framework, but was detached from the. NET Framework after version 6.

Recommended level: ★★★☆☆

NHibernate

NHibernate is an object/relational database mapping tool for the. NET environment. The term object/relational database mapping (Object/relational mapping,orm) represents a technique used to map objects represented by object models to SQL-based relational model data structures.

Characteristics:

• Open Source, free
• Bulk Write
• Bulk read/Multi-query feature (I understand that is the future?) ）
• Bulk load of collections
• A collection with lazy= "Extra"
• Collection Filters and Paging collections
• Second-level cache (actually, NH's level two cache looks simple too?) ）
• Integration and extensibility
• Code generation, reduced code and SQL development, freeing developers from open sql,ado.net and transactions, caches, and other underlying

Recommended level: ★★★☆☆

Massive

Massive: Small, dynamic micro-ORM framework.

Recommended level: ★★★☆☆

. NET (C #) Mainstream ORM Overview