LINQPad load test statistics aggregation example

readme.txt

(localdb)\MSSQLLocalDb.LoadTest2010

Program.cs

void Main()
{
    foreach(var run in LoadTestRuns
		.Where(o=> o.LoadTestName == "baseline" && o.RunDuration == 7200)
		.Select(o=> new {o.LoadTestRunId, o.StartTime, o.EndTime})
	){
	    run.Dump();
	   	var testruns = run.LoadTestRunId;
		var failedTests = LoadTestMessageView2
			.Where(o=>o.LoadTestRunId==testruns && o.TestCaseName!=null)
			.Select(o=>new {
				o.TestCaseName,
				o.MessageTimeStamp,
				o.MessageText,
				o.StackTrace,
				o.TestLogId
			})
			.ToList()
			.Select(o=>new {
			    o.MessageTimeStamp,
				o.TestCaseName,
				IdCode = ExtractIdCode(GetLog(o.TestLogId,testruns)),
				o.MessageText,
				o.StackTrace,
				o.TestLogId
			})
			.OrderBy(o=>o.TestCaseName)
			.ThenBy(o=>o.MessageText)
			.ThenBy(o=>o.IdCode);
			
		var testdata = failedTests
			.Select(o=>new {
				o.TestCaseName,
				o.MessageText,
				o.IdCode
			})
			.GroupBy(x => new {x.TestCaseName, x.MessageText}) 
			.Select(y => 
				new {
				        TestCaseName = y.Key.TestCaseName,
				        ErrorMessage = y.Key.MessageText,
				        Count = y.ToList().Count,
						IdCodes = y.ToList().Where(o=>o.IdCode!="").Select(o=>o.IdCode).OrderBy(o=>o)
				    }
				).Dump();
	}
}

public string GetLog(int? log, int runid){
	if(log == null)
		return "";
		
	return Encoding.UTF8.GetString(
		LoadTestTestLogs
			.FirstOrDefault(k=>k.LoadTestRunId==runid && k.TestLogId==log)
			.TestLog
			.ToArray());
}
public string ExtractIdCode(string log){
    var startTag ="user['";
	var start = log.IndexOf("user['");
	if(start < 0)
		return "";
	
	return log.Substring(start+startTag.Length, 11);
}