Hello,
I have the following domain definitions:
class Lookup<T>
{
int Id;
public string Name { get { return based on culture; }}
private string Name_en;
private string Name_fr;
}
class Country : Lookup<Country>
{
}
class Employee
{
int Id;
float Salray;
Country Country;
}
I also have a db table for Employees(Id, Salary, CountryId) and another
table from Countries (Id, Name_en, Name_fr).
I would like to benefit from NH 2nd level cache for Lookups (i.e.
Countries), yet am not sure how NH behaves when executing the following HQL
query "from Employee e where e.Salary > 100".
Does NH in this case checks the 2nd level cache to find Countries with
associated Ids or it does produces a SQL query which joins the Employees db
table with Countries db table every time the HQL query is executed, if not
then what value 2nd level cache adds in this case.
Thanks
--
You received this message because you are subscribed to the Google Groups
"nhusers" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/nhusers?hl=en.
