Entity Framework Multi-Tenant Architecture With Multiple Databases & Generics

Question

I'm needing to build a multi-tenanted application. The code is completely shared for each company but each company has its own database.

Each company accesses the application through a Web API passing their own 'API Key'. This key is used to 'look up' the company specific configuration details within the master database's 'GlobalCompanies' table that holds company specific details including the database details and full connection strings.

My goal, to set up a new customer, is to simply run some scripts to create a new database and update this 'GlobalCompanies' table with the new database details and everything will just work!

So, no configuration information within the web.config file except perhaps the master database holding the configuration details.

The flow would therefore be:

Browser calls a Web API method and passes API Key
Application uses API Key and determines which database is being used
Application uses common code but applies database operations to the company-specific database.

I found this article Repository Pattern with Entity Framework 4.1 and Code First which gives me an insight to generics for the Repository pattern but I'm unsure how I would dynamically create and utilise different DBContexts? (if even that is the correct approach)?

I have done this before with ADO.net using different connection strings but ideally I'd like to utilize Entity Framework and generics.

Could someone please point me in the right direction? I couldn't find any specific examples of this architecture.

simon at rcl · Accepted Answer · 2016-03-12 11:48:10Z

1

EF is the same as what you did with ADO.Net. You just pass a different connection string to the constructor of the context. (The default constructor with no parameter will take the connection string from the config file.) The context won't care where the connection string comes from - config file, master database, constructed by the calling code - it will just use it.

Of course, if the connection string is malformed, or points to a db which doesn't contain the expected tables, then there will be problems. But I'm sure that you'd expect that.

answered Mar 12, 2016 at 11:48

simon at rcl

7,3691 gold badge21 silver badges25 bronze badges

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

2 Comments

ChrisCurrie Over a year ago

Wow. I should have just looked at the constructor... I am now having another issue whereby I cannot pass the connection string into a repository (via the constructor) and then further use this in the context constructor. I receive the error "A field initializer cannot reference the non-static field, method, or property..." which I can understand (after looking it up) but I cannot understand how I can approach the issue to get around it.

simon at rcl Over a year ago

I think your best bet is to post a new question, showing your code around where the error happens so that we have a chance of understanding what it's doing. (Glad the answer helped!)

Collectives™ on Stack Overflow

Entity Framework Multi-Tenant Architecture With Multiple Databases & Generics

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related