C# (CSharp) OracleConnection.CheckNull Examples

Example #1

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

Example #2

File: Extensions.OracleConnection.ExecuteEntities.cs Project: cosmos-loops/cosmos-data

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

Example #3

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

Example #4

File: Extensions.OracleConnection.ExecuteDataTable.cs Project: cosmos-loops/cosmos-data

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

Example #5

File: Extensions.OracleConnection.ExecuteExpandoObjects.cs Project: cosmos-loops/cosmos-data

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

Example #6

File: Extensions.OracleConnection.ExecuteExpandoObjects.cs Project: cosmos-loops/cosmos-data

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

Example #7

File: Extensions.OracleConnection.ExecuteEntities.cs Project: cosmos-loops/cosmos-data

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

Example #8

File: Extensions.OracleConnection.cs Project: cosmos-loops/cosmos-data

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

Example #9

File: Extensions.OracleConnection.ExecuteScalarAs.cs Project: cosmos-loops/cosmos-data

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

Example #10

File: Extensions.OracleConnection.ExecuteScalarAs.cs Project: cosmos-loops/cosmos-data

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

Example #11

File: Extensions.OracleConnection.ExecuteExpandoObjects.cs Project: cosmos-loops/cosmos-data

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

Example #12

File: Extensions.OracleConnection.ExecuteEntities.cs Project: cosmos-loops/cosmos-data

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

Example #13

File: Extensions.OracleConnection.ExecuteExpandoObjects.cs Project: cosmos-loops/cosmos-data

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

Example #14

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

Example #15

File: Extensions.OracleConnection.cs Project: cosmos-loops/cosmos-data

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

Example #16

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

Example #17

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

Example #18

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

Example #19

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

Example #20

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

Example #21

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

Example #22

File: Extensions.OracleConnection.ExecuteDataSet.cs Project: cosmos-loops/cosmos-data

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

Example #23

File: Extensions.OracleConnection.ExecuteDataSet.cs Project: cosmos-loops/cosmos-data

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

Example #24

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

Example #25

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

Example #26

File: Extensions.OracleConnection.ExecuteDataSet.cs Project: cosmos-loops/cosmos-data

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

Example #27

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

Example #28

File: Extensions.OracleConnection.ExecuteDataSet.cs Project: cosmos-loops/cosmos-data

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

Example #29

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

Example #30

File: Extensions.OracleConnection.ExecuteDataSet.cs Project: cosmos-loops/cosmos-data

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