1 files changed, 38 insertions, 0 deletions
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