Dynamically loading DbSet to DbContext

DbSet.Add & DbSet.Remove Versus using EntityState.Added & EntityState.Deleted

From Lerman & Miller's DbContext book (p. 80):...Calling ...DbSet.Add... and setting the ...State... to ...Added... both achieve exactly the same thing....Which is:...If the entity is not tracked by the context, it will start being tracked by the context in the ...Added... state. Both ...DbSet.Add... and setting the ...State... to ...Added... are...

Find a generic DbSet in a DbContext dynamically

So how did I do it when I am not aware of ...<T>... during compile time....First need to get the type as ...DbContext.Set... method returns a non-generic DbSet instance for access to entities of the given type in the context and the underlying store....public virtual DbSet Set(Type entityType) ...Note here argument is the type of entity for which a...

Entity Framework Core: How to dynamically get the DbSet from a derived Type?

Tell EF explicitly what table to use:...[Table("GICSSectors")] public class GICSSector: Sector { public virtual ICollection<GICSIndustryGroup> IndustryGroups {get; set;} } ...or use fluent api:...modelBuilder.Entity<GICSSector>().ToTable("GICSSectors");

Application Context DbSet<> How to Inherit DbSets from another class

The following is a simple DcContext that we use. We are now using hundreds of tables and we want to organize our DbSets into smaller classes...//Working Example //ApplicationDbContext.cs public class ApplicationDbContext : IdentityDbContext<ApplicationUser> { public ApplicationDbContext(DbContextOptions<ApplicationDbContext> options) : bas...

Load EF Core 2 DbContext from dynamically imported DLL

Basically the question is how to create / get ...DbContextOptions<DefaultContext>... instance via reflection. You can do that by first constructing a generic type via ...MakeGenericType... and then use that type as argument to ...Activator.CreateInstance.......So having ...var dbContextType = reporting.GetType("Reporting.DefaultContext"); ...someth...

Is there an OCP-friendly way to dynamically choose which collection in a DbContext to access?

You can use TPH to simplify you context and action....Models:...public enum PhraseType { English, Spanish } public abstract class Phrase { public int Id { get; set; } public string Text { get; set; } public PhraseType PhraseType { get; set; } } public class EnglishPhrase : Phrase {} public class SpanishPhrase : Phrase {} ...D...

Dynamically get a DbSet<T> by Entity class name

returns me an IQueryable<object>, I need an IQueryable<MyType> ...Well, that will never work. Your IQueryable cannot be of type ...IQueryable<MyType>...because that would mean the compiler would need to know what ...MyType... is and that is not possible, because the whole point of this exercise is to decide that on runtime....Maybe it's enough to ....

.net Core EF - Dynamically Add to DbSet by string name or type

Suppose I have a thousand classes that all inherit one base class, and each of these classes (not the base) has a table, each of which has the same required columns. How can I use reflection or generics to add or update a row in the correct table? I'll know the name of the specific entity at runtime....There are a handful of stackoverflow posts a...

How to dynamically select the DbSet column name?

In this link (...https://www.strathweb.com/2018/01/easy-way-to-create-a-c-lambda-expression-from-a-string-with-roslyn/...), you can see how to create lambda expression from string. In there, he uses an example in Where(), but you should be able to create a Select() expression such as...var selectString = "x => x.colName"; var options = ScriptOption...

Access a Class (dbcontext) Property Dynamically by Property Name

Since these classes have exactly same fields, you can create ...a common class... as the base class to store the fields. ...In my example, there are three tables (tb1, tb2, tb3) and a base class (...tbBase...),the base class is not related to database:... public class tbBase { public int Id { get; set; } public string Description { get; set...