我应该在数据访问层中保留sqlconnection吗？

It seems like there is a lot of overhead involved in rapidly opening and closing sqlconnections. Should I persist a connection (one, per client, per database), or continue declaring a new sqlconnection object whenever I need one, and making sure I clean up after myself?It seems like there is a lot of overhead involv