Developer Choice

written by Scott Watermasysk on Wednesday, May 14 2008

This post initially started as a set of notes related to my own research around NHibernate and Linq to SQL. However, it quickly turned into a very obvious "ah ha" moment.

As I have previously mentioned, I have been doing a lot of research lately on various tools. One area I have focused on recently is data access. This is an area of hot debate for many people and can easily turn into a pissing match, so I first want to share my key take away:

The tool in itself, does not matter. It is all about what you are comfortable with.

In hindsight, this is very obvious. It is generally the answer to most developer questions (C# vs. VB, SQL Server vs. MySQL, ASP.Net vs. Rails). There will always be trade offs. The result will never be perfect.

This of course does not mean you shouldn't try anything new. The world of software is in constant flux. I routinely cringe at code I wrote a year ago. However, if you spend all your time looking for the perfect solution, you won't leave yourself the necessary time to build something great.

FYI, if you are still interested in the NHibernate vs Linq to SQL, here is a nice overview by Geoff Bennet.

Similar Posts

  1. Changing for Simplicity
  2. ASP.Net Quick Tips - State Management
  3. Enhancing Desktop Computing with the Cloud
  • Link Listing - May 14, 2008 on on 5.15.2008 at 6:56 AM

    WPF WPF UI Update from Background Threads [Via: ChristophDotNet ] Code Camps Charlotte Code Camp -...

  • Link Listing - May 14, 2008 on on 5.15.2008 at 6:56 AM

    Link Listing - May 14, 2008

  • ActiveLinq on on 5.29.2008 at 10:20 AM

    I have been evaluating Linq to SQL and Castle ActiveRecord for a small project I am working on. In end I decided to go with ActiveRecord. As part of my experiment, I did a quick prototype of an ActiveRecord like pattern using Linq to SQL.

  • ActiveLinq on on 5.29.2008 at 10:20 AM

    I have been evaluating Linq to SQL and Castle ActiveRecord for a small project I am working on. In end I decided to go with ActiveRecord. As part of my experiment, I did a quick prototype of an ActiveRecord like pattern using Linq to SQL.

Comments

  • ryhoward on on 5.14.2008 at 10:07 AM

    ryhoward avatar

    Interesting point Scott, it's interesting to watch the constant debates over which tool is best, or why one language is better than the other. Although some are obviously better than others, sometimes it's better to just use what you like best.

  • Lee Brandt on on 5.14.2008 at 10:37 AM

    Lee Brandt avatar

    Well put. My thoughts:http://geekswithblogs.net/leesblog/archive/2008/05/08/there-is-no-right-answer.aspx

  • Chris on on 5.14.2008 at 12:23 PM

    Chris avatar

    So where did you end up being most comfortable?

  • Scott Tucker on on 5.22.2008 at 5:56 AM

    Scott Tucker avatar

    I have to agree that it is what you are comfortable with. But honestly I don't see any comparison between NHibernate and LINQ to SQL. Linq To SQL is limited to just one database only and NHibernate is not. But overall the overview by Geoff is decent and highlights some of the differences.

Comments are closed