I have a many-to-many relationship for two tables (A,B).

I've written an ICriteria query to return a list of all the B's that link to a single A id thus:

ICriteria criteria = session.CreateCriteria(typeof(B));
criteria.CreateCriteria("LinkedAs").Add(Expression.Eq("ID", aId));

I need to do the inverse and return a list of all the B's that *don't* link to A but I'm struggling to get the right criteria.

At first I tried this:

criteria.CreateCriteria("LinkedAs").Add(Expression.Not(Expression.Eq("ID", aId)));

but this didn't work.

I'd be really grateful for some help as this problem is now giving me a major headache!

Thanks[/list]

In the absence of any replies I have implemented the following function:

public List<T> GetByFk<fkT, fkIdT>(fkIdT id, string propertyName, bool inverse)
{
ICriteria criteria = session.CreateCriteria(persitentType);
criteria.CreateCriteria(propertyName).Add(Expression.Eq("ID", id));
List<T> list = ConvertToGenericList(criteria.List());
if (inverse)
{
List<T> all = GetAll();
foreach(T obj in list)
{
all.Remove(all.Find(delegate(T t)
{
return t.Equals(obj);
}));
}
list = all;
return list;
}

Please help me find a better way without needing an expensive loop!