Hi there,
I am writing the follow as an NHibernate Query but cannot find a solution
using QueryOver: -
IQuery query = SessionFactoryContext.
GetCurrentSession().CreateSQLQuery("SELECT
s.UserID,Username,Email,Password,FirstName,LastName,Address1,Address2,City,County,PostalCode,Country
FROM [dbl].[dbo].[User] s LEFT OUTER JOIN [dbl].[dbo].[groupmembership] g
ON s.UserrID = g.UserrID WHERE g.UserID IS NULL OR (g.GroupID NOT IN (" +
groupID + ") )")
.SetResultTransformer(Transformers.AliasToBean(typeof(User)));
return (IList<Subscriber>)query.List<User>();
Is there any way possible that this can be written as an NHibernate query?
Many thanks for your help,
--
You received this message because you are subscribed to the Google Groups
"nhusers" group.
To view this discussion on the web visit
https://groups.google.com/d/msg/nhusers/-/yGnA0W_SJWAJ.
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.
