Querying data using Entity Framework from dynamically created table

by

It is not directly possible. When you map entity to ResultTableTemplate you hardcode the name of the table for this entity. Entities can be mapped only once (per model) so at runtime every EF query for this entity always results in query to ResultTableTemplate table.

The only way to change is behavior is modifying mapping file (SSDL) at runtime which is quite ugly hack because it requires you to change XML file and reload it. You will have to build MetadataWorkspace manually every time you change the file. Building MetadataWorkspace is one of the most performance consuming operation in EF. In the normal run MetadataWorkspace is created only once per application run.

There is simple workaround. You know the table name and you know the table structure – it is fixed. So use direct SQL and use EF to materialize the result into your mapped entity class:

var table = context.ExecuteStoreQuery<ResultTableTemplate>("SELECT ... FROM " + tableName);

The disadvantage is that you cannot use Linq in this approach but your requirement is not very well suited for EF.

More Related Contents:

  1. Fastest Way of Inserting in Entity Framework
  2. Entering keys manually with Entity Framework
  3. How can I log the generated SQL from DbContext.SaveChanges() in my Program? [duplicate]
  4. Validation failed for one or more entities while saving changes to SQL Server Database using Entity Framework
  5. LINQ to SQL multiple tables left outer join
  6. Entity Framework error: Cannot insert explicit value for identity column in table
  7. Entity Framework. Delete all rows in table
  8. Entity Framework – stored procedure return value
  9. EF 6 Parameter Sniffing
  10. Retrieve an object from entityframework without ONE field
  11. Join and Include in Entity Framework
  12. Anonymous type result from sql query execution entity framework
  13. Calling a SQL User-defined function in a LINQ query
  14. Stored procedure returns int instead of result set
  15. How to use String property as primary key in Entity Framework
  16. summing values of a column based on id [closed]
  17. How can I add user-supplied input to an SQL statement?
  18. How to get last inserted id?
  19. Why does the EF 6 tutorial use asynchronous calls?
  20. Implementing Zero Or One to Zero Or One relationship in EF Code first by Fluent API
  21. One to one optional relationship using Entity Framework Fluent API
  22. Implementing Audit Log / Change History with MVC & Entity Framework
  23. Entity Framework – Cannot convert lambda expression to type ‘string’ because it is not a delegate type
  24. Internal .NET Framework Data Provider error 1025
  25. get date part only from datetime value using entity framework
  26. ASP.NET ODBC Query with parameters
  27. ASP.NET Identity – Multiple object sets per type are not supported
  28. Entity Framework Code Only error: the model backing the context has changed since the database was created
  29. How to force LINQ Sum() to return 0 while source collection is empty
  30. phone number should be a string or some numeric type that have capacity to save phone number?

Leave a Comment