Attention: We are retiring the ASP.NET Community Blogs. Learn more >

DataSets

Clemens and Roy are blogging about DataSets, and I’ll join them.

I like DataSets.

I do not agree with Roy in that they are “mainly for use in small, simple projects, which require fast time-to-market with a database that changes rarely”. He is probably confusing the DataSets itself with the usual way to load them using .NET, which is using an IDbDataAdapter with the SQL statements embedded.

If you load DataSets using a CommandBuilder that you instantiate in the UI layer, then you probably will be in trouble if your schema changes, but that’s not a very common design when you are trying to do the right thing and you design your application in layers.

You can build a layer that loads, validates and persists DataSets. In that layer, you can use CommandBuilders, or stored procedures, or use a tool that generates code to work with the DataSets (hint, hint ;).

2 Comments

Comments have been disabled for this content.