An SqlParameter with ParameterName is not contained by this SqlParameterCollection

Question

Cannot figure out why I keep getting

An SqlParameter with ParameterName is not contained by this SqlParameterCollection

when I've been pulling and calling procs like this fine in other methods.

The proc does have the one param @EqId in that casing.

List<string> equipTypes = new List<string>();

Database db = DatabaseFactory.CreateDatabase("OurDBName");
DbCommand cmd = db.GetStoredProcCommand("Get_EquipTypes_By_ID");

db.DiscoverParameters(cmd);
cmd.Parameters["@EqId"].Value = equipID;

using (IDataReader objReader = db.ExecuteReader(cmd))
{
   while (objReader.Read())
      equipTypes.Add(DataUtility.GetStringFromReader(objReader, "Data"));
}

Why would you even use DiscoverParameters? That is an extra round trip, yet you already know the name. That is for tools that probe procs. — Marc Gravell
– Marc Gravell, Commented Oct 28, 2011 at 17:07

GregM · Accepted Answer · 2011-10-28 17:07:09Z

2

Do your add parameters like this

 cmd.Parameters.AddWithValue("@EqId", equipID);

I thinks it's the cleanest way to do it, well kind of :)

answered Oct 28, 2011 at 17:07

GregM

2,6643 gold badges24 silver badges37 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Gregory A Beamer · Accepted Answer · 2011-10-28 17:16:46Z

0

First off, I would not discover parameters when you are aware of the parameters. Since you are doing this, examine the parameter collection and make sure the parameter is being discovered. Fater you have that figured out, I would aim for something more like what Greg has suggested.

answered Oct 28, 2011 at 17:16

Gregory A Beamer

17k3 gold badges27 silver badges32 bronze badges

Collectives™ on Stack Overflow

An SqlParameter with ParameterName is not contained by this SqlParameterCollection

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related