Loading

Using database Connection in .NET

ganesh_hebbar

What is the efficient way of accessing the database in .NET applications? Is it efficient to open the connection in a module and use it globally (in VB.NET) or use the connection string in the function open the connection get the job done and close it. use the same through out the app?

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Andrzej Wegierski21y ago
I open connection every time if I want to use it and close it after use. It's very fast.