Passing data between tiers.

[Edneeis]

Yes that is what I do or I use an abstract/base class that I made that handles all the database work and just inherit from it. It uses attributes or reflection to build the queries and does the work for me. Its the same concept as Object Relational Mapping which is pretty much what a dataset does too, although the Dataset is better at it then I am. Than any changes to the database just need to be reflected in the Object Mapping, the UI doesn't actually know the data just the object.

I have read that passing a Dataset up through layers isn't as bad as the samething was before but I still don't like it. Here is some info on mdsn: http://msdn.microsoft.com/library/de...tml/BOAGag.asp and a little more:
http://www.ftponline.com/wss/2002_07...efault_pf.aspx the last one (just a pdf version of the first one): http://www.mssql.org/Uploaded_Files/BizObj.pdf