Omega HR Solutions, Inc.
I was tasked with converting the company website from circa 2000 legacy ASP which would only show dynamic data on IIS5 to something that would at least be IIS6 compatible. The database back end, if you could call it that, was a series of .mdb files (Access).
I chose ASP.NET MVC with Steve Sampson's Areas modification of Phil Haack's prototype, MvcContrib, xVal, MvcMembership, Elmah, and Combres to make the site as future proof as possible. I used a SQL 2005 Database Project and SSIS to convert the raw data from Access to SQL. I had done this before realizing the production server would be SQL 2000 so I added SQL Publishing Wizard to the mix to create a lowest common denominator SQL database.
The user section is driven by MvcMembership to handle additions, deletions, and basic user manipulation. Each List page uses MvcContrib's grid control to make things easier. The previous control panel had no way of deleting anything so the only way to remove an item was to make it not visible. There was also no validation, no controls tied to their type like DateTime, and the database logged every session. At a certain point I'd have to open the database in Access or equivalent and clear them out because Access has a table row limit. There was also no way to edit tags or categories so I opened up as much configuration as possible.
Like the Admin Control Panel, there was no server-side validation tying database types to their controls, it only looked for required fields. Using xVal made this a breeze and eliminated a lot of bot submissions in the process without the need of a CAPTCHA control so far.
Update: Omega HR Solutions has since switched their website over to WordPress as of a few years ago now. To see what a difference design makes, check it out: http://omegahrsolutions.com