Click here to Skip to main content
11,637,415 members (58,161 online)
Rate this: bad
Please Sign up or sign in to vote.
See more: NHibernate
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.

Posted 8-Jan-13 20:26pm
Edited 8-Jan-13 21:15pm
Sandeep Mewara at 9-Jan-13 2:49am ?

1 solution

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

Solution 1

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 OriginalGriff 295
1 stibee 288
2 270
3 Sergey Alexandrovich Kryukov 224
4 himanshu agarwal 184
0 OriginalGriff 9,031
1 Sergey Alexandrovich Kryukov 8,643
2 Mika Wendelius 6,959
3 F-ES Sitecore 2,388
4 Suvendu Shekhar Giri 2,320

Advertise | Privacy | Mobile
Web01 | 2.8.150728.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