Hi
I am building a multi-tendent mode saas application using Asp.net(MVC) with SQL database.
Every week i want to release new version for users, so my application url will look like
v1.mydomain.com, v2.mydomain.com, v3.mydomain.com and etc.
User can use any versions, based on their need.
if newer version has bugs, he can go to previous versions
if user is ok with V1, then he will use Version1 (v1.mydomain.com)
But we have only one database for all versions, the problem is **SQL server table changes and procedure changes**
For example :
In V1, customers table we have 15 columns.
In V2, we have added 5 columns
In V3, we have added 3 columns
we are using stored procedure to execute all of our database operations.
In V1,
from code we are passing 15 parameters => db also have 15 parameters
In V2,
from code we are passing 15 parameters => we need to alter the related stored proceudre as 15 parameters.
Here V1 application will pass only 11 parms, now V1 app gets error.
I haven't been able to find what I'm looking for.
How can we use the single database for multiple application versions, is there any way to do this.
What I have tried:
what is the best way for this?