C# (CSharp) Npgsql NpgsqlConnection.CheckNullの例

コード例 #1

ファイル: Extensions.NpgsqlConnection.ExecuteScalar.cs プロジェクト: cosmos-loops/cosmos-data

 /// <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 NpgsqlConnection conn, string cmdText, NpgsqlParameter[] parameters, CommandType commandType,
                                                NpgsqlTransaction transaction)
 {
     conn.CheckNull(nameof(conn));
     using var command = conn.CreateCommand(cmdText, commandType, transaction, parameters);
     return(command.ExecuteScalarAsync());
 }

コード例 #2

ファイル: Extensions.NpgsqlConnection.ExecuteReader.cs プロジェクト: cosmos-loops/cosmos-data

 /// <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 NpgsqlDataReader ExecuteReader(this NpgsqlConnection conn, string cmdText, NpgsqlParameter[] parameters, CommandType commandType,
                                              NpgsqlTransaction transaction)
 {
     conn.CheckNull(nameof(conn));
     using var command = conn.CreateCommand(cmdText, commandType, transaction, parameters);
     return(command.ExecuteReader());
 }

コード例 #3

 /// <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 NpgsqlConnection conn, Action <NpgsqlCommand> commandFactory) where T : new()
 {
     conn.CheckNull(nameof(conn));
     using var command        = conn.CreateCommand(commandFactory);
     using IDataReader reader = command.ExecuteReader();
     return(reader.ToEntities <T>());
 }

コード例 #4

 /// <summary>
 /// Execute a set of expando object
 /// </summary>
 /// <param name="conn"></param>
 /// <param name="commandFactory"></param>
 /// <returns></returns>
 public static IEnumerable <dynamic> ExecuteExpandoObjects(this NpgsqlConnection conn, Action <NpgsqlCommand> commandFactory)
 {
     conn.CheckNull(nameof(conn));
     using var command        = conn.CreateCommand(commandFactory);
     using IDataReader reader = command.ExecuteReader();
     return(reader.ToExpandoObjects());
 }

コード例 #5

 /// <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 NpgsqlConnection conn, string cmdText, NpgsqlParameter[] parameters, CommandType commandType,
                                                           NpgsqlTransaction transaction)
 {
     conn.CheckNull(nameof(conn));
     using var command        = conn.CreateCommand(cmdText, commandType, transaction, parameters);
     using IDataReader reader = command.ExecuteReader();
     return(reader.ToExpandoObjects());
 }

コード例 #6

 /// <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 NpgsqlConnection conn, string cmdText, NpgsqlParameter[] parameters, CommandType commandType,
                                                   NpgsqlTransaction 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>());
 }

コード例 #7

        /// <summary>
        /// Create command
        /// </summary>
        /// <param name="conn"></param>
        /// <param name="commandFactory"></param>
        /// <returns></returns>
        public static NpgsqlCommand CreateCommand(this NpgsqlConnection conn, Action <NpgsqlCommand> commandFactory)
        {
            conn.CheckNull(nameof(conn));
            var command = conn.CreateCommand();

            commandFactory?.Invoke(command);
            return(command);
        }

コード例 #8

ファイル: Extensions.NpgsqlConnection.ExecuteScalarAs.cs プロジェクト: 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 NpgsqlConnection conn, Action <NpgsqlCommand> 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());
        }

コード例 #9

ファイル: Extensions.NpgsqlConnection.ExecuteScalarAs.cs プロジェクト: 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 NpgsqlConnection conn, string cmdText, NpgsqlParameter[] parameters, CommandType commandType,
                                                              NpgsqlTransaction 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
            return((T)await command.ExecuteScalarAsync());
        }

コード例 #10

        /// <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 NpgsqlConnection conn, Action <NpgsqlCommand> 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());
        }

コード例 #11

        /// <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 NpgsqlConnection conn, Action <NpgsqlCommand> 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>());
        }

コード例 #12

        /// <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 NpgsqlConnection conn, string cmdText, NpgsqlParameter[] parameters, CommandType commandType,
                                                                                     NpgsqlTransaction 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());
        }

コード例 #13

ファイル: Extensions.NpgsqlConnection.ExecuteEntity.cs プロジェクト: cosmos-loops/cosmos-data

        /// <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 NpgsqlConnection conn, string cmdText, NpgsqlParameter[] parameters, CommandType commandType,
                                                            NpgsqlTransaction 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>());
        }

コード例 #14

ファイル: Extensions.NpgsqlConnection.ExecuteReader.cs プロジェクト: cosmos-loops/cosmos-data

        /// <summary>
        /// Execute Reader
        /// </summary>
        /// <param name="conn"></param>
        /// <param name="commandFactory"></param>
        /// <returns></returns>
        public static async Task <NpgsqlDataReader> ExecuteReaderAsync(
            this NpgsqlConnection conn, Action <NpgsqlCommand> commandFactory)
        {
            conn.CheckNull(nameof(conn));
#if NETFRAMEWORK || NETSTANDARD2_0
            using var command = conn.CreateCommand(commandFactory);
#else
            await using var command = conn.CreateCommand(commandFactory);
#endif

#if NET452
            return(command.ExecuteReader());
#else
            return(await command.ExecuteReaderAsync());
#endif
        }

