anybody knows the answer for such scenario?
On Mon, Jun 6, 2011 at 2:27 PM, Shadi Mari <[email protected]> wrote:
> 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.
