I'm building a system where
aspx and code behind are my presentation layer ( validation happens in code behind ),
the application logic is in separate classes,
the data access logic is in separate classes.
Most of the time I will need to access one row ( usually joined tables ) at a time - except for read-only reports.
Is it possible to create empty DataSet in the application layer and populate it with data ( one row ), then pass it to data layer which uses this DataSet to update the DB?
Overall I'm looking for a more elegant sollution than passing SQL statments...
I'm willing to incrase points if I am able to use the sollution...also If you could provide me with a better architecture ( with examples ) I could use I'm willing to give extra points.
please ask if the question is not clear