Click here to Skip to main content
11,493,537 members (60,757 online)
Rate this: bad
good
Please Sign up or sign in to vote.
See more: NHibernate
Hi,
I want to write one query in NHibernet. The query is as follows

Update table1 Set Date1=(Select top 1 max(Date) from table2 where Id=", Id

I don't know NHibernate so not getting how to write this query. Waiting for suggestions.

Thanks.
Rupali.
Posted 8-Jan-13 21:26pm
Edited 8-Jan-13 22:15pm
v2
Comments
Sandeep Mewara at 9-Jan-13 2:49am
   
http://docs.jboss.org/hibernate/orm/3.3/reference/en/html/queryhql.html ?

1 solution

Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

  Permalink  
Comments
Rupali Jadhav at 11-Jan-13 5:12am
   
Thanks Sumit
But i dont want example for simple update qry. I want a nhibernet qry that will contain another select stmt. i.e. updating one table by fetching some value from another table.

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

  Print Answers RSS
0 Sergey Alexandrovich Kryukov 408
1 F-ES Sitecore 244
2 Maciej Los 241
3 CPallini 233
4 Nakul Chaudhari 225
0 Sergey Alexandrovich Kryukov 10,237
1 OriginalGriff 8,730
2 Sascha Lefèvre 3,664
3 Maciej Los 3,392
4 Richard Deeming 2,500


Advertise | Privacy | Mobile
Web01 | 2.8.150520.1 | Last Updated 11 Jan 2013
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100