SQL Server CLR Help

I appreciate that once an assembly is registered that you can so something like

EXEC ClrSpEmployeeByShift @shiftID=1

Where shiftID is an expected parameter but what if I want to use a class as an object ie set numerous properties then call a function or sub
rocky050371Asked:
Who is Participating?
 
CodeCruiserConnect With a Mentor Commented:
You can then probably exchange a datatable.

Following example is from .NET to SQL but other way round should be similar

http://www.codeproject.com/Tips/214492/Passing-a-datatable-to-a-stored-procedure-in-Sql-S
0
 
CodeCruiserCommented:
I think to be able to exchange objects as parameters, you need to declare that as a user defined data type in SQL Server and then you can use it.

http://www.codeproject.com/Articles/38693/Working-with-CLR-Objects-in-SQL-Server-2005-or-Abo#heading0002
0
 
rocky050371Author Commented:
Essentially it could be n number of name value pairs, then once they have all been passed I want to call a function based on the collection of values
0
 
rocky050371Author Commented:
In OLE you can simply create an use an object, I wonder if a paramarray is possible?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.