Which DAL choice should I use?

Question

I'm working on a little side project. I've got a large SQL query expression, 30+ lines, that I wish to use in my project. This app needs to provide read-only access to the database through these queries.

There are so many data layer choices. nHibernate, Entity Framework, LINQ to SQL, Datasets, Castle ActiveRecord... others I can't name off the top of my head. I don't want to have to recode this query into LINQ, so I think that's out. I'd prefer it if I could still copy it into a query editor or easily port it to some other framework.

This project is about learning a new technology. For the purposes of having a useful tech under my belt, which framework should I use? I will not, ever, update the database from this app.

Advice?

Answer 1

NHibernate for the win!

Answer 2

If you don't have a lot of queries to make and want the ease of use I would say take NHibernate (you have easier control on the mapping over XML) or even easier ActiveRecord (supposing you are also creating your own database, then you do not have really to care about the mappings).

Otherwise for performance use directly ADO.NET

Answer 3

With a large query expression, you could easily have several DAL projects and try out every one you've mentioned.

Answer 4

You want to write pure SQL but maintain portability - then iBatis is what you want: http://ibatis.apache.org/dotnet.cgi

Answer 5

SubSonic is nice and neat for simple things and even has a nice tagline (and podcast episode).