c# easy way to create new db when new customer is added

Question

what can be a easy way to create new db when we create new customer record?

Scenario:

I have list of customers [may be upto 500 customers] in master database
Whenever I add new customer in my application, I would like to create new separate database to each client [just to separate respective clients' data entirely from each other]
Application will connect to master database and respective client db as per login credential.
- No of customers may be upto 500,
- I am planning to add only 50 dbs per server instance, after that again will be adding to next server instance

Options I have selected:

Use Code first approach of ef6.0 to create and seed primary data of each client when new client is added
Use Custom "Create database script" and import seed data from custom script.sql file

You may want to test how your SQL Server performs if it has 500 databases on it. And you may find https://stackoverflow.com/questions/21844479/multiple-databases-vs-single-database-with-logically-partitioned-data of use. — mjwills, Jun 04 '17 at 12:01
of course i will be seperating 50 dbs per instance of sql server. — KoolKabin, Jun 04 '17 at 12:03
Have a look at [this](http://benfoster.io/blog/aspnet-core-multi-tenancy-data-isolation-with-entity-framework) — Steve Greene, Jun 04 '17 at 13:38
@SteveGreene your solution looks much good, wondering whether it is available in EF6 also or not... — KoolKabin, Jun 06 '17 at 10:36
Yeah, there are a lot of articles out there like [this](https://weblogs.asp.net/ricardoperes/entity-framework-multitenancy). Just search "multi tenant". — Steve Greene, Jun 06 '17 at 12:53

score 1 · Accepted Answer · edited Jun 04 '17 at 12:01

1

Copy SQL Server database in code would be a reasonable option for backing up and restoring an existing 'vanilla' (i.e. with no customer data in it) database.

Of course you only need to backup once - you just restore for each new customer.

edited Jun 04 '17 at 12:01

CodeNotFound

22,153
10
68
69

answered Jun 04 '17 at 11:55

mjwills

23,389
6
40
63

seems good and easy option... trying it right now... btw i miss creating blank db to new customer before restoring it with backup of existing db – KoolKabin Jun 04 '17 at 11:58
Excellent - I am glad I could be of assistance! – mjwills Jun 04 '17 at 21:26

c# easy way to create new db when new customer is added

1 Answers1