From 1dfdccb8118aeaa3cd844ac8de2a672c93312166 Mon Sep 17 00:00:00 2001 From: mokhan Date: Sat, 21 Feb 2009 21:44:27 +0000 Subject: git-svn-id: http://svn.xp-dev.com/svn/mokhan-sait@2 da190166-9cfc-4ee1-ae03-434a172be219 --- .../app/Marina/DataAccess/DatabaseConnection.cs | 38 ++++++++++++++++++++++ 1 file changed, 38 insertions(+) create mode 100644 slips/src/app/Marina/DataAccess/DatabaseConnection.cs (limited to 'slips/src/app/Marina/DataAccess/DatabaseConnection.cs') diff --git a/slips/src/app/Marina/DataAccess/DatabaseConnection.cs b/slips/src/app/Marina/DataAccess/DatabaseConnection.cs new file mode 100644 index 0000000..b08399f --- /dev/null +++ b/slips/src/app/Marina/DataAccess/DatabaseConnection.cs @@ -0,0 +1,38 @@ +using System; +using System.Data; +using Marina.DataAccess.Builders; + +namespace Marina.DataAccess { + public class DatabaseConnection : IDatabaseConnection { + private readonly IDbConnection _connection; + + public DatabaseConnection() : this( new DatabaseConfiguration( ), new DatabaseProviderFactory( ) ) {} + + public DatabaseConnection( IDatabaseConfiguration configuration, IDatabaseProviderFactory providerFactory ) { + _connection = providerFactory.CreateConnectionFor( configuration.ProviderName( ) ); + _connection.ConnectionString = configuration.ConnectionString( ); + _connection.Open( ); + } + + public IDatabaseCommand CreateCommandFor( string sqlQuery ) { + return CreateCommandFor( new SqlQuery( sqlQuery ) ); + } + + public IDatabaseCommand CreateCommandFor( IQuery query ) { + IDbCommand command = _connection.CreateCommand( ); + query.Prepare( command ); + return new DatabaseCommand( command ); + } + + public void Dispose() { + Dispose( true ); + GC.SuppressFinalize( this ); + } + + protected virtual void Dispose( bool disposing ) { + if ( disposing ) { + _connection.Close( ); + } + } + } +} \ No newline at end of file -- cgit v1.2.3