Entity framework – get entity by name

by

You can do it using reflection, however you will also need to use generics because the type of list returned by the ToList() method is different for each entity type.

You can access a property getter through reflection like so:

var enumerable = typeof([ClassNameOfContext]).GetProperty(name).GetValue(ctx, null);

Whereas [ClassNameOfContext] is the name of the class that ctx is an instance of. This is not obvious from your code, but you know it 🙂

The problem is that enumerable will be an object and has to be casted to IEnumerable<EntityType> where EntityType is the type of entity you are accessing. In other words, it depends on the name you are passing. If you use generics to determine the type, you will be able to properly cast the object and don’t have to return a dynamic even.

public TEntity Get<TEntity>(string name)
{
    ...

and transform the line from above:

var enumerable = (IEnumerable<TEntity>)(typeof([ClassNameOfContext]).GetProperty(name).GetValue(ctx, null));
return enumerable.ToList();

here you go!

Addendum: You could, conceivably, get rid of the string parameter, too – having names of types or properties in strings should be avoided where possible because it is not type safe. The compiler does not recognize it, and IDE features such as refactorings don’t account for it. The problem here is that the property names are usually the pluralized form of the entity type names. But you could use reflection to find the property whose type matches the TEntity. I leave this as an exercise 🙂

More Related Contents:

  1. Dynamic table name in linq [duplicate]
  2. Get property value from string using reflection
  3. Loading DLLs at runtime in C#
  4. Testing if object is of generic type in C#
  5. Entity Framework Core: A second operation started on this context before a previous operation completed
  6. LINQ To Entities does not recognize the method Last. Really?
  7. Bulk-deleting in LINQ to Entities
  8. Entity Framework And Business Objects
  9. Getting a System.Type from type’s partial name
  10. How to get a property value using reflection
  11. Self referencing loop detected – Getting back data from WebApi to the browser
  12. How to load Assembly at runtime and create class instance?
  13. LINQ, Unable to create a constant value of type XXX. Only primitive types or enumeration types are supported in this context
  14. Change custom attribute’s parameter at runtime
  15. Entity vs Model vs View Model
  16. Using Simple Injector with Unit Of Work & Repository Pattern in Windows Form
  17. Getting Nested Object Property Value Using Reflection
  18. Place to put Database.SetInitializer
  19. Entity Framework: How to disable lazy loading for specific query?
  20. Finding the reason for DBUpdateException
  21. The entity type ApplicationUser is not part of the model for the current context
  22. GUID COMB strategy in EF
  23. entity framework update many to many relationship: virtual or not
  24. How to force LINQ Sum() to return 0 while source collection is empty
  25. How can I tell if a C# method is async/await via reflection?
  26. How to define Many-to-Many relationship through Fluent API Entity Framework?
  27. how to get both fields and properties in single call via reflection?
  28. How can I write a generic container class that implements a given interface in C#?
  29. Entity Framework: field of composite key cannot be nullable?
  30. Implementing recursive property loading in EF Core

Leave a Comment