コード例 #15

ファイル: Extensions.NpgsqlConnection.ExecuteReader.cs プロジェクト: cosmos-loops/cosmos-data

        /// <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 async Task <NpgsqlDataReader> ExecuteReaderAsync(
            this NpgsqlConnection conn, string cmdText, NpgsqlParameter[] parameters, CommandType commandType, NpgsqlTransaction 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

#if NET452
            return(command.ExecuteReader());
#else
            return(await command.ExecuteReaderAsync());
#endif
        }

コード例 #16

        /// <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 NpgsqlCommand CreateCommand(this NpgsqlConnection conn,
                                                  string cmdText, CommandType commandType, NpgsqlTransaction transaction,
                                                  params NpgsqlParameter[] 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);
        }

コード例 #17

ファイル: Extensions.NpgsqlConnection.ExecuteReader.cs プロジェクト: cosmos-loops/cosmos-data

 /// <summary>
 /// Execute Reader
 /// </summary>
 /// <param name="conn"></param>
 /// <param name="commandFactory"></param>
 /// <returns></returns>
 public static NpgsqlDataReader ExecuteReader(this NpgsqlConnection conn, Action <NpgsqlCommand> commandFactory)
 {
     conn.CheckNull(nameof(conn));
     using var command = conn.CreateCommand(commandFactory);
     return(command.ExecuteReader());
 }

コード例 #18

ファイル: Extensions.NpgsqlConnection.ExecuteReader.cs プロジェクト: cosmos-loops/cosmos-data

 /// <summary>
 /// Execute Reader
 /// </summary>
 /// <param name="conn"></param>
 /// <param name="cmdText"></param>
 /// <param name="parameters"></param>
 /// <param name="commandType"></param>
 /// <returns></returns>
 public static Task <NpgsqlDataReader> ExecuteReaderAsync(this NpgsqlConnection conn, string cmdText, NpgsqlParameter[] parameters, CommandType commandType)
 {
     conn.CheckNull(nameof(conn));
     return(conn.ExecuteReaderAsync(cmdText, parameters, commandType, null));
 }

コード例 #19

ファイル: Extensions.NpgsqlConnection.ExecuteReader.cs プロジェクト: cosmos-loops/cosmos-data

 /// <summary>
 /// Execute Reader
 /// </summary>
 /// <param name="conn"></param>
 /// <param name="cmdText"></param>
 /// <param name="transaction"></param>
 /// <returns></returns>
 public static Task <NpgsqlDataReader> ExecuteReaderAsync(this NpgsqlConnection conn, string cmdText, NpgsqlTransaction transaction)
 {
     conn.CheckNull(nameof(conn));
     return(conn.ExecuteReaderAsync(cmdText, null, CommandType.Text, transaction));
 }

コード例 #20

ファイル: Extensions.NpgsqlConnection.ExecuteScalar.cs プロジェクト: cosmos-loops/cosmos-data

 /// <summary>
 /// Execute scalar
 /// </summary>
 /// <param name="conn"></param>
 /// <param name="cmdText"></param>
 /// <param name="parameters"></param>
 /// <returns></returns>
 public static object ExecuteScalar(this NpgsqlConnection conn, string cmdText, NpgsqlParameter[] parameters)
 {
     conn.CheckNull(nameof(conn));
     return(conn.ExecuteScalar(cmdText, parameters, CommandType.Text, null));
 }

コード例 #21

ファイル: Extensions.NpgsqlConnection.ExecuteScalar.cs プロジェクト: cosmos-loops/cosmos-data

 /// <summary>
 /// Execute scalar
 /// </summary>
 /// <param name="conn"></param>
 /// <param name="cmdText"></param>
 /// <param name="commandType"></param>
 /// <returns></returns>
 public static object ExecuteScalar(this NpgsqlConnection conn, string cmdText, CommandType commandType)
 {
     conn.CheckNull(nameof(conn));
     return(conn.ExecuteScalar(cmdText, null, commandType, null));
 }

コード例 #22

ファイル: Extensions.NpgsqlConnection.ExecuteScalar.cs プロジェクト: cosmos-loops/cosmos-data

 /// <summary>
 /// Execute scalar
 /// </summary>
 /// <param name="conn"></param>
 /// <param name="cmdText"></param>
 /// <param name="transaction"></param>
 /// <returns></returns>
 public static object ExecuteScalar(this NpgsqlConnection conn, string cmdText, NpgsqlTransaction transaction)
 {
     conn.CheckNull(nameof(conn));
     return(conn.ExecuteScalar(cmdText, null, CommandType.Text, transaction));
 }

コード例 #23

