/// <summary> /// Execute reader /// </summary> /// <param name="conn"></param> /// <param name="cmdText"></param> /// <param name="parameters"></param> /// <param name="commandType"></param> /// <param name="transaction"></param> /// <returns></returns> public static OracleDataReader ExecuteReader(this OracleConnection conn, string cmdText, OracleParameter[] parameters, CommandType commandType, OracleTransaction transaction) { conn.CheckNull(nameof(conn)); using var command = CreateCommand(conn, cmdText, commandType, transaction, parameters); return(command.ExecuteReader()); }
/// <summary> /// Execute a set of entity /// </summary> /// <param name="conn"></param> /// <param name="commandFactory"></param> /// <typeparam name="T"></typeparam> /// <returns></returns> public static IEnumerable <T> ExecuteEntities <T>(this OracleConnection conn, Action <OracleCommand> commandFactory) where T : new() { conn.CheckNull(nameof(conn)); using var command = conn.CreateCommand(commandFactory); using IDataReader reader = ((DbCommand)command).ExecuteReader(); return(reader.ToEntities <T>()); }
/// <summary> /// Execute scalar /// </summary> /// <param name="conn"></param> /// <param name="cmdText"></param> /// <param name="parameters"></param> /// <param name="commandType"></param> /// <param name="transaction"></param> /// <returns></returns> public static Task <object> ExecuteScalarAsync(this OracleConnection conn, string cmdText, OracleParameter[] parameters, CommandType commandType, OracleTransaction transaction) { conn.CheckNull(nameof(conn)); using var command = CreateCommand(conn, cmdText, commandType, transaction, parameters); return(command.ExecuteScalarAsync()); }
/// <summary> /// Execute DataTable /// </summary> /// <param name="conn"></param> /// <param name="cmdText"></param> /// <param name="parameters"></param> /// <param name="commandType"></param> /// <param name="transaction"></param> /// <returns></returns> public static DataTable ExecuteDataTable(this OracleConnection conn, string cmdText, OracleParameter[] parameters, CommandType commandType, OracleTransaction transaction) { conn.CheckNull(nameof(conn)); using var command = conn.CreateCommand(cmdText, commandType, transaction, parameters); return(command.ExecuteFirstDataTable()); }
/// <summary> /// Execute a set of expando object /// </summary> /// <param name="conn"></param> /// <param name="commandFactory"></param> /// <returns></returns> public static IEnumerable <dynamic> ExecuteExpandoObjects(this OracleConnection conn, Action <OracleCommand> commandFactory) { conn.CheckNull(nameof(conn)); using var command = conn.CreateCommand(commandFactory); using IDataReader reader = ((DbCommand)command).ExecuteReader(); return(reader.ToExpandoObjects()); }
/// <summary> /// Execute a set of expando object /// </summary> /// <param name="conn"></param> /// <param name="cmdText"></param> /// <param name="parameters"></param> /// <param name="commandType"></param> /// <param name="transaction"></param> /// <returns></returns> public static IEnumerable <dynamic> ExecuteExpandoObjects(this OracleConnection conn, string cmdText, OracleParameter[] parameters, CommandType commandType, OracleTransaction transaction) { conn.CheckNull(nameof(conn)); using var command = conn.CreateCommand(cmdText, commandType, transaction, parameters); using IDataReader reader = command.ExecuteReader(); return(reader.ToExpandoObjects()); }
/// <summary> /// Execute a set of entity /// </summary> /// <param name="conn"></param> /// <param name="cmdText"></param> /// <param name="parameters"></param> /// <param name="commandType"></param> /// <param name="transaction"></param> /// <typeparam name="T"></typeparam> /// <returns></returns> public static IEnumerable <T> ExecuteEntities <T>(this OracleConnection conn, string cmdText, OracleParameter[] parameters, CommandType commandType, OracleTransaction transaction) where T : new() { conn.CheckNull(nameof(conn)); using var command = conn.CreateCommand(cmdText, commandType, transaction, parameters); using IDataReader reader = command.ExecuteReader(); return(reader.ToEntities <T>()); }
/// <summary> /// Create command /// </summary> /// <param name="conn"></param> /// <param name="commandFactory"></param> /// <returns></returns> public static OracleCommand CreateCommand(this OracleConnection conn, Action <OracleCommand> commandFactory) { conn.CheckNull(nameof(conn)); var command = conn.CreateCommand(); commandFactory?.Invoke(command); return(command); }
/// <summary> /// Execute scalar as... /// </summary> /// <param name="conn"></param> /// <param name="commandFactory"></param> /// <typeparam name="T"></typeparam> /// <returns></returns> public static async Task <T> ExecuteScalarAsAsync <T>(this OracleConnection conn, Action <OracleCommand> commandFactory) { conn.CheckNull(nameof(conn)); #if NETFRAMEWORK || NETSTANDARD2_0 using var command = conn.CreateCommand(commandFactory); #else await using var command = conn.CreateCommand(commandFactory); #endif return((T)await command.ExecuteScalarAsync()); }
/// <summary> /// Execute scalar as... /// </summary> /// <param name="conn"></param> /// <param name="cmdText"></param> /// <param name="parameters"></param> /// <param name="commandType"></param> /// <param name="transaction"></param> /// <typeparam name="T"></typeparam> /// <returns></returns> public static async Task <T> ExecuteScalarAsAsync <T>(this OracleConnection conn, string cmdText, OracleParameter[] parameters, CommandType commandType, OracleTransaction transaction) { conn.CheckNull(nameof(conn)); #if NETFRAMEWORK || NETSTANDARD2_0 using var command = CreateCommand(conn, cmdText, commandType, transaction, parameters); #else await using var command = CreateCommand(conn, cmdText, commandType, transaction, parameters); #endif return((T)await command.ExecuteScalarAsync()); }
/// <summary> /// Execute a set of expando object /// </summary> /// <param name="conn"></param> /// <param name="commandFactory"></param> /// <returns></returns> public static async Task <IEnumerable <dynamic> > ExecuteExpandoObjectsAsync(this OracleConnection conn, Action <OracleCommand> commandFactory) { conn.CheckNull(nameof(conn)); #if NETFRAMEWORK || NETSTANDARD2_0 using var command = conn.CreateCommand(commandFactory); #else await using var command = conn.CreateCommand(commandFactory); #endif using IDataReader reader = await command.ExecuteReaderAsync(); return(reader.ToExpandoObjects()); }
/// <summary> /// Execute a set of entity /// </summary> /// <param name="conn"></param> /// <param name="commandFactory"></param> /// <typeparam name="T"></typeparam> /// <returns></returns> public static async Task <IEnumerable <T> > ExecuteEntitiesAsync <T>(this OracleConnection conn, Action <OracleCommand> commandFactory) where T : new() { conn.CheckNull(nameof(conn)); #if NETFRAMEWORK || NETSTANDARD2_0 using var command = conn.CreateCommand(commandFactory); #else await using var command = conn.CreateCommand(commandFactory); #endif using IDataReader reader = await command.ExecuteReaderAsync(); return(reader.ToEntities <T>()); }
/// <summary> /// Execute a set of expando object /// </summary> /// <param name="conn"></param> /// <param name="cmdText"></param> /// <param name="parameters"></param> /// <param name="commandType"></param> /// <param name="transaction"></param> /// <returns></returns> public static async Task <IEnumerable <dynamic> > ExecuteExpandoObjectsAsync(this OracleConnection conn, string cmdText, OracleParameter[] parameters, CommandType commandType, OracleTransaction transaction) { conn.CheckNull(nameof(conn)); #if NETFRAMEWORK || NETSTANDARD2_0 using var command = conn.CreateCommand(cmdText, commandType, transaction, parameters); #else await using var command = conn.CreateCommand(cmdText, commandType, transaction, parameters); #endif using IDataReader reader = await command.ExecuteReaderAsync(); return(reader.ToExpandoObjects()); }
/// <summary> /// Execute entity /// </summary> /// <param name="conn"></param> /// <param name="cmdText"></param> /// <param name="parameters"></param> /// <param name="commandType"></param> /// <param name="transaction"></param> /// <typeparam name="T"></typeparam> /// <returns></returns> public static async Task <T> ExecuteEntityAsync <T>(this OracleConnection conn, string cmdText, OracleParameter[] parameters, CommandType commandType, OracleTransaction transaction) where T : new() { conn.CheckNull(nameof(conn)); #if NETFRAMEWORK || NETSTANDARD2_0 using var command = conn.CreateCommand(cmdText, commandType, transaction, parameters); #else await using var command = conn.CreateCommand(cmdText, commandType, transaction, parameters); #endif using IDataReader reader = await command.ExecuteReaderAsync(); reader.Read(); return(reader.ToEntity <T>()); }
/// <summary> /// Create command /// </summary> /// <param name="conn"></param> /// <param name="cmdText"></param> /// <param name="commandType"></param> /// <param name="transaction"></param> /// <param name="parameters"></param> /// <returns></returns> public static OracleCommand CreateCommand(this OracleConnection conn, string cmdText, CommandType commandType, OracleTransaction transaction, params OracleParameter[] parameters) { conn.CheckNull(nameof(conn)); var command = conn.CreateCommand(); command.CommandText = cmdText; command.CommandType = commandType; command.Transaction = transaction; if (parameters is not null) { command.Parameters.AddRange(parameters); } return(command); }
/// <summary> /// Execute reader /// </summary> /// <param name="conn"></param> /// <param name="cmdText"></param> /// <param name="transaction"></param> /// <returns></returns> public static OracleDataReader ExecuteReader(this OracleConnection conn, string cmdText, OracleTransaction transaction) { conn.CheckNull(nameof(conn)); return(conn.ExecuteReader(cmdText, null, CommandType.Text, transaction)); }
/// <summary> /// Execute reader /// </summary> /// <param name="conn"></param> /// <param name="cmdText"></param> /// <param name="commandType"></param> /// <returns></returns> public static OracleDataReader ExecuteReader(this OracleConnection conn, string cmdText, CommandType commandType) { conn.CheckNull(nameof(conn)); return(conn.ExecuteReader(cmdText, null, commandType, null)); }
/// <summary> /// Execute reader /// </summary> /// <param name="conn"></param> /// <param name="cmdText"></param> /// <param name="commandType"></param> /// <param name="transaction"></param> /// <returns></returns> public static Task <OracleDataReader> ExecuteReaderAsync(this OracleConnection conn, string cmdText, CommandType commandType, OracleTransaction transaction) { conn.CheckNull(nameof(conn)); return(conn.ExecuteReaderAsync(cmdText, null, commandType, transaction)); }
/// <summary> /// Execute reader /// </summary> /// <param name="conn"></param> /// <param name="cmdText"></param> /// <param name="parameters"></param> /// <param name="transaction"></param> /// <returns></returns> public static Task <OracleDataReader> ExecuteReaderAsync(this OracleConnection conn, string cmdText, OracleParameter[] parameters, OracleTransaction transaction) { conn.CheckNull(nameof(conn)); return(conn.ExecuteReaderAsync(cmdText, parameters, CommandType.Text, transaction)); }
/// <summary> /// Execute scalar /// </summary> /// <param name="conn"></param> /// <param name="cmdText"></param> /// <param name="parameters"></param> /// <param name="commandType"></param> /// <returns></returns> public static Task <object> ExecuteScalarAsync(this OracleConnection conn, string cmdText, OracleParameter[] parameters, CommandType commandType) { conn.CheckNull(nameof(conn)); return(conn.ExecuteScalarAsync(cmdText, parameters, commandType, null)); }
/// <summary> /// Execute reader /// </summary> /// <param name="conn"></param> /// <param name="commandFactory"></param> /// <returns></returns> public static Task <OracleDataReader> ExecuteReaderAsync(this OracleConnection conn, Action <OracleCommand> commandFactory) { conn.CheckNull(nameof(conn)); using var command = conn.CreateCommand(commandFactory); return(ExecuteReaderAsync(command)); }
/// <summary> /// Execute DataSet /// </summary> /// <param name="conn"></param> /// <param name="cmdText"></param> /// <returns></returns> public static DataSet ExecuteDataSet(this OracleConnection conn, string cmdText) { conn.CheckNull(nameof(conn)); return(conn.ExecuteDataSet(cmdText, null, CommandType.Text, null)); }
/// <summary> /// Execute DataSet /// </summary> /// <param name="conn"></param> /// <param name="cmdText"></param> /// <param name="parameters"></param> /// <returns></returns> public static Task <DataSet> ExecuteDataSetAsync(this OracleConnection conn, string cmdText, OracleParameter[] parameters) { conn.CheckNull(nameof(conn)); return(conn.ExecuteDataSetAsync(cmdText, parameters, CommandType.Text, null)); }
/// <summary> /// Execute scalar /// </summary> /// <param name="conn"></param> /// <param name="cmdText"></param> /// <param name="commandType"></param> /// <param name="transaction"></param> /// <returns></returns> public static object ExecuteScalar(this OracleConnection conn, string cmdText, CommandType commandType, OracleTransaction transaction) { conn.CheckNull(nameof(conn)); return(conn.ExecuteScalar(cmdText, null, commandType, transaction)); }
/// <summary> /// Execute scalar /// </summary> /// <param name="conn"></param> /// <param name="cmdText"></param> /// <param name="transaction"></param> /// <returns></returns> public static Task <object> ExecuteScalarAsync(this OracleConnection conn, string cmdText, OracleTransaction transaction) { conn.CheckNull(nameof(conn)); return(conn.ExecuteScalarAsync(cmdText, null, CommandType.Text, transaction)); }
/// <summary> /// Execute DataSet /// </summary> /// <param name="conn"></param> /// <param name="cmdText"></param> /// <param name="parameters"></param> /// <param name="commandType"></param> /// <returns></returns> public static DataSet ExecuteDataSet(this OracleConnection conn, string cmdText, OracleParameter[] parameters, CommandType commandType) { conn.CheckNull(nameof(conn)); return(conn.ExecuteDataSet(cmdText, parameters, commandType, null)); }
/// <summary> /// Execute scalar /// </summary> /// <param name="conn"></param> /// <param name="commandFactory"></param> /// <returns></returns> public static object ExecuteScalar(this OracleConnection conn, Action <OracleCommand> commandFactory) { conn.CheckNull(nameof(conn)); using var command = conn.CreateCommand(commandFactory); return(command.ExecuteScalar()); }
/// <summary> /// Execute DataSet /// </summary> /// <param name="conn"></param> /// <param name="commandFactory"></param> /// <returns></returns> public static Task <DataSet> ExecuteDataSetAsync(this OracleConnection conn, Action <OracleCommand> commandFactory) { conn.CheckNull(nameof(conn)); using var command = conn.CreateCommand(commandFactory); return(command.ExecuteDataSetAsync()); }
/// <summary> /// Execute scalar /// </summary> /// <param name="conn"></param> /// <param name="cmdText"></param> /// <param name="parameters"></param> /// <returns></returns> public static object ExecuteScalar(this OracleConnection conn, string cmdText, OracleParameter[] parameters) { conn.CheckNull(nameof(conn)); return(conn.ExecuteScalar(cmdText, parameters, CommandType.Text, null)); }
/// <summary> /// Execute DataSet /// </summary> /// <param name="conn"></param> /// <param name="cmdText"></param> /// <param name="commandType"></param> /// <returns></returns> public static Task <DataSet> ExecuteDataSetAsync(this OracleConnection conn, string cmdText, CommandType commandType) { conn.CheckNull(nameof(conn)); return(conn.ExecuteDataSetAsync(cmdText, null, commandType, null)); }