I (and every book I had read -- and even Microsoft) would disagree with keeping a connection open for the life of the application. A SQL connection is a valuable resource. Keeping it open is BIG trouble if you will be using MSDE.

John