LINQ to Entities does not recognize the method Int32 get_Item(Int32)
I am a newbie about entity framework and linq. My query is like that
var query = (from d in db.MYTABLE
where d.RELID.Equals(myInts[0])
select d.ID).Distinct();
List<int?> urunidleri = query.ToList();
When i execute 开发者_JS百科this code, i got the error message "LINQ to Entities does not recognize the method Int32 get_Item(Int32)". How can i solve my problem ?
Thanks...
You need to store your int
in a variable, so that EntityFramework isn't trying to pull the whole array into its scope.
var myInt = myInts[0];
var query = (from d in db.MYTABLE
where d.RELID.Equals(myInt)
select d.ID).Distinct();
List<int?> urunidleri = query.ToList();
var firstInt = myInts[0];
var query = (from d in db.MYTABLE
where d.RELID.Equals(firstInt)
select d.ID).Distinct();
List<int?> urunidleri = query.ToList();
The Linq query is ultimately transformed into an SQL query and LINQ doesn't know what to do with Session["UserName"]
(that gets the "UserName" item).
A common way to workaround this is just to use a local variable to which you'll assign Session["UserName"]
and that you'll use in your Linq query...
like
string loggedUserName = Session["LogedUsername"].ToString();
var userdetail = dc.faculties.Where(a => a.F_UserName.Equals(loggedUserName)).FirstOrDefault();
reference http://mvc4asp.blogspot.in/
精彩评论