Dynamic creation of models - entities using Asp.Net MVC

Question

So, i have my database sorted like:

Products_001 Products_002 Products_003

Let's say, if a customer logs in and his id is 001, he is only entitled to use the database-table products_001.

Can i dynamically create his model - entity using Asp.Net MVC, and how would i do this?

Anthony Johnston · Accepted Answer · 2010-07-15 08:27:14Z

4

ProductsBase products = Activator.CreateInstance(
    "YourAssembly.Namespace", 
    "Products_" + Login.Id);

http://msdn.microsoft.com/en-us/library/d133hta4.aspx

You may need to have a base type/interface for your different product types

answered Jul 15, 2010 at 8:27

Anthony Johnston

9,6544 gold badges49 silver badges62 bronze badges

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

2 Comments

NicoJuicy Over a year ago

Is this solution scalable? Eg. let's say the client uses this "custom model" for his website. => client 1 has website 1 and uses table product_001 - client 2 has website 2 and uses table product_002

Anthony Johnston Over a year ago

thats probably another question, do you have this structure in place or are you considering it for a design?

abarr · Accepted Answer · 2010-07-15 08:28:55Z

0

NicoJuicy,

The way we handled this was to have a generic model (Using EF) and different DB's for each table. When the user logs in we bind the Model to the appropriate Db using the connection string and the user info.

If this sounds like what you want let me know and I will post more details.

Andrew

answered Jul 15, 2010 at 8:28

abarr

1,1404 gold badges13 silver badges28 bronze badges

2 Comments

NicoJuicy Over a year ago

I think this solution is very resource intensive (correct me if i'm wrong)

abarr Over a year ago

I probably fudged the answer a bit as we have a multi tenancy app so as soon as they login we bind the EF Model to that clients db and that is it for the entire session.

Collectives™ on Stack Overflow

Dynamic creation of models - entities using Asp.Net MVC

2 Answers 2

2 Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related