Hi,

Is it possible to convert Nhibernate query to normal sql query and vice versa.

Example:
From Nhibernate Code

QueryBuilder qb = new QueryBuilder(EntityNames.Employee);
qb.LoadReturnedProperties("Id", "EMPName", "Dept");

qb.AddWhereClause(WhereClause.Ge("Id", 10));
qb.AddWhereClause(WhereClause.StartsWith("Name", "S"));

To Sql Query
Select id,Empname,Dept from Employee where Id > 10 and Name like 's%'

Is there any tool for conversion...

Its very urgent..Kindly help me out.

Thanks in advance.

Regards
Sriya