What Considerations do we need when creating a DB helper class in .Net?
A:
- Are you reinventing the wheel? There are lots of projects out there to aid with your database development.
- Can you refactor your CRUD? Consider the Repository pattern.
- Will you need transactions? If so you'll need a separate "submit" step instead of simply executing your inserts/updates/deletes one at a time.
- Are you going to need to access only one database platform (e.g. SQL Server) or will you need to support others?
roufamatic
2010-01-26 06:59:10