您所在的位置：程序员俱乐部 > 编程开发 > .NET > .NET ORM 哪家强

.NET ORM 哪家强

2016/7/15 5:32:46 孙凯旋程序员俱乐部我要评论(0)

摘要：ORM到底哪家强？很多人都想知道这个问题，自已也没测试过，只能道听途说。闲的无聊就将几个ORM拿出来比一比，假如怀疑测试代码有问题可以将它下载下来慢慢研究。参赛ORM1、SqlSugar：是一款轻量级的MSSQLORM，除了具有媲美ADO的性能外还具有和EF相似简单易用的语法，地址：http://www.cnblogs.com/sunkaixuan/p/5654695.html2、ChloeORM：模仿EF代码风格与设计的一款轻量级高性能ORM，地址：http://www.cnblogs
标签：.net net

ORM到底哪家强？很多人都想知道这个问题，自已也没测试过，只能道听途说。

闲的无聊就将几个ORM拿出来比一比，假如怀疑测试代码有问题可以将它下载下来慢慢研究。

参赛ORM

1、SqlSugar：是一款轻量级的MSSQL ORM ，除了具有媲美ADO的性能外还具有和EF相似简单易用的语法，地址：http://www.cnblogs.com/sunkaixuan/p/5654695.html

2、Chloe ORM：模仿EF代码风格与设计的一款轻量级高性能ORM ，地址：http://www.cnblogs.com/so9527/

3、Dapper ORM : 是一个轻型的ORM类。代码就一个SqlMapper.cs文件,主要是IDbConnection的扩展方法，官方站点http://code.google.com/p/dapper-dot-net/ ，也可以通过Nuget进行安装

4、EF6.0： .NET官方ORM

测试结果：

从测试代码可以看出 SqlSugar Dapper Chloe的性能都是差不多的，EF就有些不尽人意

将EF改成AsNoTracking又测了几次，【查询所有】性能有所提升但是还是最慢，查询单条和分页AsNoTracking貌似没什么效果

测试代码切片

class="code_img_closed" src="/Upload/Images/2016071505/0015B68B3C38AA5B.gif" alt="" />

using System.Data.Entity;
using System.Data.Entity.ModelConfiguration.Conventions;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using SqlSugar;
using SyntacticSugar;
using Dapper;
using System.Data.SqlClient;
using System;
using Chloe.SqlServer;

namespace ORMTest
{
    /// <summary>
    /// 查询所有
    /// </summary>
    public class SelectAll
    {
        public static void Execute(int count,string title) {

            Console.WriteLine(title);
            PerHelper.Execute(count, " SqlSugar Queryable ", () =>
            {
                using (SqlSugarClient db = new SqlSugarClient(ConfigSugar.GetConfigString("SchoolContext")))
                {

                    var list = db.Queryable<Student>().ToList();

                }
            });

            PerHelper.Execute(count, " SqlSugar Sqlable ", () =>
            {
                using (SqlSugarClient db = new SqlSugarClient(ConfigSugar.GetConfigString("SchoolContext")))
                {

                    var list = db.Sqlable().From<Student>("t").SelectToList<Student>("*");

                }
            });


            PerHelper.Execute(count, " SqlSugar SqlQuery ", () =>
            {
                using (SqlSugarClient db = new SqlSugarClient(ConfigSugar.GetConfigString("SchoolContext")))
                {

                    var list = db.SqlQuery<Student>("select * from Student");

                }
            });


            PerHelper.Execute(count, " Chloe ORM Query", () =>
            {
                using (MsSqlContext context = new MsSqlContext(ConfigSugar.GetConfigString("SchoolContext")))
                {
                    var list = context.Query<Student>().ToList();
                }
            });

            PerHelper.Execute(count, " Chloe ORM  SqlQuery", () =>
            {
                using (MsSqlContext context = new MsSqlContext(ConfigSugar.GetConfigString("SchoolContext")))
                {
                    var list = context.SqlQuery<Student>("select * from Student").ToList();
                }
            });

            PerHelper.Execute(count, " EF6.0 ", () =>
            {
                using (SchoolContext sc = new SchoolContext())
                {
                    var list = sc.Students.AsNoTracking().ToList();
                }
            });


            PerHelper.Execute(count, " Dapper Sql ", () =>
            {
                using (SqlConnection conn = new SqlConnection(ConfigSugar.GetConfigString("SchoolContext")))
                {
                    var list = conn.Query<Student>("select * from Student").ToList(); ;
                }
            });


            Console.WriteLine("");
        }
    }
}

查询所有

using System.Data.Entity;
using System.Data.Entity.ModelConfiguration.Conventions;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using SqlSugar;
using SyntacticSugar;
using Dapper;
using System.Data.SqlClient;
using System;
using Chloe.SqlServer;
using Chloe;

namespace ORMTest
{
    /// <summary>
    /// 查询分页
    /// </summary>
    public class SelectPage
    {
        public static void Execute(int count,string title) {

            Console.WriteLine(title);
            PerHelper.Execute(count, " SqlSugar Queryable ", () =>
            {
                using (SqlSugarClient db = new SqlSugarClient(ConfigSugar.GetConfigString("SchoolContext")))
                {

                    var list = db.Queryable<Student>().OrderBy("id").ToPageList(10,20);

                }
            });

            PerHelper.Execute(count, " SqlSugar Sqlable ", () =>
            {
                using (SqlSugarClient db = new SqlSugarClient(ConfigSugar.GetConfigString("SchoolContext")))
                {

                    var list = db.Sqlable().From<Student>("t").SelectToPageList<Student>("*","id",10,20);

                }
            });


            PerHelper.Execute(count, " SqlSugar SqlQuery ", () =>
            {
                using (SqlSugarClient db = new SqlSugarClient(ConfigSugar.GetConfigString("SchoolContext")))
                {

                    var list = db.SqlQuery<Student>("select * from(select *,row_number() over(order by id) as r from Student  ) t where t.r between @b and @e",new { b=181,e=200});

                }
            });

            PerHelper.Execute(count, " Chloe ORM Queryable ", () =>
            {
                using (MsSqlContext context = new MsSqlContext(ConfigSugar.GetConfigString("SchoolContext")))
                {
                    var list = context.Query<Student>().Skip(180).Take(20).ToList();
                }
            });

            PerHelper.Execute(count, " Chloe ORM  SqlQuery", () =>
            {
                using (MsSqlContext context = new MsSqlContext(ConfigSugar.GetConfigString("SchoolContext")))
                {
                    var list = context.SqlQuery<Student>("select * from(select *,row_number() over(order by id) as r from Student  ) t where t.r between @b and @e", new DbParam[] {
                        DbParam.Create("@b", "181"),
                        DbParam.Create("@e", "200")
                    }).ToList();
                }
            });

            PerHelper.Execute(count, " EF6.0 ", () =>
            {
                using (SchoolContext sc = new SchoolContext())
                {
                    var list = sc.Students.OrderBy(it=>it.id).Skip(180).Take(20).AsNoTracking().ToList();
                }
            });


            PerHelper.Execute(count, " Dapper Sql ", () =>
            {
                using (SqlConnection conn = new SqlConnection(ConfigSugar.GetConfigString("SchoolContext")))
                {
                    var list = conn.Query<Student>("select * from(select *,row_number() over(order by id) as r from Student  ) t where t.r between @b and @e", new { b = 181, e = 200 }).ToList(); ;
                }
            });


            Console.WriteLine("");
        }
    }
}

查询分页

using System.Data.Entity;
using System.Data.Entity.ModelConfiguration.Conventions;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using SqlSugar;
using SyntacticSugar;
using Dapper;
using System.Data.SqlClient;
using System;
using Chloe.SqlServer;
using Chloe;

namespace ORMTest
{
    /// <summary>
    /// 查询单条
    /// </summary>
    public class SelectSingle
    {
        public static void Execute(int count,string title) {

            Console.WriteLine(title);
            PerHelper.Execute(count, " SqlSugar Queryable ", () =>
            {
                using (SqlSugarClient db = new SqlSugarClient(ConfigSugar.GetConfigString("SchoolContext")))
                {

                    var list = db.Queryable<Student>().Where(it=>it.id==1).ToList();

                }
            });

            PerHelper.Execute(count, " SqlSugar Sqlable ", () =>
            {
                using (SqlSugarClient db = new SqlSugarClient(ConfigSugar.GetConfigString("SchoolContext")))
                {

                    var list = db.Sqlable().From<Student>("t").Where("id=@id").SelectToList<Student>("*", new { id = 1 });

                }
            });


            PerHelper.Execute(count, " SqlSugar SqlQuery ", () =>
            {
                using (SqlSugarClient db = new SqlSugarClient(ConfigSugar.GetConfigString("SchoolContext")))
                {

                    var list = db.SqlQuery<Student>("select * from Student where id=@id",new { id=1});

                }
            });


            PerHelper.Execute(count, " Chloe ORM  Queryable", () =>
            {
                using (MsSqlContext context = new MsSqlContext(ConfigSugar.GetConfigString("SchoolContext")))
                {
                    var list = context.Query<Student>().Where(it=>it.id==1).ToList();
                }
            });

            PerHelper.Execute(count, " Chloe ORM  SqlQuery", () =>
            {
                using (MsSqlContext context = new MsSqlContext(ConfigSugar.GetConfigString("SchoolContext")))
                {
                    var list = context.SqlQuery<Student>("select * from Student where id=@id", DbParam.Create("@id", "1")).ToList();
                }
            });

            PerHelper.Execute(count, " EF6.0 ", () =>
            {
                using (SchoolContext sc = new SchoolContext())
                {
                    var list = sc.Students.Where(it=>it.id==1).AsNoTracking().ToList();
                }
            });


            PerHelper.Execute(count, " Dapper Sql ", () =>
            {
                using (SqlConnection conn = new SqlConnection(ConfigSugar.GetConfigString("SchoolContext")))
                {
                    var list = conn.Query<Student>("select * from Student where id=@id",new { id=1}).ToList(); ;
                }
            });


            Console.WriteLine("");
        }
    }
}

查询单条

using System;
using System.Collections.Generic;
using System.Data.Entity;
using System.Data.Entity.ModelConfiguration.Conventions;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using SqlSugar;
using SyntacticSugar;

namespace ORMTest
{
    public class PerHelper
    {
        public static void Execute(int count, string title, Action fun)
        {
            PerformanceTest ptef = new PerformanceTest();
            ptef.SetIsMultithread(false);//开启多线程
            ptef.SetCount(count);//执行count次
            ptef.Execute(
                        i =>
                        {
                            fun();

                        },
                        res =>
                        {
                            Console.WriteLine($"执行{count}次，{title}{res}");
                        });

        }
    }
}