summaryrefslogtreecommitdiff
path: root/slips/src/app/Marina/DataAccess/DatabaseCommand.cs
diff options
context:
space:
mode:
Diffstat (limited to 'slips/src/app/Marina/DataAccess/DatabaseCommand.cs')
-rw-r--r--slips/src/app/Marina/DataAccess/DatabaseCommand.cs23
1 files changed, 23 insertions, 0 deletions
diff --git a/slips/src/app/Marina/DataAccess/DatabaseCommand.cs b/slips/src/app/Marina/DataAccess/DatabaseCommand.cs
new file mode 100644
index 0000000..f394ec0
--- /dev/null
+++ b/slips/src/app/Marina/DataAccess/DatabaseCommand.cs
@@ -0,0 +1,23 @@
+using System;
+using System.Data;
+
+namespace Marina.DataAccess {
+ public class DatabaseCommand : IDatabaseCommand {
+ public DatabaseCommand( IDbCommand command ) {
+ _command = command;
+ }
+
+ public DataTable ExecuteQuery() {
+ DataTable table = new DataTable( );
+ table.Load( _command.ExecuteReader( ) );
+ return table;
+ }
+
+ public long ExecuteScalarQuery() {
+ object scalar = _command.ExecuteScalar( );
+ return DBNull.Value != scalar ? Convert.ToInt32( scalar ) : -1;
+ }
+
+ private readonly IDbCommand _command;
+ }
+} \ No newline at end of file