C#

N a v a n e e t h wrote:

Doesn't sounds like a good idea to me.

N a v a n e e t h wrote:

separate connection and command instances for each threads

N a v a n e e t h wrote:

ADO.NET has inbuilt connection pooling

N a v a n e e t h wrote:

you don't need to pool it manually

PIEBALDconsult wrote:

The pooling only pools the connections that have been created by the application

PIEBALDconsult wrote:

So the developer still has to do that.

N a v a n e e t h wrote:

these objects will be created and ready to use

N a v a n e e t h wrote:

When SqlConnection object is requested, it will be served from the pool if available.

N a v a n e e t h wrote:

gets disposed properly and return back to the pool

PIEBALDconsult wrote:

With what settings? How will the pool know what the user wants to connect to until asked?

PIEBALDconsult wrote:

I understand that happens at Close

dbc.AddConnection ( "name" )
 
dbc [ "name" ].Execute...
 
dbc.RemoveConnection ( "name" )

public class A 
{
// non-generic implementation ommited

public int Xyz()
{ // details omitted
}
}

public class A<T> : A where T : class
{
  // generic implementation ommited
}

if (ref is A)
{
int returnValue = ((A)ref).Xyz();
}

public class A<T> where T : class {

    public int Xyz() { return 1; }
}

public class CPTest_Generic : CPTest {

    public override void Test(int arg) {
        test2(new A<Form>());
    }

    public int test2(object rf) {
        A<Form> aa=rf as A<Form>;
        int result=0;
        if (aa!=null) result=aa.Xyz();
        log("result="+result);
        return result;
    }
}

public interface Abase {
    int Xyz();
}

public class A<T> : Abase where T : class {
    public int Xyz() { return 1; }
}

public class CPTest_Generic : CPTest {

    public override void Test(int arg) {
        test2(new A<Form>());
    }

    public int test2(object rf) {
        Abase aa=rf as Abase;
        int result=0;
        if (aa!=null) result=aa.Xyz();
        log("result="+result);
        return result;
    }
}

public interface Abase<T>
{
    T Xyz() ;
}

public class A<T> : IA where T : class
{
    public int Xyz()
    {
        return 1;
    }
}
public interface IA
{
    int Xyz();
}

// where a is an instance of A<T>
if (a is IA)
    int returnValue = (a as IA).Xyz();