Hi Dmitry,
>Coming back to your suggestion on how to write a stored procedure for updating database, I was wondering if you could, please, clarify something. In your blog III you have a method SetAllParameters() that iterates through columns of the table. How do you make sure that the order of parameters in the stored procedure match the order of parameters sent when executing stored procedure from DAL?SqlServer uses named parameters, not positional, so for SQL it doesn't matter what order they're created. For databases where positional parameters are used, then you're just going to have be careful. <g>
~~Bonnie