Class to trace the SQL statements generated by Telerik OpenAccess ORM

[Amilton]

Hello.

I searched the documentation and found a link with a class for tracing of SQL queries: 
http://www.telerik.com/help/openaccess-classic/openaccess-tasks-howto-trace-sql-statements.html

I would like, if possible, a sample project using this class to handle the log file of queries.

Regards,
Felipe.

[Doroteya]

Hi Felipe,

The article you found out is regarding the Classic API of Data Access. Based on the provided information, though, I'm under the impression that you are using the contemporary Context API, more specifically, that you have an .rlinq file in your solution. If my assumption is correct, you could use the Telerik Data Access Profiler and Tuning Advisor to monitor and finetune the performance of your application. More details about the configuration of the project are available in this documentation article.

Additionally, as the Visual Studio integration of Data Access was deprecated a year ago, the Profiler along with the necessary ServiceHost assembly are distributed through the Telerik.DataAccess.Profiler NuGet package.

I hope this helps. Let me know if you need further information.


Regards,
Doroteya
Telerik

 

[Amilton]

Hello.

I read the documentation and put the profile in my project, but the stack trace information is not available, even though I checked the Include Stack Trace option in model settings.

My settings are the same as these:
http://docs.telerik.com/data-access/images/1gettingstarted-profiler-015.png

Regards,
Felipe.