.NET mainstream ORM function introduction encyclopedia latest

.NET mainstream ORM function introduction complete latest

​

.NET mainstream ORM

The following are the 3 most commonly used ORMs for .NET. They come from the voting results of public accounts. The data is relatively real and reliable. You can also search the public accounts to continue voting

1. Introduction to SqlSugar ORM

It is an old .NET open source multi-library architecture ORM framework (EF Core single database architecture), maintained and updated by the Fructose big data technology team. It is the easiest to use .NET ORM framework out of the box. The ecosystem is rich. Currently, the open source ecosystem is second only to EF Core, but SqlSugar is preferred among projects or products that require multi-library compatibility

1.1 ORM Getting Started Example

      //Create a database object (the usage is the same as EF Dapppper to ensure thread safety through new)
      SqlSugarClient Db= new SqlSugarClient(new ConnectionConfig(){
            ConnectionString = "Connector string",
            DbType = DbType.SqlServer,
            IsAutoCloseConnection = true});
      
      //Create table
      //db.CodeFirst.InitTables(); See more about document migration
            
      //Query all of the table
      var list = db.Queryable().ToList();
      
      //insert
      db.Insertable(new Student() { SchoolId = 1, Name = "jack" }).ExecuteCommand();
      
      //renew
      db.Updateable(new Student() { Id = 1, SchoolId = 2, Name = "jack2" }).ExecuteCommand();
      
      //delete
      db.Deleteable().Where(it => it.Id == 1).ExecuteCommand();
 
    
 
        
 
     //The entity has the same structure as the database
     public class Student
     {
      //The data is self-increasing and needs to be added with IsIdentity
      //The database is the primary key and needs to be added with IsPrimaryKey
      //Note: Two attributes must be completely consistent with the database
      [SugarColumn(IsPrimaryKey = true, IsIdentity = true)]
      public int Id { get; set; }
      public int? SchoolId { get; set; }
      public string Name { get; set; }
      }
 Click and drag to move
 

1.2 SqlSugar ORM out of the box (supports AOT）

1. An ORM that can truly implement zero Sql and has a super query system: navigation query, joint table query, union query, subquery, report query, etc.

2. Supports .NET million-level [big data] writing and updating, sub-tables and billions of queries and statistics, etc. Has mature solutions

3. Support SAAS complete application cross-database query, auditing, tenant sub-database, tenant sub-table and tenant data isolation

4. Support [low code] + workflow (dynamic class creation, dynamic table creation, non-entity multi-database compatible with CRUD, JSON TO SQL, custom XML, etc.)

5. .NET ORM with the coolest syntax, beautiful expressions, warehousing, UnitOfWork, DbContext, AOP

6. Supports 3 development modes: DbFirst, CodeFirst (no command migration) and [WebFirst]

7. Simple and easy to use, complete functions, high performance, lightweight, complete services, official website tutorial documents, professional technical support 18 hours a day

1.3 SqlSugar database support

SqlSugar Feature 1: Super simple

You can have the best experience without using any design patterns or any framework. SqlSugar provides a nanny-like service and can be used directly without learning

framework, various default values ​​​​are optimal configurations, just read the documentation for what to use.

SqlSugar Feature 2: Product Essentials

1. Low code support: string to exp, exp to string, exp to sql, List