public static int TestProc(this TestmariadbDB dataConnection, string aInParam, out sbyte?aOutParam)
{
var ret = dataConnection.ExecuteProc("`test_proc`",
new DataParameter("aInParam", aInParam, DataType.VarChar),
new DataParameter("aOutParam", null, DataType.SByte)
{
Direction = ParameterDirection.Output
});
aOutParam = Converter.ChangeTypeTo <sbyte?>(((IDbDataParameter)dataConnection.Command.Parameters["aOutParam"]).Value);
return(ret);
}
public static int TestOutputParametersWithoutTableProcedure(this TestmariadbDB dataConnection, string?aInParam, out bool?aOutParam)
{
var ret = dataConnection.ExecuteProc("`TestOutputParametersWithoutTableProcedure`",
new DataParameter("aInParam", aInParam, LinqToDB.DataType.VarChar),
new DataParameter("aOutParam", null, LinqToDB.DataType.SByte)
{
Direction = ParameterDirection.Output
});
aOutParam = Converter.ChangeTypeTo <bool?>(((IDbDataParameter)dataConnection.Command.Parameters["aOutParam"]).Value);
return(ret);
}
public static IEnumerable <Person> TestProcedure(this TestmariadbDB dataConnection, int?param3, ref int?param2, out int?param1)
{
var ret = dataConnection.QueryProc <Person>("`TestProcedure`",
new DataParameter("param3", param3, DataType.Int32),
new DataParameter("param2", param2, DataType.Int32)
{
Direction = ParameterDirection.InputOutput
},
new DataParameter("param1", null, DataType.Int32)
{
Direction = ParameterDirection.Output
}).ToList();
param2 = Converter.ChangeTypeTo <int?>(((IDbDataParameter)dataConnection.Command.Parameters["param2"]).Value);
param1 = Converter.ChangeTypeTo <int?>(((IDbDataParameter)dataConnection.Command.Parameters["param1"]).Value);
return(ret);
}
public static int AddIssue792Record(this TestmariadbDB dataConnection)
{
return(dataConnection.ExecuteProc("`AddIssue792Record`"));
}
