>As I think about it, I would not be surprised if I needed a separate sproc for each table and if I can't do the multiple table pull from one sproc - that maybe some strataframe jiggery pokery that is not native to .NET ???
>
>So basically the problem is that since I have to write the sprocs anyway, I don't want to have to manually write datasets or entity classes as well for each sproc.
I am not sure about your design time issue, but I will confirm that we return as many as 53 tables from a single sproc. We pass an array of table names to the DAL to create a usable DS. However we don't use VS to maintain our SQL code, we maintain our sprocs
via SSMS.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only