Design pattern for Database Context

I have a small library system application which I want to implement CRUD operation on Books and other related services. When choosing the pattern for my data access layer, my initial thought was that a singleton pattern would ensure only one object i...