I will be thankful if u can give me some suggestions on the following.

in the earlier versions, I always used to open the connections & use the same connection whole through the application without closing it. in ADO.Net should i open the connection & keep it open whole through the application or open it & close it only when required. which is the most efficient way.