I have two lists as follows
var query1 = from enrollments in db.Enrollments
where enrollments.studentID == studentID && enrollments.result >= 50 && enrollments.enrolled == false
select enrollments.subjectID;
var query2 = from prerequisites in db.Prerequisites
where prerequisites.subjectID == subjectID
select prerequisites.prerequisiteID;
Now I want to make sure that all the numbers in query2 exist in query1. In other words, I want to ensure that query2 is a part of query1
Any ideas?
P.S
-You can be sure that subjectID
and prerequisiteID
are the same thing
-I can convert query1 and query2 to lists like that query.ToList()
bool results = query2.All(i=>query1.Contains(i));
related questions below :
Determine if a sequence contains all elements of another sequence using Linq
Check whether an array is a subset of another
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With