Click here to Skip to main content
15,885,278 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
CSS
I am new to NHibernate. Is it possible to create a criteria for the below scenario
public class A{
public string name {get; set;}
}
public class B {
    public string name {get; set;}
}
public class C {
    public string firstname {get; set;}
    public string lastname {get; set;}
}
eventually I want to build the below query
SELECT a.*, b.*, c.* FROM A AS a
INNER JOIN B as b ON a.id = b.Id
INNER JOIN C AS c ON b.id = c.Id
WHERE o.lastname like '%ted%'
OR c.firstname like '%test%'
OR b.name like '%test%'
OR a.name like '%test%'
Posted

1 solution

Why don't you just consult the Hibernate/NHibernate documentation?[^]
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900