How to use Sql connection inside another connection?

Question

I faced some problem about sql connection issue. The problem is I have some code like this

function1()
{
    using (sqlconnection sc = new sqlconnection())
   {
      foo();
   }
}

foo is a function like below:
foo()
{
   using (sqlconnection sc = new sqlconnection())
  {
        dosomething;
  }
}

It seems that the sqlconnection in foo() cannot work. I'm wondering if it is a good idea to pass the sqlconnection into foo like foo(sc), or is it a good idea to take foo outside function1, or is there anyway to allow the sqlconnection inside foo works.

Without more specifics we can't really say. Are they trying to connect to the same server? Why do you need the connection in function1 if all it's doing is calling another method? — sab669
– sab669, Commented Sep 24, 2015 at 14:10
A connection is a session. Sessions are separate. In essence if you use a sqlcommand you tie it to a connection. Within one connection you can use only a single sqlreader, unless you enable mars. Multiple result sets. In short what you are trying should work, if it does not there is a different issue. You should show more code and real errors or exceptions. — Philip Stuyck
– Philip Stuyck, Commented Sep 24, 2015 at 14:11

Rahul · Accepted Answer · 2015-09-24 14:15:14Z

3

No need of that, have your function foo to accepts a connection parameter and use the same connection instance in both places like below

function1()
{
    using (sqlconnection sc = new sqlconnection())
   {
      foo(sc);
   }
}

foo is a function like below:

foo(sqlconnection scc)
{
    sqlconnection sc = scc
    dosomething;
}

answered Sep 24, 2015 at 14:15

Rahul

78.1k14 gold badges80 silver badges132 bronze badges

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

3 Comments

litaoshen Over a year ago

seems a good idea, will sc inside foo affect sc inside function1? Since it is a connection, I don't know if it is a "copy" of sc inside function1 like other "virtual" object is.

Rahul Over a year ago

@litaoshen, Yes it will since it's a reference type and not a value type but the sole idea is to use the same connection object instead having multiple one. You can use the same con object and can have different command object or same to that matter.

litaoshen Over a year ago

OK, I see. Thank you!

Collectives™ on Stack Overflow

How to use Sql connection inside another connection?

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related