List of Records

Ramco Ramco

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

Thanks

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Rajkiran Swain3y ago

Accepted 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;
}

Brahma Prakash Shukla3y ago
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:
1. t.IsActive: Ensures that only active records are considered.
2. 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 Paul3y ago
```
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 :
1. Renamed the Group parameter to groupId to better reflect its purpose.
2. Changed the query syntax to lambda expression syntax for improved readability.
3. Updated the variable naming conventions to use camel case (result instead of Result).

Vishal Joshi3y ago

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