Hi all,

My DAL starts with Stored Procedures and prepared commands and we use .NET framework components with corresponding typed datasets. Then you can drop your DAL Component and needed datasets to Win/WebForm...

CREATE TABLE #tmp (Id int, ...)

INSERT INTO #tmp 

EXEC myStoredProc @param1, ...

Cheers