具有LINQ支持的最完整的ORM? [英] Most complete ORM with LINQ support?

问题描述

我正在寻找一个提供完整或接近完整的LINQ支持的ORM.

I'm looking for an ORM that offers complete or near-complete LINQ support.

LINQ to SQL
-支持LINQ内部的所有内容(.contains，Math.Log等)
-无法在不创建新的数据上下文的情况下渴望加载关系属性

LINQ to SQL
- Supports about everything inside of LINQ (.Contains, Math.Log, etc)
- Cannot eager load relationship properties without creating a new datacontext

ADO.NET实体框架
-糟糕的LINQ支持(很多缺少的功能).
-强大的地图功能 -可以通过ObjectQuery<>

ADO.NET Entity Framework
- Terrible LINQ support (lots of missing features).
- Great mapping features - Can eager load on demand with .Include methods on an ObjectQuery<>

LightSpeed
-出色的LINQ支持缺少某些功能(.where包含在其中)
-生成的某些SQL效率很低.

LightSpeed
- Great LINQ support missing some features (.Contains within a Where)
- Some of the SQL generated is very inefficient.

这些似乎都不是完美的，老实说，我希望我能从每一个中得到点点滴滴.我个人非常喜欢ADO.NET EF，但缺少的功能使其使用起来令人沮丧.

None of these seem to fit just perfectly, I honestly wish I could take bits and pieces from each. I personally really like ADO.NET EF except the features it is missing make it just frustrating to use.

我知道有人赞扬NHibernate，但我并没有敲它，但我今天花了很多时间尝试它，还可以，但是它对LINQ的支持不是那么好.

I know some people praise NHibernate up and down and I'm not knocking it but I spent today trying it out and it's ok but it's LINQ support is not that great.

推荐答案

使用Linq到NHibernate的NHibernate

NHibernate with Linq to NHibernate

这篇关于具有LINQ支持的最完整的ORM?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！