public virtual async Task Can_ExecuteNonQueryAsync(bool manageConnection)
{
var executeNonQueryCount = 0;
var disposeCount = -1;
var fakeDbConnection = new FakeDbConnection(
ConnectionString,
new FakeCommandExecutor(
executeNonQueryAsync: (c, ct) =>
{
executeNonQueryCount++;
disposeCount = c.DisposeCount;
return(Task.FromResult(1));
}));
var optionsExtension = new FakeRelationalOptionsExtension {
Connection = fakeDbConnection
};
var options = CreateOptions(optionsExtension);
var fakeConnection = new FakeRelationalConnection(options);
var relationalCommand = new RelationalCommand(
new FakeSensitiveDataLogger <RelationalCommand>(),
new DiagnosticListener("Fake"),
"ExecuteNonQuery Command",
new RelationalParameter[0]);
var result = await relationalCommand.ExecuteNonQueryAsync(fakeConnection, manageConnection : manageConnection);
Assert.Equal(1, result);
var expectedCount = manageConnection ? 1 : 0;
Assert.Equal(expectedCount, fakeDbConnection.OpenCount);
Assert.Equal(expectedCount, fakeDbConnection.CloseCount);
// Durring command execution
Assert.Equal(1, executeNonQueryCount);
Assert.Equal(0, disposeCount);
// After command execution
Assert.Equal(1, fakeDbConnection.DbCommands[0].DisposeCount);
}
public virtual async Task Can_ExecuteNonQueryAsync(bool manageConnection)
{
var executeNonQueryCount = 0;
var disposeCount = -1;
var fakeDbConnection = new FakeDbConnection(
ConnectionString,
new FakeCommandExecutor(
executeNonQueryAsync: (c, ct) =>
{
executeNonQueryCount++;
disposeCount = c.DisposeCount;
return Task.FromResult(1);
}));
var optionsExtension = new FakeRelationalOptionsExtension { Connection = fakeDbConnection };
var options = CreateOptions(optionsExtension);
var fakeConnection = new FakeRelationalConnection(options);
var relationalCommand = new RelationalCommand(
new FakeSensitiveDataLogger<RelationalCommand>(),
new DiagnosticListener("Fake"),
"ExecuteNonQuery Command",
new RelationalParameter[0]);
await relationalCommand.ExecuteNonQueryAsync(fakeConnection, manageConnection: manageConnection);
var expectedCount = manageConnection ? 1 : 0;
Assert.Equal(expectedCount, fakeDbConnection.OpenCount);
Assert.Equal(expectedCount, fakeDbConnection.CloseCount);
// Durring command execution
Assert.Equal(1, executeNonQueryCount);
Assert.Equal(0, disposeCount);
// After command execution
Assert.Equal(1, fakeDbConnection.DbCommands[0].DisposeCount);
}
