News
Currently working on complete Enterprise Design Patterns set of examples and blog articles based on AdventureWorks 2008 R2 Sample Database.
This is my favorite sample database as you can use if for about anything from simple applications development to business intelligence applications

(I’ll be posting on this series here. It will be based on the presentations I’m creating for thePhillyNJ.NETuser group a subgroup of PhillyDotNet)

This is the start of a long series on “applied design patterns”. The intent to demonstrate design patterns in real code. I am not endorsing or “pushing” any specific methodologies. But I will be stressing various points of views many of which are part of various methodologies you may have heard of.

That said I have specific goals for this series which are.

1.To write the code implementing the design patterns.

2.To have the code implementing the pattern be in an actual component as it would be used in a Enterprise level application.

In a sense we will sort of be taking the bottom up approach. This is because we have and existing database and reusable components that have been evolving through the years.

Many years as a matter of fact.

The fact is my reusable components are always evolving with some having their basis in my old days of a C programmer working on medical equipment. Through the Visual Basic years, and on into the .NET framework and C#.

One big example is the “DBAccess” library. This name for my personal data access component goes all the way back to the wrapper I put around the B-Tree library called C-Index by Trios Systems in eighties.

So it is safe to say I’m stuck on some naming conventions. But I assure you this version we are working on is “State of My Art”.

The AdventureWorks Database goes back to SQL Server 2005. It was the sample database to replace the PUBS and NORTHWIND we old timers have know to over and hate though the years.

It was built to be robust and to demonstrate the use f the Business Intelligence services in SQL Server. Aside from the Project REAL database there is no other sample database that is as robust and could be used to support any type of Demonstrator” ”Proof of Concept” application. You can find the AdventureWorks database in it’s latest evolution on CodePlex at http://msftdbprodsamples.codeplex.com/releases/view/55926 .