How to write framework linq query in View Model

Question

Hi.I am new to Wpf and Linq i need to write linq query in view model. sql query is: Select Value from SystemConstants above statement i want to write using linq with out using id please provide answer

kavya bathineni · Answer

I am using var result = (from t in S ystemConstants select t.value).ToList(); 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

Pradeep Shet · Answer

Hey kavya with linq to sql var result = (from t in S ystemConstants select t.value).ToList(); with lambda var result = S ystemConstants.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

Amresh S · Answer

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.

kavya bathineni · Answer

i am fetching only one filed.example select name from student. i want write in Entity framework Linq

Suvendu Shekhar Giri · Answer

with out using id What exactly that means?