Hi,
I think you could refer to the this post
http://stackoverflow.com/questions/7359702/how-do-i-obtain-a-query-execution-plan
to
the section number 4.T
hen you could possibly select "query_plan" column and get it.
regards,
Kamil
W dniu wtorek, 24 grudnia 2013 01:24:21 UTC+1 użytkownik Marko napisał:
>
> 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.
