title: Most complete ORM with LINQ support?
body: <p>I'm looking for an ORM that offers complete or near-complete LINQ support.</p>
  
  <p>LINQ to SQL<br>
  - Supports about everything inside of LINQ (.Contains, Math.Log, etc)<br>
  - Cannot eager load relationship properties without creating a new datacontext</p>
  
  <p>ADO.NET Entity Framework<br>
  - Terrible LINQ support (lots of missing features).<br>
  - Great mapping features
  - Can eager load on demand with .Include methods on an ObjectQuery&lt;></p>
  
  <p>LightSpeed<br>
  - Great LINQ support missing some features (.Contains within a Where)<br>
  - Some of the SQL generated is very inefficient.</p>
  
  <p>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.</p>
  
  <p>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.</p>