cdemott33
asked on
Best Practice - Table Adaptors
I would just like to ask the experts here on the exchange how they prefer to setup their Dataset/TableAdaptors.
I was following along here....
http://msdn.microsoft.com/en-us/library/aa581778.aspx
... and it looks as though the author of this article places all his Tables into a single DataSet.xsd file. So he has a single Northwind.xsd file and he places 4 table adapters within the DataSet.
Is this practical for larger scale applications?
I have 30+ tables in my Database and I'm wondering if it makes more sense to have individual DataSet.xsd files for each Table versus having a single xsd file with 30+ adaptors in it.
I'm really just wonder what you guys do and how you handle situation like mine.
Thanks!
I was following along here....
http://msdn.microsoft.com/en-us/library/aa581778.aspx
... and it looks as though the author of this article places all his Tables into a single DataSet.xsd file. So he has a single Northwind.xsd file and he places 4 table adapters within the DataSet.
Is this practical for larger scale applications?
I have 30+ tables in my Database and I'm wondering if it makes more sense to have individual DataSet.xsd files for each Table versus having a single xsd file with 30+ adaptors in it.
I'm really just wonder what you guys do and how you handle situation like mine.
Thanks!
I do not like typed datasets at all. I use plain DataTable most of the time and only use a Dataset when I am dealing with multiple related datatables.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Hi James - Thank you so much for your feedback. Can you recommend a good article(s) that provide excellent tutorials for creating DataTables?
Hi cdemott33.
I learned from the framework documentation and trial and error some 12 years ago, so I do not know of a good article. I could search for you, just as you could search yourself. But not knowing you, you would be better than me at finding an article suited to your level of expertise and you background.
I learned from the framework documentation and trial and error some 12 years ago, so I do not know of a good article. I could search for you, just as you could search yourself. But not knowing you, you would be better than me at finding an article suited to your level of expertise and you background.