Find a specified generic DbSet in a DbContext dynamically when I have an entity

c# code-first dbset entity-framework generics

Question

I have following classes and DbContext:

public class Order:BaseEntity
{
   public Number {get; set;}
}
Product:BaseEntity;
{
  public Name {get; set;} 
}

public class Context : DbContext
{
    ....
    public DbSet<Order> Orders { set; get; }
    public DbSet<Product> Products { set; get; }
    ....
}

I have a list of objects that want to add to my context, too, but I don't know how can I find appropriate generic DbSet according each entity type dynamically. 

IList<BaseEntity> list = new List<BaseEntity>();
Order o1 = new Order();
o1.Numner = "Ord1";
list.Add(o1);

Product p1 = new Product();
p1.Name = "Pencil";
list.Add(p1);

Context cntx = new Context();  
foreach (BaseEntity entity in list)
{
      cntx.Set<?>().Add(entity);         
}

How can I do that?

1
30
8/20/2016 3:31:39 AM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Accepted Answer

DbContext has a method called Set, that you can use to get a non-generic DbSet, such as:

var someDbSet = this.Set(typeof(SomeEntity));

So in your case:

foreach (BaseEntity entity in list)
{
      cntx.Set(entity.GetType()).Add(entity);         
}
45
2/3/2014 5:31:23 PM

Popular Answer

The question does not specify EF version and the proposed answer does not work anymore for Entity Framework Core (in EF Core, DbContext does not have a non-generic Set method, at least at the date of this answer).

Yet you can still have a working extension method using Jon Skeet's answer to this question. My code is added below for convenience.

Update: Added the generic function call as well returning IQueryable<T> thanks to the comment from Shaddix. 

public static IQueryable Set(this DbContext context, Type T)
{
    // Get the generic type definition
    MethodInfo method = typeof(DbContext).GetMethod(nameof(DbContext.Set), BindingFlags.Public | BindingFlags.Instance);

    // Build a method with the specific type argument you're interested in
    method = method.MakeGenericMethod(T);

    return method.Invoke(context, null) as IQueryable;
}

public static IQueryable<T> Set<T>(this DbContext context)
{
    // Get the generic type definition 
    MethodInfo method = typeof(DbContext).GetMethod(nameof(DbContext.Set), BindingFlags.Public | BindingFlags.Instance);

    // Build a method with the specific type argument you're interested in 
    method = method.MakeGenericMethod(typeof(T)); 

    return method.Invoke(context, null) as IQueryable<T>;
}
user3141326

Related Questions

Find a record in dbSet using Find without a primary key

I've found it:...User myUser = myDBContext.Users.Single(user => user.Username == i_Username);
asp.net-mvc entity-framework linq
asked by Mortalus

Generic method to retrieve DbSet<T> from DbContext

I'm using the Entity Framework with a large database (made up of more than 200 tables)....Trying to create a generic method that returns the ...DbSet<T>... of a specific table ...T... (i.e. class, which can be ...TableA...)....The entity class that was (automatically) created using the entity data model looks like so:...public partial class sqlEnti...
c# entity-framework generics
asked by Serge P

Cannot get DbSet.Find to work with Moq (Using the Entity-Framework)

For some reason this code keeps failing. Anyone that can tell me why:... var activeLoans = new List<ActiveLoan> { new ActiveLoan{ ID = 1, CaseType = "STL", LoanCode = 0 }, new ActiveLoan{ ID = 2, CaseType = "STL", Loa...
c# entity-framework moq
asked by Peter Poulsen

DbContext -> DbSet -> Where clause is missing (Entity Framework 6)

I've read some tutorials with entity framework 6......The basics are easy....using (var context = new MyContext()) { User u = context.Users.Find(1); } ...But how to use "Where" or something else on the "DbSet" with the users?...public class MyContext : DbContext { public MyContext() : base("name=MyContext") { //this.Data...
c# entity-framework
asked by PatrickB

Generic Merge of DbContext: how to check if entity is all ready attached?

Given the following code:... void MergeDbContext(DbContext aSourceDbContext, DbContext aDestinationDbContext) { var sourceEntities = aSourceDbContext.ChangeTracker.Entries().ToList(); foreach (DbEntityEntry entry in sourceEntities) { object entity = entry.Entity; entry.State = EntityState.Detac...
dbcontext entity-framework-6
asked by Steven T. Cramer

DbSet.Attach(entity) vs DbContext.Entry(entity).State = EntityState.Modified

When you do ...context.Entry(entity).State = EntityState.Modified;..., you are not only attaching the entity to the ...DbContext..., you are also marking the whole entity as dirty. This means that when you do ...context.SaveChanges()..., EF will generate an update statement that will update ...all... the fields of the entity....This is not always ...
c# entity-framework entity-framework-6
asked by sstan

Could not find an implementation of the query pattern for source type 'System.Data.Entity.DbSet'

you will need to add reference to System.Data.Linq...System.Data.Linq is LINQ-SQL specific (DataContext, etc)...using System; using System.Collections.Generic; using System.Data.Entity; using System.Data.Linq; using System.Linq; public static class QueryClass { public static void Query() { using (var context = new MyDbEntities()) ...
c# entity-framework linq
asked by Krishna

DBSet<entity> class not found (Entity Framework loading wrong DLL?)

In my Visual Studio 2015 project I have a declaration...public DBSet<Page> Pages { get; set; } ...which gives me the error ...The type or namespace name 'DBSet' could not be found (are you missing a using directive or an assembly reference?)..... which shouldn't be happening because I have ......using System.Data.Entity; ...at the start of the file...
.net asp.net-mvc c# entity-framework-6 visual-studio
asked by clayRay

Filtering non-generic DbSet with dynamically built Expression

Plot:...I have a class implemented as a facade around Entity Framework DB context. It developed to maintain backward compatibility, it mimics class with same public interface, but uses DTOs instead of EF entities....Problem:...I have next method inside class described above. See code below:...public IQueryable<T> FindBy<T>(Expression<Func<T, Boolea...
dbset entity-framework expression-trees generics linq
asked by Andrey Weber

Rollback additions / removals to DBSets of the DbContext using a transaction in Entity Framework

A general pattern for me in a project using Entity Framework 6 is to ...Create new entities for addition...Add the entities to the relevant ...DBSet... of the ...DbContext...Set the properties of these objects...Call ...DbContext.SaveChanges()...Here is some pseudo-code for what I mean:... // Psuedo code to illustrate process. void AddProce...
c# dbcontext entity-framework entity-framework-6
asked by Cleve

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge
View more on Stack Overflow

Prime Library

Performance

Expression Evaluator

More Projects...

Related

Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow