Only MySqlParameter objects may be stored

Question

Hi all I have a written a sample code to insert in to mysql database using stored procedure along with entity framework as follows

MySqlParameter userName = new MySqlParameter("_UserName", MySqlDbType.VarChar);

userName.Value = txtUserName.Text;

MySqlParameter password = new MySqlParameter("_Password", MySqlDbType.VarChar);

password.Value = txtPassword.Text;

MySqlParameter FirstName = new MySqlParameter("_FirstName", MySqlDbType.VarChar);

FirstName.Value = txtFirstName.Text;

MySqlParameter LastName = new MySqlParameter("_LastName", MySqlDbType.VarChar);

LastName.Value = txtLastName.Text;

entities.ExecuteStoreCommand("uspInsertUsers _UserName,_Password,_FirstName,_LastName", userName,password,FirstName,LastName);

But I am getting an exception as Only MySqlParameter objects may be stored can some one help me..

Vulpes · Answer

I think the problem here is that the syntax for calling a stored procedure in MySql is not quite right. Try this instead: protected void Page_Load(object sender EventArgs e) { MySqlParameter userName = new MySqlParameter(?ID MySqlDbType.Int16); userName.Value = 8; entities.ExecuteStoreCommand(CALL deleteUser(?ID) userName); } If that works then the original call would become: entities.ExecuteStoreCommand(CALL uspInsertUsers(?UserName?Password?FirstName?LastName) userNamepasswordFirstNameLastName);

Dorababu Meka · Answer

Thanks Vulpes

Dorababu Meka · Answer

Vulpes thanks for your code but still I am getting an excpetion You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'deleteUser 8' at line 1 This is my code protected void Page_Load(object sender EventArgs e) { MySqlParameter userName = new MySqlParameter(?ID MySqlDbType.Int16); userName.Value = 8; //var ietsParameter = new MySqlParameter(@ID 7); entities.ExecuteStoreCommand(deleteUser ?ID userName); }

Vulpes · Answer

Rather than using an underscore to prefix your parameters I'd try using a question mark instead as I believe that's what is normally used in MySQL: MySqlParameter userName = new MySqlParameter(?UserName MySqlDbType.VarChar); userName.Value = txtUserName.Text; MySqlParameter password = new MySqlParameter(?Password MySqlDbType.VarChar); password.Value = txtPassword.Text; MySqlParameter FirstName = new MySqlParameter(?FirstName MySqlDbType.VarChar); FirstName.Value = txtFirstName.Text; MySqlParameter LastName = new MySqlParameter(?LastName MySqlDbType.VarChar); LastName.Value = txtLastName.Text; entities.ExecuteStoreCommand(uspInsertUsers ?UserName?Password?FirstName?LastName userNamepasswordFirstNameLastName);