What are you currently using for data access?
What particular method/application are you using to communicate between your application and a database? Custom code with stored procedures? SubSonic? nHibernate? Entity Framework? LINQ?
Read more... Read less...
I've been using NHibernate for the last year or so, and it's proved to be a really quick way of getting basic CRUD (almost) for free.
If this is something you're looking to get into, I can recommend Billy McCafferty's NHibernate best practices article on CodeProject:
This has proven to be a great scalable and flexible solution and makes it easy to achieve a clear separation of the DAL from the other layers.
I used Hibernate in my previous job to connect to both MySql and Sql Server but I have since switched over to .NET so currently I work with LINQ and I really enjoy it.
At work our code base is C++ and Perl and we talk to a MySQL database. For our interface we have some fairly thin custom classes wrapped around the basic MySQL client libraries for our C++ code and the DBI module for our Perl scripts.
SubSonic and LINQ to SQL, hopefully one day soon LINQ to SubSonic though!