public async Task 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 = await db.ScalarAsync("CALL testproc_in_out(10, @param2); SELECT @param2");
Assert.AreEqual((long)20, result);
}