/// <summary>
/// Executes command using LinqToDB.Mapping.StoredProcedure command type and returns
/// number of affected records.
/// </summary>
/// <param name="procedureName">Procedure name</param>
/// <param name="parameters">Command parameters</param>
/// <returns>Number of records, affected by command execution.</returns>
public int ExecuteStoredProcedure(string procedureName, params DataParameter[] parameters)
{
using var dataContext = CreateDataConnection();
var command = new CommandInfo(dataContext, procedureName, parameters);
var affectedRecords = command.ExecuteProc();
UpdateOutputParameters(dataContext, parameters);
return(affectedRecords);
}
/// <summary>
/// Executes command using LinqToDB.Mapping.StoredProcedure command type and returns
/// single value
/// </summary>
/// <typeparam name="T">Result record type</typeparam>
/// <param name="procedureName">Procedure name</param>
/// <param name="parameters">Command parameters</param>
/// <returns>Resulting value</returns>
public T ExecuteStoredProcedure <T>(string procedureName, params DataParameter[] parameters)
{
using var dataContext = CreateDataConnection();
var command = new CommandInfo(dataContext, procedureName, parameters);
var result = command.ExecuteProc <T>();
UpdateOutputParameters(dataContext, parameters);
return(result);
}
/// <summary>
/// Executes command using LinqToDB.Mapping.StoredProcedure command type and returns
/// number of affected records.
/// </summary>
/// <param name="procedureName">Procedure name</param>
/// <param name="parameters">Command parameters</param>
/// <returns>Number of records, affected by command execution.</returns>
public int ExecuteStoredProcedure(string procedureName, params DataParameter[] parameters)
{
using (new ReaderWriteLockDisposable(_locker, ReaderWriteLockType.Read))
{
var command = new CommandInfo(DataContext, procedureName, parameters);
var affectedRecords = command.ExecuteProc();
UpdateOutputParameters(DataContext, parameters);
return(affectedRecords);
}
}
/// <summary>
/// Executes command using LinqToDB.Mapping.StoredProcedure command type and returns
/// single value
/// </summary>
/// <typeparam name="T">Result record type</typeparam>
/// <param name="procedureName">Procedure name</param>
/// <param name="parameters">Command parameters</param>
/// <returns>Resulting value</returns>
public T ExecuteStoredProcedure <T>(string procedureName, params DataParameter[] parameters)
{
using (new ReaderWriteLockDisposable(_locker, ReaderWriteLockType.Read))
{
var command = new CommandInfo(DataContext, procedureName, parameters);
var result = command.ExecuteProc <T>();
UpdateOutputParameters(DataContext, parameters);
return(result);
}
}
