why EF cant translate Int32.Pars(...? RSS

• • Reply
  

  Sirwan Afifi

  Member

  33 Points

  30 Posts

  why EF cant translate Int32.Pars(...?

  Aug 20, 2012 08:40 AM|LINK

  hi friend,

  why EF cant translate Int32.Parse in Where Condition section?

  for example below code has error :

  var query = (from list in dbContext.Packages
                               where list.Id == Int32.Parse(Request["Id"].ToString())
                               select list).FirstOrDefault();

  i solved this problem :

   Int32 ID = Int32.Parse(Request["Id"].ToString());
   var query = (from list in dbContext.Packages
                               where list.Id == ID
                               select list).FirstOrDefault();

  
  
  
  

• • Reply
  

  DarrellNorto...

  All-Star

  86773 Points

  9643 Posts

  Moderator

  MVP

  Re: why EF cant translate Int32.Pars(...?

  Aug 20, 2012 09:18 AM|LINK

  Because Entity Framework has to translate and execute the entire expression in SQL.  There is no SQL equivalent to Int32.Parse().

  Here is the full list of canonical functions supported by Entity Framework:

  http://msdn.microsoft.com/en-us/library/bb738626.aspx

  Darrell Norton, MVP
  Darrell Norton's Blog
  Please click "Mark as Answer" if this helped you.
  • Marked as answer by Sirwan Afifi on Aug 20, 2012 11:16 AM