diff options
| author | mokhan <mokhan@da190166-9cfc-4ee1-ae03-434a172be219> | 2009-02-21 21:44:27 +0000 |
|---|---|---|
| committer | mokhan <mokhan@da190166-9cfc-4ee1-ae03-434a172be219> | 2009-02-21 21:44:27 +0000 |
| commit | 1dfdccb8118aeaa3cd844ac8de2a672c93312166 (patch) | |
| tree | 4b19e7f816ab1019f180a46b68572af4b66fe4bc /slips/src/app/Marina/DataAccess/DatabaseConnection.cs | |
| parent | 42d66bcab8262c7b8b2452615df535e694a3ec1c (diff) | |
git-svn-id: http://svn.xp-dev.com/svn/mokhan-sait@2 da190166-9cfc-4ee1-ae03-434a172be219
Diffstat (limited to 'slips/src/app/Marina/DataAccess/DatabaseConnection.cs')
| -rw-r--r-- | slips/src/app/Marina/DataAccess/DatabaseConnection.cs | 38 |
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 |