Hi all.. by passing single column name binding records but i want to get records by passing multiple column names dynamically using entity framework. please provide soultion regarding this I have tried like this... public List GetRecords(List Columns,string tablename) { using (var Context = new MCPEntities()) { string columnnames = string.Join(",", Columns); string Query = "SELECT " + columnnames + " FROM " + tablename + " "; var Records = Context.Database.SqlQuery (Query).ToList(); return Records.ToList(); } }

Try var res = dbContext . Database . SqlQuery TestEntity >( "Select * from dbo.MyView" ). ToList ();

Yes.. var Records = Context . Database . SqlQuery IEnumerable >( "SELECT * FROM tablename" ); if i use this means getting this error The result type 'System.Collections.Generic.IEnumerable`1[System.String]' may not be abstract and must include a default constructor

did you tried this???? var Records = Context . Database . SqlQuery IEnumerable >( "SELECT * FROM tablename" );

getting this error "The data reader has more than one field. Multiple fields are not valid for EDM primitive or enumeration types."

I don't see any problem here. Any run time error?

Answers

How to get records by passing multiple column names in MVC5

Seshu B

461

Hi all..

by passing single column name binding records but i want to get records by passing multiple column names dynamically using entity framework.

please provide soultion regarding this

I have tried like this...

public List<string> GetRecords(List<string> Columns,string tablename)
{
using (var Context = new MCPEntities())
{
string columnnames = string.Join(",", Columns);
string Query = "SELECT " + columnnames + " FROM " + tablename + " ";
var Records = Context.Database.SqlQuery<string>(Query).ToList();
return Records.ToList();
}
}