.NET有什么好用的 ORM框架

myNameIsLina 2016-09-25 09:00:07

SqlSugar.ORM 语法比较简洁性能也很强大



/2表关联查询

                var jList = db.Queryable<Student>()

                .JoinTable<School>((s1, s2) => s1.sch_id == s2.id) //默认left join

                .Where<School>((s1, s2) => s1.id == 1)

                .Select("s1.*,s2.name as schName")

                .ToDynamic();



                /*等于同于

                 SELECT s1.*,s2.name as schName 

                 FROM [Student]  s1 

                 LEFT JOIN [School]  s2 ON  s1.sch_id  = s2.id 

                 WHERE  s1.id  = 1 */



                //2表关联查询并分页

                var jList2 = db.Queryable<Student>()

                .JoinTable<School>((s1, s2) => s1.sch_id == s2.id) //默认left join

                    //如果要用inner join这么写

                    //.JoinTable<School>((s1, s2) => s1.sch_id == s2.id ,JoinType.INNER)

                .Where<School>((s1, s2) => s1.id > 1)

                .OrderBy(s1 => s1.name)

                .Skip(10)

                .Take(20)

                .Select("s1.*,s2.name as schName")

                .ToDynamic();



                //3表查询并分页

                var jList3 = db.Queryable<Student>()

               .JoinTable<School>((s1, s2) => s1.sch_id == s2.id) // left join  School s2  on s1.id=s2.id

               .JoinTable<School>((s1, s3) => s1.sch_id == s3.id) // left join  School s3  on s1.id=s3.id

               .Where<School>((s1, s2) => s1.id > 1)  // where s1.id>1

               .Where(s1 => s1.id > 0)

               .OrderBy<School>((s1, s2) => s1.id) //order by s1.id 多个order可以  .oderBy().orderby 叠加 

               .Skip(10)

               .Take(20)

               .Select("s1.*,s2.name as schName,s3.name as schName2")//select目前只支持这种写法

               .ToDynamic();





                //上面的方式都是与第一张表join，第三张表想与第二张表join写法如下

                List<V_Student> jList4 =

                 db.Queryable<Student>()

                 .JoinTable<School>((s1, s2) => s1.sch_id == s2.id) // left join  School s2  on s1.id=s2.id

                 .JoinTable<School, Area>((s1, s2, a1) => a1.id == s2.AreaId)// left join  Area a1  on a1.id=s2.AreaId  第三张表与第二张表关联

                 .JoinTable<Area, School>((s1, a1, s3) => a1.id == s3.AreaId)// left join  School s3  on a1.id=s3.AreaId  第四第表第三张表关联

                 .JoinTable<School>((s1, s4) => s1.sch_id == s4.id) // left join  School s2  on s1.id=s4.id

                 .Select<School, Area, V_Student>((s1, s2, a1) => new V_Student { id = s1.id, name = s1.name, SchoolName = s2.name, AreaName = a1.name }).ToList();

Dapper ORM 性能也不错就是功能太少



using (var conn = new SqlConnection(ConnString))

	{

		conn.Open();

		var r=conn.Execute(@"insert Person(username, password,age,registerDate,address) values (@a, @b,@c,@d,@e)",

		new [] { 

			new { a = 1, b = 1, c = 1, d = DateTime.Now, e = 1 }

			, new { a = 2, b = 2, c = 2, d = DateTime.Now, e = 2 }

			, new { a = 3, b = 3, c = 3, d = DateTime.Now, e = 3 } 

		}

                conn.Close();

         }

Petapoco



PetaPoco可以自动转换：



var a = db.SingleOrDefault<article>("WHERE id=@0", 123);

转换为：



var a = db.SingleOrDefault<article>("SELECT col1, col2, col3 FROM articles WHERE id=@0", 123);

现在它也会处理这个问题：



var a = db.SingleOrDefault<article>("FROM whatever WHERE id=@0", 123);

只发现了这3个，还有没有好的推荐

...全文

3016 29 打赏收藏转发到动态举报

写回复

用AI写文章

29 条回复

切换为时间正序

请发表友善的回复…

发表回复

bluedoctor 2020-05-08

打赏
举报

SOD框架，不仅仅是一个ORM框架，还有SQL-MAP功能。
https://github.com/znlgis/sod

dotnetCore 2020-04-26

打赏
举报

https://github.com/dotnetcore/FreeSql 单元测试数量4000+，github star 1500+，支持.net framework4.0+ 支持 CodeFirst 迁移，哪怕使用 Access 数据库也支持；支持 DbFirst 从数据库导入实体类，安装实体类生成工具；支持深入的类型映射，比如pgsql的数组类型；支持丰富的表达式函数，以及灵活的自定义解析；支持导航属性一对多、多对多贪婪加载，以及延时加载；支持读写分离、分表分库、过滤器、乐观锁、悲观锁；支持 MySql/SqlServer/PostgreSQL/Oracle/Sqlite/达梦数据库/Access；