Dynamic table name in linq [duplicate]

by

In your DbContext class, add a method say called Set that returns:

public DbSet Set(string name)
{
  // you may need to fill in the namespace of your context
  return base.Set(Type.GetType(name));
}

Which you can query like this:

using (var db = new YourDataContext())
{
  // Since your DbSet isn't generic, you can can't use this:
  // db.Set("Namespace.EntityName").AsQueryable().Where(a=> a.HasSomeValue...
  // Your queries should also be string based.
  // Use the System.Linq.Dynamic nuget package/namespace
  var results = db.Set("Namespace.EntityName")
    .AsQueryable()
    .Where("SomeProperty > @1 and SomeThing < @2", aValue, anotherValue);
  // you can now iterate over the results collection of objects
}

More information on System.Linq.Dynamic can be found here

More Related Contents:

  1. Linq: help me to make this work
  2. Bulk-deleting in LINQ to Entities
  3. Writing Recursive CTE using Entity Framework Fluent syntax or Inline syntax
  4. The type of one of the expressions in the join clause is incorrect in Entity Framework
  5. Entity framework left join
  6. LEFT JOIN in LINQ to entities?
  7. Linq to EntityFramework DateTime
  8. LINQ to SQL multiple tables left outer join
  9. Entity Framework (.NET Full Framework) Ordering Includes [duplicate]
  10. How to compare only date components from DateTime in EF?
  11. How to Bulk Update records in Entity Framework?
  12. Entity Framework 6 Code First Custom Functions
  13. Entity Framework. Delete all rows in table
  14. “The LINQ expression node type ‘Invoke’ is not supported in LINQ to Entities” – stumped!
  15. LINQ to Entities does not recognize the method ‘System.Web.Mvc.FileResult’
  16. Order by dynamic parameter
  17. LINQ, Unable to create a constant value of type XXX. Only primitive types or enumeration types are supported in this context
  18. Linq to Entity Join table with multiple OR conditions
  19. Export Model to DataTable
  20. ‘Date’ is not supported in LINQ to Entities. Only initializers, entity members, and entity navigation properties are supported
  21. Simulating Cross Context Joins–LINQ/C#
  22. Max return value if empty query
  23. Check if list contains item from other list in EntityFramework
  24. How to do an “in” query in entity framework?
  25. Keep Getting ‘The LINQ expression node type ‘Invoke’ is not supported in LINQ to Entities’ Exception
  26. Linq Query keeps throwing “Unable to create a constant value of type System.Object….”, Why?
  27. How to include() nested child entity in linq
  28. Entity framework – get entity by name
  29. LINQ Query to Convert string to datetime
  30. Entity Framework select one of each group by date

Leave a Comment