How to get the SQL statement?

Jun 10, 2009 at 7:38 PM

Hello,

 

I am seeing some performance issues after migrating to  LINQ to Oracle and trying to see the SQL statement generated by the LInQ provider.

 

Could you please point to me the right direction?

 

Thanks

Coordinator
Jun 13, 2009 at 6:32 PM

Hi,

You can use the following statements :

            this._repository.Log = new StreamWriter(<filename>);

            <PLACE YOUR STATEMENT HERE>
            
            
            this._repository.Log.Flush();
            this._repository.Log.Close();
            this._repository.Log = null;

_repository is your class derived from DataContext

You must replace text in red with your code

Thanks