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

.NET Petshop 2.0

There's a 2.0 version of the .NET PetShop application. They added support for distributed transactions and a Web Service façade for getting order information.

If you are wondering if the database design was improved, it wasn't. It really got worse, as they dropped some referential integrity constraints that were right.

Now you can, for example, delete the 'Account' information for a registered user, without deleting the 'Profile' information for it, so you'll have 'phantom' users in the 'Profile' table.

 

1 Comment

  • the question is... does dropping constraints actually improve performance??? Not that I'm even close to advocating this, but if you drop all of your constraints and you gain a 20% increase in the performance of your database server, and your application level code more or less already is performing the same validations, then is this a worthwhile performance tuning action?

Comments have been disabled for this content.