Hello,
I have a table with this definition:
[localizations]
+ id
+ resourceKey
+ resourceValue
+ cultureName
My class is as follows
public class Localization{
public int Id { get; set; }
public string ResourceKey { get; set; }
public string ResourceValue { get; set; }
public string ResourceSet { get; set; }
public string CultureName { get; set; }
public string DefaultResourceValue{ get; set; }
}
Please note the DefaultResourceValue property which is not related to
any field in the database.
What I want is to execute this query (SQL as is)
select a.resourceKey, a.cultureName, a.resourceSet, a.resourceValue
as
defaultText, b.resourceValue
from localizations a join localizations b on a.id = b.id
where a.resourceSet='blacklist/edit' and (a.cultureName='' or
a.cultureName='en')
I want to know how can I write that sql statement in:
a) HQL
b) using Criteria
Hope you can help me.. regards
p.s sorry for cross-posting this
--
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.
