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?

How to write framework linq query in View Model

Answers (5)