Dynamic table name with entity framework

asp.net-mvc c# entity-framework sql-server

Question

I have many tables with the same model structure but with other table names with other data (in this case will be ~100 tables). I want to dynamically switch table name in runtime using Entity Framework (for example get name table from routing). Tables in database are dynamically adding and deleting by other script. There is a way to do this with good performance like this?

db.Table("TableName")<SpecificModel>.Where(x => x.ID == ID)
1
14
6/27/2015 3:16:22 AM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Popular Answer

Do you want to do like this?

foreach (string tableName in new[] { "Table1", "Table2" })
{
   var result = dbContext.Database.SqlQuery<SpecificModel>(string.Format("SELECT * FROM {0} WHERE ID=@p0", tableName), 1).FirstOrDefault();
}
6
6/27/2015 4:43:45 AM

Related Questions

Get the table name from the Entity Framework

I'm using the Entity Framework 4.1 with Code First approach. I'm able to get the storage model types and column names of my entities:...var items = context.ObjectContext.MetadataWorkspace.GetItems<EntityType>(DataSpace.SSpace); foreach (var i in items) { Console.WriteLine("Table Name: {0}", i.Name); Console.WriteLine("Keys:"); foreach...
c# ef-code-first entity entity-framework modelmetadata
asked by 0xbadf00d

Dynamic table names in Entity Framework linq

I'm using Entity Framework 6 with ASP.Net MVC 5. When using a database context object, is there a way to use a variable for the table name, without having to manually write the query?...For example:...var tableName = "NameOfTable"; result = context.tableName.Find(...); ...I know that particular code won't work, because tableName is not defined in ...
asp.net-mvc entity-framework-6 linq
asked by hiccup

Entity Framework .net: "The Name value should be a valid navigation property name."

Hello I'm starting a project with ASP.Net and I'm following the Training Camps of Microsoft. I was trying to make a REST petition to my published api, and I got the next exception:...The ForeignKeyAttribute on property 'QuestionId' on type 'PlataformaTest.Models.AnswerModel' is not valid. The navigation property 'OptionModel' was not found on t...
asp.net c# entity-framework foreign-keys
asked by Andres Felipe

Dynamic Linq + Entity Framework: datetime modifications for dynamic select

I am trying to find a way to move UTC time to Local before doing a sql grouping. I am using the System.Linq.Dynamic (managed here ...https://github.com/kahanu/System.Linq.Dynamic... ). It works great for doing dynamic selects without having at compile time the required fields. In our case, we store all datetimes in UTC. In this dynamic select, it...
.net c# dynamic-linq entity-framework-6
asked by TravisWhidden

Dynamic LINQ - Entity Framework 6 - Update Records for Dynamic Select

When you do a ...SELECT NEW ...... it selects only specific fields and won't track updates for you. I think if you change your query to be this it will work:...var query = db.tblRecords.Where(x=>x.id == id);
c# dynamic-linq entity-framework-6
asked by jhilden

How to recover from Entity Framework nightmare - database already has tables with the same name

How do you get EF back in Sync with code without losing data when Update-database returns the following message...Error Message: System.Data.SqlClient.SqlException (0x80131904): There is already an object named '' in the database.
database-migration ef-migrations entity-framework entity-framework-6
asked by System.Exception

Use a variable table name for Entity Framework SqlQuery to fetch data into entity Class

I want to convert string var to entity framework class but I don't now how. I have searched a lot but can not found anything...public JsonResult GetReports(string tbl) { using (Context db = new Context()) { // *** Problem is that tbl is string and I want to Cast tbl // to Users Class OR eny of my other Class v...
c# entity-framework-6 generics linq
asked by Pooria.Shariatzadeh

how can i get all properties and attribute display name of database table entity framework 6?

to get type use ...typeof(T)... or ..._t.GetType()... and then use method ...GetProperties()... on that
c# entity-framework entity-framework-6
asked by Sonikas

Entity Framework - LINQ - Dynamic Column Names

I know that this question was asked several times but the more answers I came accross the more I got confused....Given I have a table ...Categories... and within this table columns: ...Category1..., ...Category2..., ...Category3... and so on.. How can I write a method like below and use a parameter (in this case ...catno...) ...As simplified as I c...
c# entity-framework-6 lambda linq
asked by Subliminal Hash

Entity Framework migration from MySQL to SQL Server and the Table names missing "dbo"

I am maintaining an existing (and working) C# project which uses ...Entity Framewwork 6... to do the ORM. Now I need to migrate the database from ...MySQL... to ...SQL Server.... So far I have been able to make the program compile by modifying the ....edmx... file (For example, I changed the ...Provider... from ...MySql.Data.MySqlClient... to ...Sy...
c# entity-framework-6 sql-server
asked by tete

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