What is the best approach to connection management in a key data operator (kdo) type data entry (C# Winform) application with regards to database as well as client app performance? let's say the kdo is reading, editing, and writing back a table row every 5-10 seconds; should we open the connection and leave it open for the session (1000 rows), or open and close it for each row processed?