I am attempting to utilize Table Value Parameters in SQL Server 2008 with the CSLA Name/Value Pair object(s) but am receiving an error from SQL Server when calling a stored procedure.
Is this the correct object to use? I've also attempted utilizing a Dictionary object to no avail. The only success I've seen is manually iterating through the Name/Value pairs and populating DataRows in a DataTable and passing that to the stored procedure.
Any suggestions would be appreciated.
I don't think the table valued parameters will work with any standard CSLA object.
The only option like you've done is to create a data-table and populate it yourself, I've yet to see an example of where this wasn't used with TVP's.
What error are you getting when working with the TVP?
Copyright (c) Marimer LLC