Typed Datasets make me smile

By ian

So I’ve been going through some new data access tutorials in the MSD library. Let me say that I’m very glad that I did.

The first few tutorials cover creating and working with typed datasets (.xsd). Essentially they allow you to build an entire data access layer in a few hours. Visual Studio writes all of the SQL and creates the neccesary methods for accesing the data.

Since its autogenerated code, its not perfect. However, it’s very easy to create a few partial classes to extend the generated code. If you use .NET and you aren’t using typed datasets, you should read this new series of tutorials.