NHibernate is the .NET port of the Java Hibernate, which provides Object/Relational mapping to persist objects in a relational database.
The most requested feature for NHibernate for the last few years has been Linq support, and it’s now available.
NHibernate Linq 1.0 is based on the existing, proven Linq provider in NHibernate Contrib. This Linq release supports just about anything that you can do with the criteria API. It does not support group joins or subqueries in select clauses, since they aren’t supported by the criteria API. NHibernate’s Linq support has been tested in production for a few years, and most people find it more than sufficient for their needs.
Download NHibernate Linq
Subsonic is a “super high-fidelity Batman utility belt that works up your Data Access (using Linq in 3.0), throws in some much-needed utility functions, and generally speeds along your dev cycle.” Put another way, Subsonic is an open source object-relational mapper for Microsoft .NET maintained by Rob Conery.
New in version 3:
- Linq engine which parses IQueryable “stuff” into SQL
- Templating system which allows you to use ActiveRecord and Linq-to-SQL style
- A SimpleRepository which even builds your database for you
- A brand-new project site
- A new wiki docs site
Subsonic Homepage
jLinq is a JavaScript library that lets you write queries against arrays of JavaScript objects. jLinq is completely extensible so you can write your add-ins and they will work with the rest of the framework without any additional programming.
With all these “Web 2.0″ applications floating around, the ability to sort, query and manage your records on the client side may become a necessity. Use jLinq with the JSON data you already have and you’ve got quite a combination.
New features in v2.2 include:
- Smarter comparisons
- 11 new commands
- jLinq tests
- Bug fixes
jLinq Website
jLinq 2.2 Features and Details
The Microsoft ADO.NET team has discontinued the LINQ to SQL project. Many developers believe this is a mistake, “spitting in the face” of everyone who invested time and money in LINQ-SQL, leaving developers with a costly porting process.
Read more at Ayende @ Rahien
Read more at ADO.NET Team Blog
The ADO.NET Entity Framework provides strongly typed LINQ data access in relational databases. Entity Framework makes it easier for developers to work with their data because it moves the data model up from the physical structure of relational tables to a conceptual model that accurately reflects common business objects. Yet Entity Framework was quickly demonized as the “Albatross of ALT.NET,” especially by NHibernate fans.
See Microsoft ADO.NET Entity Framework website
Entity Framework FAQ
