private async Task WriteResultsToSql(
DateTime utcNow,
string connectionString,
string tableName,
string session,
string description,
string aspnetCoreVersion,
string runtimeVersion,
string scenario,
Hardware hardware,
string hardwareVersion,
Benchmarks.ServerJob.OperatingSystem operatingSystem,
Scheme scheme,
Source source,
WebHost webHost,
int?kestrelThreadCount,
int clientThreads,
int connections,
int duration,
int?pipelineDepth,
string path,
string method,
IDictionary <string, string> headers,
string dimension,
double value,
bool runtimeStore)
{
string insertCmd =
@"
INSERT INTO [dbo].[" + tableName + @"]
([DateTime]
,[Session]
,[Description]
,[AspNetCoreVersion]
,[RuntimeVersion]
,[Scenario]
,[Hardware]
,[HardwareVersion]
,[OperatingSystem]
,[Framework]
,[RuntimeStore]
,[Scheme]
,[WebHost]
,[KestrelThreadCount]
,[ClientThreads]
,[Connections]
,[Duration]
,[PipelineDepth]
,[Path]
,[Method]
,[Headers]
,[Dimension]
,[Value])
VALUES
(@DateTime
,@Session
,@Description
,@AspNetCoreVersion
,@RuntimeVersion
,@Scenario
,@Hardware
,@HardwareVersion
,@OperatingSystem
,@Framework
,@RuntimeStore
,@Scheme
,@WebHost
,@KestrelThreadCount
,@ClientThreads
,@Connections
,@Duration
,@PipelineDepth
,@Path
,@Method
,@Headers
,@Dimension
,@Value)
";
using (var connection = new SqlConnection(connectionString))
{
await connection.OpenAsync();
var transaction = connection.BeginTransaction();
try
{
var command = new SqlCommand(insertCmd, connection, transaction);
var p = command.Parameters;
p.AddWithValue("@DateTime", utcNow);
p.AddWithValue("@Session", session);
p.AddWithValue("@Description", description);
p.AddWithValue("@AspNetCoreVersion", aspnetCoreVersion);
p.AddWithValue("@RuntimeVersion", runtimeVersion);
p.AddWithValue("@Scenario", scenario.ToString());
p.AddWithValue("@Hardware", hardware.ToString());
p.AddWithValue("@HardwareVersion", hardwareVersion);
p.AddWithValue("@OperatingSystem", operatingSystem.ToString());
p.AddWithValue("@Framework", "Core");
p.AddWithValue("@RuntimeStore", runtimeStore);
p.AddWithValue("@Scheme", scheme.ToString().ToLowerInvariant());
p.AddWithValue("@WebHost", webHost.ToString());
p.AddWithValue("@KestrelThreadCount", (object)kestrelThreadCount ?? DBNull.Value);
p.AddWithValue("@ClientThreads", clientThreads);
p.AddWithValue("@Connections", connections);
p.AddWithValue("@Duration", duration);
p.AddWithValue("@PipelineDepth", (object)pipelineDepth ?? DBNull.Value);
p.AddWithValue("@Path", string.IsNullOrEmpty(path) ? (object)DBNull.Value : path);
p.AddWithValue("@Method", method.ToString().ToUpperInvariant());
p.AddWithValue("@Headers", headers.Any() ? JsonConvert.SerializeObject(headers) : (object)DBNull.Value);
p.AddWithValue("@Dimension", dimension);
p.AddWithValue("@Value", value);
await command.ExecuteNonQueryAsync();
transaction.Commit();
}
catch
{
transaction.Rollback();
throw;
}
finally
{
transaction.Dispose();
}
}
}
public Web(WebHost host, WebLocation location, IDictionary data, int retry = 0, float retryDelay = 0f)
: this(host.ToString(), location, data, retry, retryDelay)
{
}
