How to write update query

Question

0.00/5 (No votes)

See more:

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 20:26pm

Rupali Jadhav

Updated 8-Jan-13 21:15pm

Akinmade Bond

v2

Add a Solution

Comments

Sandeep Mewara 9-Jan-13 2:49am

http://docs.jboss.org/hibernate/orm/3.3/reference/en/html/queryhql.html ?

1 solution

Add a Solution

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

Sumit_Kumar_Sinha · Answer 1 · 2013-01-10T19:05:00

Solution 1

http://www.dot4pro.com/nhibernate-update-query.html[^]
http://nathan.whiteboard-it.com/archive/2008/07/28/nhibernate-bulk-updatesinsertsdeletes-with-named-queries.aspx[^]
http://darioquintana.com.ar/blogging/2007/12/11/nhibernate-bulk-manipulation-with-sql-native/[^]
http://ahmedshuhel.blogspot.in/2011/01/nhibernate-send-update-queries-even.html[^]

Posted 10-Jan-13 19:05pm

Sumit_Kumar_Sinha

Comments

Rupali Jadhav 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.

How to write update query

1 solution

Solution 1

Add your solution here

Preview 0

How to write update query

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us