In my mapping for a table H when using
References(x => x.E).Column("E_Code").Nullable().NotFound.Ignore()
;
from one table (H) to another table (E), to give me a many to one relationship I get a query for each instance where the E_Code in the H table does not exist in the E table. How can I reduce the number of queries but still have E set to null if there is no match?