Not *quite* sure how I'm going to do this, but...
I'm trying to design a db-driven system using WCF, VB.NET and SQL Server 2008. Basically, the VB.NET and WCF code capture user-defined data and are supposed to pass it to SQL Server, which will retrieve a single record (nvarchar[max]), parse & populate the column with the user-selected variables, and return it to the application.
The problem I'm having is in the stored procedure parameters. The applications pass multidimensional arrays (jagged arrays) to and from each other. But how can I pass those to a SQL stored procedure?
As none of these variables will be stored in SQL, I'd like to avoid writing them to a table.
Of course, my plan might be goofy to begin with. Perhaps I should parse/populate the data at a different level (ie: in the service app). Of course, that would mean I'm posting in the wrong place.
Any ideas about passing multidimensional arrays to stored procedures? Other thoughts?
I'm trying to design a db-driven system using WCF, VB.NET and SQL Server 2008. Basically, the VB.NET and WCF code capture user-defined data and are supposed to pass it to SQL Server, which will retrieve a single record (nvarchar[max]), parse & populate the column with the user-selected variables, and return it to the application.
The problem I'm having is in the stored procedure parameters. The applications pass multidimensional arrays (jagged arrays) to and from each other. But how can I pass those to a SQL stored procedure?
As none of these variables will be stored in SQL, I'd like to avoid writing them to a table.
Of course, my plan might be goofy to begin with. Perhaps I should parse/populate the data at a different level (ie: in the service app). Of course, that would mean I'm posting in the wrong place.
Any ideas about passing multidimensional arrays to stored procedures? Other thoughts?