public override object query(string request, AbstractPermission permission = null)
{
SqlCommand cmd = new SqlCommand();
cmd.Connection = _myCxn;
cmd.CommandText = request;
if (_params != null && _params.Count > 0)
{
int count = _params.Count;
for (int i = 0; i < count; i++)
{
SqlParameter temp = _params[0];
_params.RemoveAt(0);
cmd.Parameters.Add(temp);
}
}
SqlDataReader rdr = cmd.ExecuteReader();
return(rdr);
}
public void CollectionCheckNameInvalid_Throws()
{
SqlCommand command = new SqlCommand();
SqlParameterCollection collection = command.Parameters;
collection.Add(new SqlParameter("Test1", 1));
collection.Add(new SqlParameter("Test2", 2));
IndexOutOfRangeException ex = Assert.Throws <IndexOutOfRangeException>(() => collection.RemoveAt("DoesNotExist"));
Assert.Contains("DoesNotExist", ex.Message, StringComparison.OrdinalIgnoreCase);
}