I am new to dot net and would like to write an application using a
solid 3 tier design because I expect the app to require a lot of
updates and maintenance over time.
I am creating my own data objects to interact with the database but the
more I understand the DataAdapter classes, the more confused I get. It
seems that all I really need my data access classes to do is return a
dataset, then accept it back again for updating the database, but this
functionality already exists.
It seems that writing my own individual data access classes is really
unnecessary. In fact, when taking into account the ease of using
visual studio form designer to drag data classes onto my forms, I am
starting to reconsider my design. Since I am using stored procedures,
these are starting to look like a legitimate data tier in their own
right as they are encapsulating the underlying database tables and
preventing direct access.
I can't be the only person struggling through these design decisions.
What is the best solution? My goals are quick development AND
maintainability. The application will be used by a small number of
users - under 20, but I'd like it scalable anyway as this could change.
Is encapsulating the native data classes in my own class even
necessary?
Thanks in advance,
D