We need to write a multi-tenant web application in ASP.NET MVC 2, meaning that we have a single code base running on one (or more) Web Servers and a single database (on a single Database Server). The app supports about 35-40 different tenants / customers. Some level or customization is required for each tenant, including look and feel, some basic functionality, and probably some custom database objects / columns and custom reporting.
I have been searching the Internet for examples on multi-tenant ASP.NET MVC applications and was surprised to find very little information. I located some discussions but does anyone have real-world experience in this area -- ideally with an application in production?
I'd really like to hear how it was implemented, how it performs, and the level of customization that is offerered to each tenant.
Thanks in advance.