Nhibernate Criterion - select rows in table A of TypeId defined in Table B

This is my plan b, if all else fails, I'll do this.

Thanks

It really depends on your entities. I have mocked up a sample entity, just adopt it to yours.

public class Bike
{
    public int BikeId;
    public IList<BikeOwners> BikeOwners;
    public string BikeName;
}

public class Owners
{
    public int OwnerId;
    public IList<BikeOwners> OwnersBikes;
    public string OwnerName;
}

public class BikeOwners
{
    public int Id;
    public Owners owner;
    public Bikes bike;
}

Now, you are going to write your nhibernate criteria like this:

DetachedCriteria crit = DetachedCriteria.For<Bikes>()
    .CreateCriteria("BikeOwners") //from Bikes class
    .CreateCriteria("owner")   // from BikeOwners class
    .Add(Expression.Eq("OwnerId", _OwnerId)); //from Owners class

obviously, you need to modify it to your entities and names.

Unless there's more column in the BikeOwners table, it shouldn't be represented in the domain model at all. Bike and Owner should be mapped as a many-to-many relationship. Also, I find it unusual that a Bike can have multiple Owners.