C# Developers' Journal (original) (raw)

Passing ArrayLists to managed stored procedures. Hi guys,

I create stored procedures in the following way:

[SqlProcedure]
public static void addrow(string blah1, string blah2)
{
// the code
}

and this works fine.

However, now I'm trying to pass an ArrayList instead of a string.

[SqlProcedure]
public static void addrow(ArrayList blah1, ArrayList blah2)
{
// the code
}

and when I deploy the server project, visual studio yells at me saying that it doesn't know such thing as an ArrayList.

But the following line is present:

using System.Collections;

Still it doesn't work.

Is there no way to pass an ArrayList into a managed stored procedure?

Update: This is sorta urgent, so for now I will have to convert ArrayLists into CSVs, and extract values inside the stored procedure, but I really want to do it using ArrayLists throughout.