I am having major problems using GetStoredProcCo mmand and using Parameters
in the same function call in the latest builds of the Enterprise Library
Data.
The error I get is :
Failed to convert parameter value from a SqlParameter to a String.
Here is some code that works and does not work.
// This Works
DbCommand dbCommand1 = new SqlCommand();
dbCommand1.Conn ection = new
SqlConnection(" Server=MyServer ;Database=MyDB; uid=MyUID;pwd=M yPassword;");
dbCommand1.Comm andType = CommandType.Sto redProcedure;
dbCommand1.Comm andText = "HTMLGetPageIDF romName";
dbCommand1.Para meters.Add(new SqlParameter("@ PageName", PageName));
dbCommand1.Conn ection.Open();
object value1 = dbCommand1.Exec uteScalar();
// Shared
Database db = DatabaseFactory .CreateDatabase ();
// This works
DbCommand dbCommand2 =
db.GetStoredPro cCommand("HTMLG etPageIDFromNam e");
db.AddInParamet er(dbCommand2, "@PageName" , DbType.String, PageName);
object value2 = db.ExecuteScala r(dbCommand2);
// This does not work
DbCommand dbCommand3 =
db.GetStoredPro cCommand("HTMLG etPageIDFromNam e",
new SqlParameter("@ PageName", PageName));
object value3 = db.ExecuteScala r(dbCommand3);
The code that does not work causes an Exception on the
db.ExecuteScale r(dbCommand3)
Failed to convert parameter value from a SqlParameter to a String.
Looking at the details I see there is an inner exception
{"Object must implement IConvertible."}
I have spent hours on this and I can not find anything specifc that is
causing the issue. It fails in both the November and December releases.
The exception comes from within the DBCommand.Execu teScaler method call.
The example that fails loads the parameter types from the database and I
think this is causing the issue but I can not fix it.
Is this a known problem?
Cheers
Chris Crowe [IIS MVP 1997 -> 2006]
http://blog.crowe.co.nz
------------------------------------------------
