Hi,
For a project I'm working on I want to do some DLM stuff with NHibernate, I
know not the best option. But anyway I'm stuck on complex where statement.
On the screen a user can select multiple parameters to do a search and in
code this generates some linq-code that is than executed via NHibernate.
Example: _session.Query<Book>().Where(b => b.ISBN.StartsWith("10025") &&
b.Pages > 100 && b.Author.Name == "Jochen" && ...)
But now I want to use that Where part in combination with INSERT INTO. An
insert into that only works via hql or sql.
Example: _session.CreateQuery("insert into MyBooks (Id, NumberOfPages)
select b.Id, b.Pages where ... (and here should the linq part be inserted)
Is it possible to mix Linq and Hql? Or is there a better solution to this
problem.
Regards,
Jochen
--
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/-/hL9Ozbiv7bYJ.
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.
