List of Records

Question

Hi

I have below code . In GroupCollection value is Group 2A , Group 2A(i) . I want to list all those records from Database which have Group value Group 2A , Group 2A(i) . I am tryng like below but not working

public List<Group> GetMentorList(string Group)
        {
            List<Group> Result = (from t in context.Groups
                                             where t.IsActive == true
                                             && (Group.Contains(t.GroupID.ToString()) : 1 == 1)
                                             select t).ToList();
            return Result;
        }

Thanks

Rajkiran Swain · Answer

public List GetMentorList(string Group) { List Result = (from t in context.Groups where t.IsActive == true && Group.Contains(t.GroupID.ToString()) select t).ToList(); return Result; }

Vishal Joshi · Answer

Hello, You need to split the string and convert into list or array to check contains. Please try the below code. public List GetMentorList(string Group) { List Result = new List (); if (!string.IsNullOrEmpty(Group)) { var groups = Group.Split(","); groups.ToList().ForEach(a => { a.Trim(); }); Result = (from t in context.Groups where t.IsActive == true && groups.Contains(t.GroupID.Trim().ToString()) select t).ToList(); } return Result; } Thanks

Brahma Prakash Shukla · Answer

To retrieve records from the database based on a list of group values in C#, you can modify your code as follows: public List GetMentorList(List groups) { List result = context.Groups .Where(t => t.IsActive && groups.Contains(t.GroupID.ToString())) .ToList(); return result; } In the code above, the GetMentorList method takes a list of strings ( groups ) as a parameter, which represents the group values you want to search for. The LINQ query uses the Where clause to filter the records based on the following conditions: t.IsActive : Ensures that only active records are considered. groups.Contains(t.GroupID.ToString()) : Checks if the GroupID converted to a string exists in the groups list. Finally, the query is executed by calling .ToList() to retrieve the filtered records as a list of Group objects. Make sure to pass a valid list of group values to the GetMentorList method when calling it.

Tuhin Paul · Answer

public List GetMentorList(string groupId) { List result = context.Groups .Where(t => t.IsActive && groupId.Contains(t.GroupID.ToString())) .ToList(); return result; } I have made the following changes : Renamed the Group parameter to groupId to better reflect its purpose. Changed the query syntax to lambda expression syntax for improved readability. Updated the variable naming conventions to use camel case (result instead of Result).