Subsonic 3 - Does is it support querying using the IEnumerable.Contains?

Question

This fails with an error with the method "Contains" is not supported.

List<int> usedID= new List<int> { 1, 2, 3 };
var f = WebPageContent.Find(x => !usedID.Contains(x.PageID));

Seems odd so what's the alternative approach?

This doesn't work either:

var dd = from i in WebPageContent.All() 
         where !usedID.Contains(i.PageID) 
         select i;

This does but is it the recommended approach:

var table = new WebPageContentTable(_db.DataProvider);
var g = new SubSonic.Query.Select()
            .From(table)
            .Where(table.ID)
            .In(usedID)
            .Execute();

Answer 1

Not knowing anything about Subsonic/Subsonic 3 I suggest that you use the Any (or Contains) extension method and see if it's supported.

List<int> usedID= new List<int> { 1, 2, 3 };
var f = WebPageContent.Find(x => !usedID.Any( e => e == x.PageID));