How to implement Unit of Work that works with EF and NHibernate

by

As a side not building solution supporting different provides on top of the linq is way to disaster. Linq and IQueryable are leaky abstractions – each Linq provider can have its own “features” and limitations. Moreover EF itselfs adds some logic via custom extension methods for IQueryable (like Include or AsNoTracking in EFv4.1). These methods internally converts IQueryable to ORM specific classes.

If you want to have universal solution you must abandon Linq and add third pattern to form the abstraction. In addition to Repository and Unit of Work patterns you need custom Specification pattern. Generally you will reimplement NHibernate’s Criteria API.

More Related Contents:

  1. Convert String to Int in EF 4.0
  2. EF 4: Removing child object from collection does not delete it – why?
  3. The specified type member ‘Date’ is not supported in LINQ to Entities. Only initializers, entity members, and entity navigation properties
  4. Tradeoffs using NHibernate 3.0 QueryOver or LINQ provider
  5. NHibernate vs LINQ to SQL
  6. Convert this sql command to c# linq
  7. LINQ equivalent of foreach for IEnumerable
  8. Is it possible to Pivot data using LINQ?
  9. LINQ: Distinct values
  10. Entity Framework: There is already an open DataReader associated with this Command
  11. LINQ-to-SQL vs stored procedures? [closed]
  12. Entity framework linq query Include() multiple children entities
  13. How to view LINQ Generated SQL statements?
  14. How to view LINQ Generated SQL statements?
  15. LINQ across multiple databases
  16. Entity Framework/Linq EXpression converting from string to int
  17. LINQ Join with Multiple Conditions in On Clause
  18. How can I reject all changes in a Linq to SQL’s DataContext?
  19. LINQ with SQLite (linqtosql)
  20. Entity Framework – “Unable to create a constant value of type ‘Closure type’…” error
  21. Sum of items in a collection
  22. NHibernate How do I query against an IList property?
  23. How to dynamically add OR operator to WHERE clause in LINQ
  24. Linq To Sql – Dynamic OrderBy – Case When
  25. Creating dynamic queries with entity framework
  26. Entity Framework 4 Single() vs First() vs FirstOrDefault()
  27. Greater Than Condition in Linq Join
  28. How do I write this cross apply query in LINQ-to-SQL?
  29. Can’t make GroupJoin work. NavigationExpandingExpressionVisitor exception
  30. LINQ: How to convert the nested hierarchical object to flatten object

Leave a Comment