linq query error

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();

}

Re: linq query error

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 mindI think you cannot return a p=>p.PRM0but you should use an anoymous class name instead herejust 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();