public async Task ConnectionShouldConnectWhenCommandIsExecuted() { var connection = TestDatabase.GetConnection(); using (var session = new Session(connection)) { var sampleQuery = @"Select 'Test'"; connection.State.Should().Be(ConnectionState.Closed); var result = await session.CreateCommand(sampleQuery).ExecuteScalarAsync <string>(); connection.State.Should().Be(ConnectionState.Open); result.Should().Be("Test"); } }
public async Task SampleQueryTest() { using (var unitOfWork = new UnitOfWork(TestDatabase.GetConnection())) { var session = new Session(unitOfWork); var createTableSql = @"Create Table ScalarTable ( Id int primary key, Name varchar(20) )"; var insertIntoSql = @"Insert Into ScalarTable Values (1, 'One')"; session.CreateCommand(createTableSql).ExecuteNonQuery(); session.CreateCommand(insertIntoSql).ExecuteNonQuery(); var value = await session.CreateCommand("Select Id From ScalarTable where Id = ?", 1).ExecuteScalarAsync<int>(); value.Should().Be(1); } }
[Test] public async Task OnlyTransformUnnamedParameters() { using (var session = new Session(TestDatabase.GetConnection())) { var createTableSql = @"Create Table OnlyTransformUnnamedParameters_Table ( [Id] int primary key, [String] varchar(20) )"; var insertIntoSql = @"Insert Into OnlyTransformUnnamedParameters_Table Values (?,'?')"; session.CreateCommand(createTableSql).ExecuteNonQuery(); session.CreateCommand(insertIntoSql, 1).ExecuteNonQuery(); using (var command = await session.CreateCommand("Select * From OnlyTransformUnnamedParameters_Table").ExecuteQueryAsync()) { var row = await command.SingleAsync <dynamic>(); ((int)row.Id).Should().Be(1); ((string)row.String).Should().Be("?"); } } }
public async Task SampleQueryTest() { using (var unitOfWork = new UnitOfWork(TestDatabase.GetConnection())) { var session = new Session(unitOfWork); var createTableSql = @"Create Table TableA ( Id int primary key, Name varchar(20) )"; var insertIntoSql = @"Insert Into TableA Values (1, 'One')"; session.CreateCommand(createTableSql).ExecuteNonQuery(); session.CreateCommand(insertIntoSql).ExecuteNonQuery(); using (var command = await session.CreateCommand("Select * From TableA where Id = ?", 1).ExecuteQueryAsync()) { var row = await command.SingleAsync <RawRow>(); ((int)row.Id).Should().Be(1); } } }
public async Task MultipleParametersShouldMatchTypes() { using (var session = new Session(TestDatabase.GetConnection())) { var createTableSql = @"Create Table MultipleParametersShouldMatchTypes_Table ( [Id] int primary key, [String] varchar(20), [Boolean] bit )"; var insertIntoSql = @"Insert Into MultipleParametersShouldMatchTypes_Table Values (?, ?, ?)"; session.CreateCommand(createTableSql).ExecuteNonQuery(); session.CreateCommand(insertIntoSql, 1, "value", true).ExecuteNonQuery(); using (var command = await session.CreateCommand("Select * From MultipleParametersShouldMatchTypes_Table").ExecuteQueryAsync()) { var row = await command.SingleAsync <dynamic>(); ((int)row.Id).Should().Be(1); ((string)row.String).Should().Be("value"); ((bool)row.Boolean).Should().Be(true); } } }
public void RunAfterAnyTests() { TestDatabase.Delete(); }
public void RunBeforeAnyTests() { TestDatabase.Create(); }