Is there any other way to write the Data Access layer faster? {Taking Further}

Question

Hi One of the time consuming factors of writing the DAL is adding and assigning paramters of teh stored procedure if ther are more than 10 parameters and must link more than 3 tables this process will take a horrible amount of time... Is there another way to write the DAL faster? TY

Master Billa · Answer

HI Its easy  because now day so many sample code to Generate DAL using generators http://www.codeproject.com/KB/database/ornet2.aspx thank you

petre ricardo · Answer

HI Certain companies still use VS2005 i have attended an interview recently and it took me 3/5 of the time to write the DAL than writing the logic and OO associations.....but the ones you have recomemded supports .NET 3.0 or higher... is therea way to speed up writing the DAL in .NET 2.0...? TY

Roei Bar · Answer

use this http://subsonicproject.com/ it has a build in option to create a DataAccess Class for you via the Builder extremely fast and very powerfull highly recommended CRUD Util

Mahesh Chand · Answer

Take a look at ADO.NET Entity Framework. Using this framework you don't need to write full DAL. You will need to write partial DAL and most of the work will be done for you. However you will have to use .NET Framework 3.5 or later.