Typed DataSets with many to many relationships

Ever wondered how to construct multitable DataSets in a proper manner? Whether to use one dataadapter or several? Just found this one on MSDN:

Navigation Multiple Related Tables in an ADO.NET Dataset 

To make it even better use Annotations in the XSD file to improve the syntax of the generated code. Explained at MSDN.

Combined with Shawn Wildermuths Typed Dataset generator in the ADO.NET Powertoys managing relationships through XSD and generating code is a breeze.

Have a look here for a screenshot on how to set the CustomTool property of the XSD file to specify AGDataSetGenerator (Shawns) instead of MSDataSetGenerator.


No Comments