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); }