Click here to Skip to main content
11,707,470 members (73,647 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 Mika Wendelius 220
1 Maciej Los 195
2 OriginalGriff 148
3 Sergey Alexandrovich Kryukov 145
4 chainerlt 110
0 OriginalGriff 9,198
1 Sergey Alexandrovich Kryukov 8,562
2 CPallini 5,189
3 Maciej Los 4,921
4 Mika Wendelius 3,856

Advertise | Privacy | Mobile
Web04 | 2.8.150819.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