>I tested on 1 one table, without any transcaction. Same problem.
>
>>Yesterday I wrote a stored procedure for similar requirement passing my rows as Table Valued parameters. I did have to convert classes to DataTable, though.
>>
>Untyped DataTable?
>
Yes, I manually converted my classes back to the datatable to fit the User Defined Table Types I created.
If it's not broken, fix it until it is.
My Blog