I have a .Net application which uses Inline Queries in abundance. As part of a performance improvement initiative, I want to extract all the inline queries being used across the .Net application into a Text file or Excelsheet. IS there any way to avoid
the manual effort for this activity? Are there any tools available? Please let me know how to extract this information with minimal manual effort?
PFB a sample of inline query in my application --
try
{
dbextraction.initParameters();
dbextraction.AddParameters("dtDate", "Date/Time", dtDate);
dbextraction.SqlPrepareAndExecute(ref hSqlVal, objFilter.VarSqlFilter(" Select name , id from "+ dbextraction.dbowner + "employee where a23_status = 'Active'"));
}
catch(Exception ex)
{
...
Go to the complete details ...