Adding dynamically a DbSet<TEntity> in DbContext class

Question

Is there a way to add DbSet<TEntity> Property in DbContext class at runtime without passing through OnModelCreating ?

You don't need a property, just call db.Set<T>(). But you do need the type defined in the model somehow. — Jeremy Lakeman
– Jeremy Lakeman, Commented May 6, 2022 at 1:55
What are you trying to do that would require you to do this? — gunr2171
– gunr2171, Commented May 6, 2022 at 2:01
I’m trying to add tables at runtime I succeeded to add class dynamically but I couldn’t update the DbContext class so that I can add my created class as DbSet<NewClass> — Wijlini Abdelmonem
– Wijlini Abdelmonem, Commented May 6, 2022 at 4:05

Filip Gorgievski · Accepted Answer · 2022-05-07 19:51:35Z

2

You can do it by dynamically creating a new type that inherits from DbContext and the use Reflection Emit to add the DbSets to this type.

It's a bit of a long solution to try and post into a response here, but here's a GitHub link to a working demo of how it can be done

answered May 7, 2022 at 19:51

Filip Gorgievski

1181 silver badge7 bronze badges

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

1 Answer 1