I want to select a row from a Database using LINQ to Entities in Entity Framework in C#.
My arguements to method are :
I want to select the row from table "TableName" dynamically based on these three parameters where "fieldName" matches a certain value.
You don't need entity framework to do something like this, you can use helper methods provided into dbContext to execute your custom query:
public List<T> ListElements(string tableName, string columnName) {
var db = new DbContext();
var query = string.Format("SELECT {0} FROM {1}", tableName, columnName);
var data = db.Database.SqlQuery<T>(query);
return data;
}
You can use this method to list items into table with specific type. Suppose you want to display all ids of a table named "Users" you can write this code:
var userIds = ListElements<int>("Users", "Id");
