public IDatabaseRow LoadRowUsing(IQuery query) { using (IDatabaseConnection connection = _connectionFactory.Create( )) { DataTable table = connection.CreateCommandFor(query).ExecuteQuery( ); return(table.Rows.Count > 0 ? new DatabaseRow(table.Rows[0]) : DatabaseRow.Blank); } }
public DataTable LoadTableUsing(string sqlQuery) { using (IDatabaseConnection connection = _connectionFactory.Create( )) { IDatabaseCommand command = connection.CreateCommandFor(sqlQuery); return((null != command) ? command.ExecuteQuery( ) : null); } }
public void Execute(IEnumerable <IQuery> queries) { using (IDatabaseConnection connection = _connectionFactory.Create( )) { foreach (IQuery query in queries) { connection.CreateCommandFor(query).ExecuteQuery( ); } } }
public IEnumerable <IDatabaseRow> FindAllRowsMatching(IQuery query) { using (IDatabaseConnection connection = _connectionFactory.Create( )) { DataTable table = connection.CreateCommandFor(query).ExecuteQuery( ); if (null != table) { foreach (DataRow row in table.Rows) { yield return(new DatabaseRow(row)); } } } }
public void Should_create_command_using_database_connection() { IDatabaseConnection mockConnection = _mockery.DynamicMock <IDatabaseConnection>( ); IDatabaseCommand mockCommand = _mockery.DynamicMock <IDatabaseCommand>( ); string sqlQuery = "SELECT * FROM ?"; using (_mockery.Record( )) { SetupResult.For(_mockConnectionFactory.Create( )).Return(mockConnection); Expect.Call(mockConnection.CreateCommandFor(sqlQuery)).Return(mockCommand); } using (_mockery.Playback( )) { CreateSUT( ).LoadTableUsing(sqlQuery); } }
public void Should_execute_query_on_command(string sqlQuery) { IDatabaseConnection mockConnection = _mockery.DynamicMock <IDatabaseConnection>( ); IDatabaseCommand mockCommand = _mockery.DynamicMock <IDatabaseCommand>( ); DataTable table = new DataTable( ); using (_mockery.Record( )) { SetupResult.For(_mockConnectionFactory.Create( )).Return(mockConnection); SetupResult.For(mockConnection.CreateCommandFor(sqlQuery)).Return(mockCommand); Expect.Call(mockCommand.ExecuteQuery( )).Return(table); } using (_mockery.Playback( )) { Assert.AreEqual(table, CreateSUT( ).LoadTableUsing(sqlQuery)); } }
public void Should_close_the_connection_after_executing_the_command() { IDatabaseConnection mockConnection = _mockery.DynamicMock <IDatabaseConnection>( ); IDatabaseCommand mockCommand = _mockery.DynamicMock <IDatabaseCommand>( ); string sqlQuery = "SELECT * FROM ?"; DataTable table = new DataTable( ); using (_mockery.Record( )) { SetupResult.For(_mockConnectionFactory.Create( )).Return(mockConnection); SetupResult.For(mockConnection.CreateCommandFor(sqlQuery)).Return(mockCommand); using (_mockery.Ordered( )) { Expect.Call(mockCommand.ExecuteQuery( )).Return(table); mockConnection.Dispose( ); } } using (_mockery.Playback( )) { CreateSUT( ).LoadTableUsing(sqlQuery); } }
public long ExecuteScalar(IQuery query) { using (IDatabaseConnection connection = _connectionFactory.Create( )) { return(connection.CreateCommandFor(query).ExecuteScalarQuery( )); } }