Multiple Db Connection Sql and Postgresq

Question

I'm trying to find a generic way for multiple db connection support.

        private void ExecuteCommand(string connStr, Action<NpgsqlConnection> task)
    {

            using (var conn = new NpgsqlConnection(connStr))
            {
                conn.Open();

                task(conn);
            }
      }

I have 2 Databases which are sql and postgresql. I dont want to duplicate my function 2 of them. So I need something like that:

if (db == sql) new sqlConnection() else new NpsqlConnection()

How can i do that in simple way?

David Browne - Microsoft · Accepted Answer · 2020-04-22 14:53:52Z

1

There are a common set of base classes and interfaces for ADO.NET. EG

 private void ExecuteCommand(string sql, DbConnection con)
 {
    var cmd = con.CreateCommand();
    cmd.CommandText = sql;
    cmd.ExecuteNonQuery();
 }

answered Apr 22, 2020 at 14:53

David Browne - Microsoft

90.7k7 gold badges52 silver badges87 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Multiple Db Connection Sql and Postgresq

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related