Creating Data Access Layer for Small website

Question

I am creating my application in asp.net 3.5. I have to make my Data Access layer, in which I am doing the traditional method of fetching/updating the data. Which is SqlConnection than SQLCommand, than SQLadapter. Will there be any other way I can create my DAL layer easily.

Specification.

1. My website is small. Approx 7-10 pages.
2. Database has around 80 tables.

What I know:

1. Linq to SQL - I don't want to use it because I am not fully aware about the LINQ statement and I need to develop the application really fast. [3 days :-( ]. Also, there are 100% chances that the table structure will be altered in future.

2. Enterprise Library: It will take too much time for me to integrate to my application.

Any other suggestion to create my data layer, quick ... fast ... and "NOT" dirty. Thanks in advance.

Answer 1

How about using Codesmith (free version 2.6) to generate a simple set of data access objects off your database? Given the small number of DB objects that you need to model I think this would be a quick and easy way of achieving your goal given the time constraints.