i want to build a simple CRUD console application which consists of a set of 10-20 classes that need access to CRUD methods.
I do not want to create a connection each time in every method that needs db access. Maybe put all the creation part into a separate singleton class ?  

Any ideas, best practices how this kind of application should be structured ?