Last post Oct 04, 2017 06:59 AM by AngelinaJolie
Oct 04, 2017 03:22 AM|Khan_1|LINK
I need suggestions to go for which tool which can detect the coding + linq to sql and client side issues. I am using MVC on VS 2012.
Oct 04, 2017 06:59 AM|AngelinaJolie|LINK
I recommend that you could use this tool which called CLR Profiler;
CLR Profiler enables you to look at the managed heap of a process and investigate the behavior of the garbage collector. Using the various views in the tool, you can obtain useful information about the execution, allocation, and memory
consumption of your application.
More details,please refer to:
Tool Download Link:https://www.microsoft.com/en-sg/download/details.aspx?id=16273
coding + linq to sql and client side issues.
and in fact ,i think what you need is to know the real executed sql statement from linq when we call linq at VS,then to know what happen;
we could view all performance via sql server and full sql statement ;
_context.PLCBlock.Where(s=> s.clientID == User.Identity.Name)
it will execute sql query statement based on clientID .you could think sql statement like "select * from db.PLCBlock where clientID==1".
And you could view this sql statement from SQL Sever Profiler (Sql Server -> tools ->SQL Server Profiler) on SQL Server directly.
Here is my example to view the sql statement :
note: I have few data in this table
[Extent1].[Id] AS [Id],
[Extent1].[strBookTypeId] AS [strBookTypeId],
[Extent1].[strAccessionId] AS [strAccessionId]
FROM [dbo].[BookMasters] AS [Extent1]
WHERE [Extent1].[Id] > 5
ORDER BY [Extent1].[Id] ASC
OFFSET 9 ROWS FETCH NEXT 3 ROWS ONLY
The linq in controller :
var u= db.BookMasters.Where(p=>p.Id>5).OrderBy(y=>y.Id).ToPagedList(4,3);