Does someone know how to get SQl ExecutionPlan XML using NHibernate, I have 
tried many things but i can't send queries in separate batches (which is 
manadatory when you want to get exectuon plan for some query) without 
connection reset between

e.g.

session.CreateSQLQuery("set showplan_xml on").List();

 IList<dynamic> result = session.CreateSQLQuery(queryString).DynamicList();

session.CreateSQLQuery("set showplan_xml off").List();

I have reset connection between those three queries

*These three queries are execute in single transaction!!!*


Many thanx

-- 
You received this message because you are subscribed to the Google Groups 
"nhusers" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/nhusers.
For more options, visit https://groups.google.com/groups/opt_out.

Reply via email to