c# - Error converting data type int to tinyint

Question

I am new to stored procedures. When i run this i get an error saying Error converting data type int to tinyint. In my C# was the following code:

mySqlcmd.CommandText = "EXECUTE PhoneNumber_Insert  @p_PhoneNumberTypeID, @p_PersonID";
mySqlcmd.Parameters.Add("@p_PhoneNumberTypeID", SqlDbType.TinyInt).Value = 1;
mySqlcmd.Parameters.Add("@p_PersonID", SqlDbType.Int).Value = "754381";
mysqlConnection.Open();
mySqlcmd.ExecuteNonQuery();
mysqlConnection.Close();

Answer 1

You're encountering bug 101302 in MySQL Connector/NET. There are three possible workarounds:

1. Change your code to explicitly use MySqlDbType.Byte: mySqlcmd.Parameters.Add("@p_PhoneNumberTypeID", MySqlDbType.Byte).Value = 1;
2. Downgrade to MySql.Data 8.0.21.
3. Switch to MySqlConnector, which supports the same API as MySql.Data but is less buggy.