Using database Connection in .NET

Question

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?