Check if data returned from sql table contains decimal list values in linq?

Question

I want to return only those data from sql table which contains specific values from list.How can i do that ?

  List<decimal> userHeirarchyId = new List<decimal>();
  List<decimal> userGroupId = new List<decimal>();

 //Get groups based on user      
 string userGroupIds = (from ucp in db.UserControlPrivileges
                        where ucp.UserId == (decimal)AMSECSessionData.userId
                        select ucp.GroupIds).FirstOrDefault().ToString();
 userGroupId = userGroupIds.Split(',').Select(x => decimal.Parse(x)).ToList();

 //Get heirarchy based on company and usergroup
 userHeirarchyId = db.Groups
                   .Where(x=>x.Hierarchy.CompanyId==(decimal)AMSECSessionData.companyId  
  =>stuck here      && x.GroupId.contains(userGroupIds ))

Any help will be appreciated..

Dennis R · Accepted Answer · 2014-06-13 06:15:23Z

1

Try this. Change the order how you're using Contains like 'your compare list'.Contains(member name)

var userHeirarchyId = db.Groups
                   .Where(x=> x.Hierarchy.CompanyId == (decimal)AMSECSessionData.companyId  
                   && userGroupIds.Contains(x.GroupId))

answered Jun 13, 2014 at 6:15

Dennis R

3,2471 gold badge21 silver badges24 bronze badges

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

Comments

Mukesh Modhvadiya · Accepted Answer · 2014-06-13 07:40:44Z

0

Write it like this :

var user = db.UserControlPrivileges.FirstOrDefault(u => 
                         u.UserId == (decimal)AMSECSessionData.userId);
if(user == null || user.GroupIds == null)
{
    return;
}
var userIds = user.GroupIds.Split(',').Select(x => decimal.Parse(x)).ToList();

And then :

var userHeirarchyId = db.Groups
                      .Where(x => x.Hierarchy.CompanyId==(decimal)AMSECSessionData.companyId  
                      && userIds.Contains(x => x.GroupId));

edited Jun 13, 2014 at 7:40

answered Jun 13, 2014 at 6:39

Mukesh Modhvadiya

2,1982 gold badges28 silver badges32 bronze badges

2 Comments

NeddySpaghetti Over a year ago

what if db.UserControlPrivileges.FirstOrDefault(u => u.UserId == (decimal)AMSECSessionData.userId) returns null?

Mukesh Modhvadiya Over a year ago

@NedStoyanov, thanks for your input, but that is common practice, so i didn't feel it necessary to write null check and all that. Just showing the logic. but I am updating it then.

Collectives™ on Stack Overflow

Check if data returned from sql table contains decimal list values in linq?

2 Answers 2

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related