Create and use multiple database for single application

Question

I am creating a system which will have multiple customer. right now i am using same database and table for all customer but i think it'll slow down fetching of record when i'll have hundreds of customer's data in same database. so should i create separate database for each new registered customer dynamically by executing scripts from code? (will use master database to manage all user's connectionstrings)

I'm using entity framework. so same will be possible using EF? will it cause any problem?

Possible duplicate of Multiple Databases Vs Single Database with logically partitioned data — mjwills
– mjwills, Commented Jul 7, 2017 at 5:57
Your question is essentially can EF support multiple DB per app? to which the answer is yes — user585968
– user585968, Commented Jul 7, 2017 at 6:26

qingzhang · Accepted Answer · 2017-07-07 06:09:51Z

0

May be you can use ABP framework to handle multiple database with entity framework. ABP will help you to auto register repositories into IocContainer by adding attribute of all your DBContext (Each DBContext connect to a DB) as following:

[AutoRepositoryTypes(
typeof(IRepository<>),
typeof(IRepository<,>),
typeof(SimpleTaskSystemEfRepositoryBase<>),
typeof(SimpleTaskSystemEfRepositoryBase<,>)
)]
public class SimpleTaskSystemDbContext : AbpDbContext
{
     ...
}

answered Jul 7, 2017 at 6:09

qingzhang

1

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Create and use multiple database for single application

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related