I posed this question a few days ago but I didn't see it show up, so
if this is a double post I appologize. I recently started using Linq
to NHibernate and was wondering if anybody knows how to force an inner
join. I'm able to do this easily with the typical criteria objects. I
put a quick example below to show querying a user by their username/
password, but I'm also eagerly loading the company.
ICriteria query = _unitOfWork.CreateCriteria<User>();
query.CreateAlias("Company", "comp",
NHibernate.SqlCommand.JoinType.InnerJoin);
query.Add(Expression.Eq("UserName",userName));
query.Add(Expression.Eq("Password", password));
query.SetFetchMode("Company", FetchMode.Join);
return query.UniqueResult<User>();
I can "eagerly" load the company by using the "Expand" method with the
linq extensions for NHibernate, but it always joins with a "left outer
join".
INhibernateQueryable<User> query = _unitOfWork.Linq<User>();
query.Expand("Company");
return query.FirstOrDefault(user => user.UserName == userName &&
user.Password == password);
Any help would be appreciated.
Thanks,
Dan
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
