How to write framework linq query in View Model

I am using 

 

 

i got error like this

 

Severity Code Description Project File Line Suppression State

Error CS1061 'SystemConstant' does not contain a definition for 'value' and no extension method 'value' accepting a first argument of type 'SystemConstant' could be found (are you missing a using directive or an assembly reference?) LWLLC.BusinessLogic E:\11-21-2016LWLLC\LWLLC-Code-DB-11212016\LWLLC\LWLLC.BusinessLogic\ControlFile.cs 24 Active

Hey kavya,

 

with linq to sql,

 

var result = (from t in SystemConstants

                   select t.value).ToList();

 

with lambda,

var result =  SystemConstants.Select(d=>d.Value).ToList();

 

I hope this is what you wanted. Plz mark it as answered if this solves your query, or you can ping me, 

Hi @kavya,

 

Please check this blog.

http://www.entityframeworktutorial.net/Querying-with-EDM.aspx

and this too.

https://msdn.microsoft.com/en-us/library/bb896342(v=vs.110).aspx

 

HTH.

 

Regards,

Amresh S. 

"with out using id"

What exactly that means?