linq query error RSS

• • Reply
  

  anatolium

  Member

  6 Points

  12 Posts

  linq query error

  Feb 16, 2012 06:18 PM|LINK

  hello I get this error,can you help me ?

  
  

   public void GetInfo(Guid instance)
          {
              HarmonyEntities harmonyEntities = Database.GetEntities;
  
  
              GridType type = new GridType();
              List<GridType> typeList = new List<GridType>();
  
  
              var getInfo = from p in harmonyEntities.VDB_ASSET_INFORMATIONS
                            where p.GUID_ASSET.Equals(instance) && p.PRM1 == 1
                            select p;
  
  
  
  //

  I see this here error :

  Can only specify query options (orderby, where, take, skip) after last navigation.

  
              var dat = getInfo.Where(p => p.GUID_TYPE.Equals(GridTypeFields.SequenceNumber) && p.PRM1.Equals(1)).Select(p => p.PRM0).Single().ToString();
  
          }

• • Reply
  

  Decker Dong ...

  All-Star

  118619 Points

  18779 Posts

  Re: linq query error

  Feb 18, 2012 05:29 AM|LINK

  anatolium

  var dat = getInfo.Where(p => p.GUID_TYPE.Equals(GridTypeFields.SequenceNumber) && p.PRM1.Equals(1)).Select(p => p.PRM0).Single().ToString();

  Hello：）

  In my mind，I think you cannot return a p=>p.PRM0，but you should use an anoymous class name instead here，just see this：

  var dat = getInfo.Where(p => p.GUID_TYPE.Equals(GridTypeFields.SequenceNumber) && p.PRM1.Equals(1))

                          .Select(p =>new {StringHere=p.PRM0}).Single().StringHere.ToString();

  • Marked as answer by decker dong - msft on Feb 22, 2012 01:30 AM