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%'