select 1 in NHibernate

theb · **Joined:** Wed Sep 27, 2006 7:40 am **Posts:** 7

Hello!

How do I make "select 1 from dual" in NHibernate?

Best regards!

sergey · **Posted:** Fri Feb 02, 2007 11:00 am

You use ADO.NET...

Ayende Rahien · **Joined:** Sat Sep 24, 2005 11:25 am **Posts:** 198

As far as I know, it is not possible.
What are you trying to do?

dado2003 · **Posted:** Tue Feb 06, 2007 12:11 pm

Hello,

If this is what you really need (that is query dependent on oracle) than:

Code:

ISession session = null; // set to current session
IDbCommand cmd = session.SessionFactory.ConnectionProvider.Driver.CreateCommand();
cmd.CommandText = "select 1 from dual";
cmd.Connection = session.Connection;
cmd.Transaction.Enlist(currentDbCommand);
cmd.ExecuteScalar();

(Hope this still works with 1.2)

Dragos