Which is the best way to design my data layer in asp.net 2.0?

Question

Using tableadapters that generates typed or untyped datasets?

Answer 1

i'm oldskool! i'd create DataProvider objects that contains static methods for each collection of data you wish to use (i.e. from a stored procedure). if you wish, you could cache the result set in private static variable. you static methods would simply call a sproc if the private static variable is null or if a cache has expired.