extras/MonoDevelop.Database/MonoDevelop.Database.Sql.Sqlite/SqliteConnectionProvider.cs

   1 //
   2 // Authors:
   3 //   Christian Hergert  <chris@mosaix.net>
   4 //   Ankit Jain  <radical@corewars.org>
   5 //   Ben Motmans  <ben.motmans@gmail.com>
   6 //
   7 // Copyright (C) 2005 Mosaix Communications, Inc.
   8 // Copyright (c) 2007 Ben Motmans
   9 //
  10 // Permission is hereby granted, free of charge, to any person obtaining a copy
  11 // of this software and associated documentation files (the "Software"), to deal
  12 // in the Software without restriction, including without limitation the rights
  13 // to use, copy, modify, merge, publish, distribute, sublicense, and/or sell
  14 // copies of the Software, and to permit persons to whom the Software is
  15 // furnished to do so, subject to the following conditions:
  16 //
  17 // The above copyright notice and this permission notice shall be included in
  18 // all copies or substantial portions of the Software.
  19 //
  20 // THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR
  21 // IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY,
  22 // FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE
  23 // AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER
  24 // LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM,
  25 // OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN
  26 // THE SOFTWARE.
  27 //
  28
  29 using System;
  30 using System.Data;
  31 using System.Collections.Generic;
  32 using Mono.Data.Sqlite;
  33
  34 namespace MonoDevelop.Database.Sql.Sqlite
  35 {
  36         public class SqliteConnectionProvider : AbstractConnectionProvider
  37         {
  38                 public override IPooledDbConnection CreateConnection (IConnectionPool pool, DatabaseConnectionSettings settings, out string error)
  39                 {
  40                         string connStr = null;
  41                         try {
  42                                 if (settings.UseConnectionString) {
  43                                         connStr = settings.ConnectionString;
  44                                 } else {
  45                                         connStr = String.Concat ("URI=file:", settings.Database);
  46                                 }
  47                                 SqliteConnection connection = new SqliteConnection (connStr);
  48                                 connection.Open ();
  49
  50                                 error = null;
  51                                 return new SqlitePooledDbConnection (pool, connection);
  52                         } catch (Exception e) {
  53                                 error = e.Message;
  54                                 return null;
  55                         }
  56                 }
  57         }
  58 }