public void In_Out_Params_SQL() { var _providerName = ProviderName; if (ProviderName == "MySql.Data.MySqlClient") { // this must be added to access user variables on the Oracle/MySQL driver _providerName += ";AllowUserVariables=true"; } var db = new SPTestsDatabase(_providerName); // old skool SQL // this approach only works on the Oracle/MySQL driver if "AllowUserVariables=true" is included in the connection string var result = db.Scalar("CALL testproc_in_out(10, @param2); SELECT @param2"); Assert.AreEqual((long)20, result); }