CODEWITHSUNDEEP
c#linqgenerics
ankur
ankur

Reputation: 4733

Pass int array in where clause of LINQ Query

There is a class 

Public class Student
{
  int id;
  int rollNum;
  String Name;
}

a method 

Public List<Student> GetAllStudents()
{
  var studentList = GetMeAll(); // Simple select * query to get all students
  //unfortunately i can't make changes in this method so have to write a linq query to       //filter data.
  //getting int array ids correctly from some method
   var filterList = FilterStudentsByID(ids,StudentList);
}

I want to write a method that takes an int array as input and returns a List

Public List<Student> FilterStudentsByID(int[] ids,List<student> studentList)
{
  //There should be a linq query , but I am new to linq so don't know how to write this.
  Var list = from  studentList in ..... don't know much;
}

Any help in writing the query. Thank you all for Answers, I am also looking for maintain the performances with large list of records ?? It will be great if you can add me simple explanation of the query will work internally ??

Upvotes: 8

Views: 15258

Answers (3)

Matthew Watson
Matthew Watson

Reputation: 109567

I think the answers already given will be fast enough, but just in case after testing you find that it's too slow: You can try converting the student list to a dictionary before doing the searching.

You should only use this after careful timing tests, since it is likely to be a lot slower for most cases!

public static List<Student> FilteredStudents(int[] targetIds)
{
    var allStudents = GetAllStudents().ToDictionary(student => student.id);
    var result = new List<Student>();

    foreach (int id in targetIds)
    {
        Student student;

        if (allStudents.TryGetValue(id, out student))
        {
            result.Add(student);
        }
    }

    return result;
}

Upvotes: 1

Damith
Damith

Reputation: 63065

try

Var list = studentList.Where(s=>ids.Contains(s.id)).ToList();

Upvotes: 5

Habib
Habib

Reputation: 223237

If you are looking to find those students from the list whose id's are present in the ids array then: 

var list = from s in stundentList
           where ids.Contains(s.ID)
           select s;

Upvotes: 12

Related Questions