Steps to add model for MFI UI project which is same as API Request Model

  • Add Common Models to MFI_API_MODEL Project
  • Build project and make error free
  • Change Nuget Package Version in MFI_API_MODEL.nuspec file
  • Generate Nuget Package from CMD using command:
    • nuget pack mfi_api_model.nuspec -prop configuration=release
  • Host Nuget Package to accessible server location in Ants or local computer
  • Open Own UI project,
  • Update Package version

MSSQL Check Running Queries

SELECT sqltext.TEXT,
req.session_id,
req.status,
req.command,
req.cpu_time,
req.total_elapsed_time
FROM sys.dm_exec_requests req
CROSS APPLY sys.dm_exec_sql_text(sql_handle) AS sqltext