public async Task SqlScalarQueryTest()
{
var sqlScalarQuery = new SqlScalarQuery
{
SqlQuery = "SELECT Count(1) FROM [dbo].[Table]",
ConnectionString = "Server=tcp:{your-database}.database.windows.net,1433;Initial Catalog=AnyStatus;Persist Security Info=False;User ID={your-user};Password={your-password};MultipleActiveResultSets=False;Encrypt=True;TrustServerCertificate=False;Connection Timeout=1;",
};
var request = MetricQueryRequest.Create(sqlScalarQuery);
var handler = new SqlScalarQueryHandler();
await handler.Handle(request, CancellationToken.None);
Assert.AreNotEqual(State.None, sqlScalarQuery.State);
}
public void SqlScalarQueryTest()
{
var logger = Substitute.For <ILogger>();
var sqlScalarQuery = new SqlScalarQuery
{
ConnectionString = "Server=tcp:{your-database}.database.windows.net,1433;Initial Catalog=AnyStatus;Persist Security Info=False;User ID={your-user};Password={your-password};MultipleActiveResultSets=False;Encrypt=True;TrustServerCertificate=False;Connection Timeout=30;",
SqlQuery = "SELECT Count(1) FROM [dbo].[Table]"
};
var sqlScalarQueryHandler = new SqlScalarQueryMonitor(logger);
sqlScalarQueryHandler.Handle(sqlScalarQuery);
Assert.AreNotEqual(State.None, sqlScalarQuery.State);
}
