Linq get rows by enum values

Question

Here is my enum values defined

public enum authaccess
{ read=0,create=1,update=2,delete=4}

As a Access Table looks like as below.

|id  | tablename |columnname|permitted|
|----|-----------|----------|---------|
|1   | cms       |header    |3        |
|2   | cms       |footer    |2        |
|3   | cms       |content   |7        |

read access is permitted for all content, while 3 is for(create + update), and 7 for all rights.

As I need (x) button enabled in div where loggedInUser has delete authority

Using Linq, I used

new DbContext().tbl_access.where(k=>k.permitted > authaccess.delete){divid.class.add('close')}

but could not find a way to get a list of contents that can be changed by user ie 3 or (authaccess.create + authaccess.update)

[Clarification on edit] The resultant table should be

|id  | tablename |columnname|permitted|
|----|-----------|----------|---------|
|1   | cms       |header    |3        |
|2   | cms       |footer    |2        |

Because (header and footer) include create+update level access which is less than or equal to 3.

Thanks in advance for any help.

Which type of LINQ is this? And if it's LINQ to Entities (Entity Framework), is the enum also mapped as enum? And is is a flagged enum? — Gert Arnold
– Gert Arnold, Commented Dec 17, 2017 at 9:19

Alexei - check Codidact · Accepted Answer · 2017-12-17 08:47:27Z

1

It looks like your authaccess has values for bit masking. For your requested create + update, a possible way to write your Linq is:

new DbContext().tbl_access
    .Where(k => (k.permitted & (int)authaccess.create) > 0) && 
                (k.permitted & (int)authaccess.update) > 0))

answered Dec 17, 2017 at 8:47

Alexei - check Codidact

23.2k22 gold badges159 silver badges179 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Marks Over a year ago

Thanks, I like it this way

Emre Kabaoglu · Accepted Answer · 2017-12-17 08:54:41Z

0

Do you want something like that;

var authAccessFilter = (int)authaccess.create + (int)authaccess.update;
var records = new DbContext().tbl_access.Where(k => k.permitted <= authAccessFilter).ToList();

edited Dec 17, 2017 at 8:54

answered Dec 17, 2017 at 8:32

Emre Kabaoglu

13.2k4 gold badges27 silver badges48 bronze badges

2 Comments

Marks Over a year ago

sorry, the problem was not clearly understood. I have added few lines below to clarify the requirement.

Marks Over a year ago

<= is not recommended, when later values on enum do not override the previous roles.

Collectives™ on Stack Overflow

Linq get rows by enum values

2 Answers 2

1 Comment

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related