Create array of sqlParameters when you dont know the siz a

Question

I want to create an array (only way to pass parameters to our data access component) but i dont know how many params i will need.

I have a bunch of bool variables and will add parameters if the bool is true

    SqlParameter[] p = new SqlParameter[5];
    if (IsCall)
        p[0] = new SqlParameter("@IsCall", IsCall);
    if (Given)
        p[p.count] = new SqlParameter("@Given", Given);

Thanks !

Answer 1

If you cannot use a list, then consider this approach:

var list = new List<SqlParameter>( );
if( IsCall)
   list.Add( new SqlParameter("@IsCall", IsCall));
if( Given)
   list.Add( new SqlParameter("@Given", Given));
. . .
SqlParameter[ ] p = list.ToArray( );