Bug in SubSonic.Comparison.In

Question

With the following code:

 IEnumerable<int> LocalityIds = new List<int>();

        PersonCollection pc = 
            new PersonCollection().
                Where(Person.Columns.AddressLocalityId, SubSonic.Comparison.In, LocalityIds).
                Load();

Although the initial collection is empty Subsonic still returns all records?!?!?!?!? Is this a bug or am i doing something wrong?

Thanks

Answer 1

I don't think we've setup collections to do this even though the Comparison is there. Have you tried Select().From().Where(..).In(LocalityIds).ExecuteAsCollection();

Answer 2

Just checked V2.2 and this still happens, when I have a bit of time I will try to submit a patch