ファイル: Extensions.NpgsqlConnection.ExecuteScalar.cs プロジェクト: cosmos-loops/cosmos-data

 /// <summary>
 /// Execute scalar
 /// </summary>
 /// <param name="conn"></param>
 /// <param name="cmdText"></param>
 /// <param name="parameters"></param>
 /// <param name="transaction"></param>
 /// <returns></returns>
 public static Task <object> ExecuteScalarAsync(this NpgsqlConnection conn, string cmdText, NpgsqlParameter[] parameters, NpgsqlTransaction transaction)
 {
     conn.CheckNull(nameof(conn));
     return(conn.ExecuteScalarAsync(cmdText, parameters, CommandType.Text, transaction));
 }

コード例 #24

ファイル: Extensions.NpgsqlConnection.ExecuteScalar.cs プロジェクト: cosmos-loops/cosmos-data

 /// <summary>
 /// Execute scalar
 /// </summary>
 /// <param name="conn"></param>
 /// <param name="commandFactory"></param>
 /// <returns></returns>
 public static Task <object> ExecuteScalarAsync(this NpgsqlConnection conn, Action <NpgsqlCommand> commandFactory)
 {
     conn.CheckNull(nameof(conn));
     using var command = conn.CreateCommand(commandFactory);
     return(command.ExecuteScalarAsync());
 }

コード例 #25

 /// <summary>
 /// Execute a set of expando object
 /// </summary>
 /// <param name="conn"></param>
 /// <param name="cmdText"></param>
 /// <param name="parameters"></param>
 /// <param name="commandType"></param>
 /// <returns></returns>
 public static Task <IEnumerable <dynamic> > ExecuteExpandoObjectsAsync(this NpgsqlConnection conn, string cmdText, NpgsqlParameter[] parameters, CommandType commandType)
 {
     conn.CheckNull(nameof(conn));
     return(conn.ExecuteExpandoObjectsAsync(cmdText, parameters, commandType, null));
 }

コード例 #26

ファイル: Extensions.NpgsqlConnection.ExecuteReader.cs プロジェクト: cosmos-loops/cosmos-data

 /// <summary>
 /// Execute Reader
 /// </summary>
 /// <param name="conn"></param>
 /// <param name="cmdText"></param>
 /// <returns></returns>
 public static NpgsqlDataReader ExecuteReader(this NpgsqlConnection conn, string cmdText)
 {
     conn.CheckNull(nameof(conn));
     return(conn.ExecuteReader(cmdText, null, CommandType.Text, null));
 }

コード例 #27

ファイル: Extensions.NpgsqlConnection.ExecuteReader.cs プロジェクト: cosmos-loops/cosmos-data

 /// <summary>
 /// Execute Reader
 /// </summary>
 /// <param name="conn"></param>
 /// <param name="cmdText"></param>
 /// <param name="commandType"></param>
 /// <param name="transaction"></param>
 /// <returns></returns>
 public static NpgsqlDataReader ExecuteReader(this NpgsqlConnection conn, string cmdText, CommandType commandType, NpgsqlTransaction transaction)
 {
     conn.CheckNull(nameof(conn));
     return(conn.ExecuteReader(cmdText, null, commandType, transaction));
 }

コード例 #28

ファイル: Extensions.NpgsqlConnection.ExecuteReader.cs プロジェクト: cosmos-loops/cosmos-data

 /// <summary>
 /// Execute Reader
 /// </summary>
 /// <param name="conn"></param>
 /// <param name="cmdText"></param>
 /// <param name="parameters"></param>
 /// <param name="transaction"></param>
 /// <returns></returns>
 public static NpgsqlDataReader ExecuteReader(this NpgsqlConnection conn, string cmdText, NpgsqlParameter[] parameters, NpgsqlTransaction transaction)
 {
     conn.CheckNull(nameof(conn));
     return(conn.ExecuteReader(cmdText, parameters, CommandType.Text, transaction));
 }

コード例 #29

ファイル: Extensions.NpgsqlConnection.ExecuteScalar.cs プロジェクト: cosmos-loops/cosmos-data

 /// <summary>
 /// Execute scalar
 /// </summary>
 /// <param name="conn"></param>
 /// <param name="cmdText"></param>
 /// <param name="commandType"></param>
 /// <param name="transaction"></param>
 /// <returns></returns>
 public static Task <object> ExecuteScalarAsync(this NpgsqlConnection conn, string cmdText, CommandType commandType, NpgsqlTransaction transaction)
 {
     conn.CheckNull(nameof(conn));
     return(conn.ExecuteScalarAsync(cmdText, null, commandType, transaction));
 }

コード例 #30

 /// <summary>
 /// Execute a set of expando object
 /// </summary>
 /// <param name="conn"></param>
 /// <param name="cmdText"></param>
 /// <param name="commandType"></param>
 /// <param name="transaction"></param>
 /// <returns></returns>
 public static IEnumerable <dynamic> ExecuteExpandoObjects(this NpgsqlConnection conn, string cmdText, CommandType commandType, NpgsqlTransaction transaction)
 {
     conn.CheckNull(nameof(conn));
     return(conn.ExecuteExpandoObjects(cmdText, null, commandType, transaction));
 }