The blog post “Using XML to pass lists as parameters in SQL Server” by the wonderfully-named Phil Factor outlines a useful technique to pass lists into stored procedures and functions. Here is a simple function to create the appropriate XML in C# code (assumes it is a list of integers):

continue reading Using XML to pass lists as parameters in SQL Server: the C# Side