Hi guys,
I'm a newbie of Fluent NHibernate, so be patience, please :-)
I've 2 tabs
COMPANY
company_id <-----
contract_name
COMPANY DATA CHANGES
company_datachange_id
company_id <-----
corporate_name
start_date
end_date
deleted
Company has a foreign key company_id ti COMPANY DATA CHANGES.
I need to build CompanyMapping that has this references and conditions
with COMPANY DATA CHANGES:
company_id,
CURRENT_DATE BETWEEN tab_company_data_changes.starting_date AND
COALESCE(tab_company_data_changes.ending_date, CURRENT_DATE),
deleted = false
This is my mapping:
public TCompanyMapping()
{
Table("tab_companies");
Id(x => x.Id, "company_id");
ContractName(x => x.ContractName, "contract_name");
References(x => x.CompanyDataChanges)
.Not.Nullable()
.Column("company_id");
}
Is there someone who wants to help me?
--
You received this message because you are subscribed to the Google Groups
"Fluent NHibernate" group.
To post to this group, send email to fluent-nhibern...@googlegroups.com.
To unsubscribe from this group, send email to
fluent-nhibernate+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/fluent-nhibernate?hl=en.
