Convert this Linq query from query syntax to lambda expression

Posted by Jinkinz on Stack Overflow See other posts from Stack Overflow or by Jinkinz
Published on 2010-05-21T02:21:21Z Indexed on 2010/05/21 2:30 UTC
Read the original article Hit count: 377

Filed under:

linq-query-syntax

|

lambda-expressions

|

LINQ

I'm not sure I like linq query syntax...its just not my preference. But I don't know what this query would look like using lambda expressions, can someone help?

from securityRoles in user.SecurityRoles
from permissions in securityRoles.Permissions
where permissions.SecurableEntity.Name == "Unit" && permissions.PermissionType.Name == "Read"
orderby permissions.PermissionLevel.Value descending
select permissions

There is a many-to-many relationship between users and security roles that makes this extra confusing.

Thanks! Kelly

© Stack Overflow or respective owner

Related posts about linq-query-syntax

An abundance of LINQ queries and expressions using both the query and method syntax.

as seen on ASP.net Weblogs - Search for 'ASP.net Weblogs'
In this post I will be writing LINQ queries against an array of strings, an array of integers.Moreover I will be using LINQ to query an SQL Server database. I can use LINQ against arrays since the array of strings/integers implement the IENumerable interface. I thought it would be a good idea to use… >>> More
Convert this Linq query from query syntax to lambda expression

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm not sure I like linq query syntax...its just not my preference. But I don't know what this query would look like using lambda expressions, can someone help? from securityRoles in user.SecurityRoles from permissions in securityRoles.Permissions where permissions.SecurableEntity.Name == "Unit"… >>> More
"Enumeration yielded no results" When using Query Syntax in C#

as seen on Stack Overflow - Search for 'Stack Overflow'
I have created this query to fetch some result from database. Here is my table structure. What exaclty is happening. DtMapGuestDepartment as Table 1 DtDepartment as Table 2 Are being used var dept_list= from map in DtMapGuestDepartment.AsEnumerable() where… >>> More
Why I am getting Null from this statement. Query Syntax in C#

as seen on Stack Overflow - Search for 'Stack Overflow'
This is not working. Returns Null to dept_list. var dept_list = ((from map in DtMapGuestDepartment.AsEnumerable() where map.Field<Nullable<long>>("Guest_Id") == 174 select map.Field<Nullable<long>>("Department_id"))… >>> More
LINQ query - null date

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi Ive a simple linq query to return records with a null date field, just want to check the synatx of the "where" line is ok var query2 = from cs in db.tblCases where cs.date_closed == null etc, etc, thanks again DD >>> More

Related posts about lambda-expressions

Building Lambda Expressions from Expression Trees

as seen on Internet.com - Search for 'Internet.com'
Learn how to dynamically build and explore Lambda expressions from expression trees. >>> More
Using C++0x Lambda Expressions in Microsoft Visual Studio

as seen on Internet.com - Search for 'Internet.com'
In this C++ tutorial, learn how to utilize Lambda expressions in your C++ Applications. >>> More
Lambda expressions in C#?

as seen on Super User - Search for 'Super User'
Hey I'm rather new to these could someone explain the significance or prehaps give a link to some useful information on lambda expressions? I encounter the following code in a test and I am wondering why someone would do this: foo.MyEvent += (o, e) = { fCount++; Console.WriteLine(fCount); }; foo… >>> More
lambda expressions in C#?

as seen on Stack Overflow - Search for 'Stack Overflow'
Hey I'm rather new to these could someone explain the significance (of the following code) or prehaps give a link to some useful information on lambda expressions? I encounter the following code in a test and I am wondering why someone would do this: foo.MyEvent += (o, e) => { fCount++; Console… >>> More
Using Lambda Expressions trees with IEnumerable

as seen on Stack Overflow - Search for 'Stack Overflow'
I've been trying to learn more about using Lamba expression trees and so I created a simple example. Here is the code, this works in LINQPad if pasted in as a C# program. void Main() { IEnumerable<User> list = GetUsers().Where(NameContains("a")); list.Dump("Users"); } // Methods public… >>> More