Npgsql.NpgsqlConnection.Clone C# (CSharp) Method

Clone() public method

Create a new connection based on this one.
public Clone ( ) : NpgsqlConnection
return NpgsqlConnection
        public NpgsqlConnection Clone()
        {
            CheckNotDisposed();

            NpgsqlConnection C = new NpgsqlConnection(ConnectionString);

            C.Notice += this.Notice;

            if (connector != null)
            {
                C.Open();
            }

            return C;
        }

Usage Example

示例#1
0
        public static async Task <bool> SetAccountInfo(string userId, string password)
        {
            var conn = baseConn.Clone();

            try
            {
                NpgsqlCommand cmd = new NpgsqlCommand(Query_SetAccountInfo, conn);
                cmd.Parameters.Add("id", NpgsqlTypes.NpgsqlDbType.Varchar, 16);
                cmd.Parameters[0].Value = userId;
                cmd.Parameters.Add("password", NpgsqlTypes.NpgsqlDbType.Text);
                cmd.Parameters[1].Value = password;
                cmd.Parameters.Add("claims", NpgsqlTypes.NpgsqlDbType.Array | NpgsqlTypes.NpgsqlDbType.Varchar);
                cmd.Parameters[2].Value = userIdentity;
                await conn.OpenAsync();

                int rowAffected = await cmd.ExecuteNonQueryAsync();

                conn.Close();
                return(rowAffected > 0);
            }
            catch
            {
                conn.Close();
                return(false);
            }
        }
All Usage Examples Of Npgsql.NpgsqlConnection::Clone