CSLA & SQL 2008 Table Value Parameters

CSLA & SQL 2008 Table Value Parameters

Old forum URL: forums.lhotka.net/forums/t/8569.aspx

Phlar posted on Tuesday, February 23, 2010

Hi All,

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.

Marjon1 replied on Wednesday, February 24, 2010

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.

bniemyjski replied on Thursday, February 25, 2010

Hello,

What error are you getting when working with the TVP?

Thanks

-Blake Niemyjski

Copyright (c) Marimer LLC