Linq match string list and string value

Question

I used below code

 string userList = string.Join(",", db.UserRole.Where(p => p.FirmUserID == 1).Select(p => p.RoleID.ToString()));

userList values below,

1,12,17,33,76

I have also below string list

List<string> roleList = new List<string>();
roleList.add("14");
rolelist.add("33");
roleList.add("76");

How can i check userList includes roleList value and get matches value in entity framework ?

Is there any reason why you're keeping the user list as a single string rather than as a list? And any reason why you're using strings for values which look like they're all numbers? — Jon Skeet
– Jon Skeet, Commented Feb 24, 2015 at 14:49
not really if you can suggest matcihng for list i can apply on my side thanks for help and realize — Beyto
– Beyto, Commented Feb 24, 2015 at 14:49

user3021830 · Accepted Answer · 2015-02-24 14:52:10Z

2

First of all instead of converting your userList to string keep it as a List

List<string> userList = db.UserRole.Where(p => p.FirmUserID == 1).Select(p => p.RoleID.ToString()).Tolist();

To check if userList includes roleList

bool doesInclude = !roleList .Except(userList).Any();

to get the matches:

List<string> matches = userList.Intersect(roleList).ToList();

But if this is what you need to accomplish you'd better work sith integer types instead of string, because string comparison is more error prone (by the user).

answered Feb 24, 2015 at 14:52

user3021830

2,9443 gold badges26 silver badges48 bronze badges

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

Collectives™ on Stack Overflow

Linq match string list and string value

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related