Stored Procedures in VS2005

[dmowfo]

Hello,

We are currently writing an ASP.NET website to replace an existing VB6 app which runs heavily uses Stored Procedures in SQL Server.

We've set up a Dataset in which to place our all our Data Access stuff - we're then using the ObjectDataSource to talk to the TableAdapters.

I understand that I can drag on Tables to the Dataset and create the appropriate relationships.

When using more complicated Stored Procedures which access several Tables, should we just drag these on as well? I'm just worried about having an absolutely massive Dataset with hundreds of Stored Procedures on it. Plus, what would happen with the relationships?

Sorry if this is a daft question but I want to get it right before I make too much progress.

Thanks :)

[technifox]

Hello dmowfo

Have you thought about using LINQ. A good starting spot is here (http://weblogs.asp.net/scottgu/archive/2006/05/14/Using-LINQ-with-ASP.NET-_2800_Part-1_2900_.aspx).