/// <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); } }