class/Mono.Data/ProviderFactory.cs

   1 //
   2 // Mono.Data.ProviderFactory
   3 //
   4 // Authors:
   5 //   Brian Ritchie (brianlritchie@hotmail.com)
   6 //
   7 //
   8 // Copyright (C) Brian Ritchie, 2002
   9 //
  10 //
  11
  12 //
  13 // Permission is hereby granted, free of charge, to any person obtaining
  14 // a copy of this software and associated documentation files (the
  15 // "Software"), to deal in the Software without restriction, including
  16 // without limitation the rights to use, copy, modify, merge, publish,
  17 // distribute, sublicense, and/or sell copies of the Software, and to
  18 // permit persons to whom the Software is furnished to do so, subject to
  19 // the following conditions:
  20 //
  21 // The above copyright notice and this permission notice shall be
  22 // included in all copies or substantial portions of the Software.
  23 //
  24 // THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND,
  25 // EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF
  26 // MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND
  27 // NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE
  28 // LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION
  29 // OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION
  30 // WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.
  31 //
  32 using System;
  33 using System.Data;
  34 using System.Reflection;
  35 using System.Runtime.Remoting;
  36 using System.Configuration;
  37 using System.Xml;
  38 using System.Collections.Specialized;
  39
  40 namespace Mono.Data
  41 {
  42 #if NET_2_0
  43         [Obsolete("ProviderFactory in assembly Mono.Data has been made obsolete by DbProviderFactories in assembly System.Data.")]
  44 #endif
  45         public class ProviderFactory
  46         {
  47                 private static ProviderCollection providers;
  48
  49                 static ProviderFactory ()
  50                 {
  51                         providers = (ProviderCollection) ConfigurationSettings.GetConfig ("mono.data/providers");
  52                         if (providers == null) {
  53                                 providers = new ProviderCollection ();
  54                                 // warn the developer or administrator that the provider list is empty
  55                                 System.Diagnostics.Debug.Listeners.Add (new System.Diagnostics.TextWriterTraceListener (Console.Out));
  56                                 System.Diagnostics.Debug.WriteLine ("No providers found. Did you set up a mono.data/providers area in your app.config or in machine.config?");
  57                         }
  58
  59                 }
  60
  61                 static public ProviderCollection Providers
  62                 {
  63                         get {
  64                                 return providers;
  65                         }
  66                 }
  67
  68                 static public IDbConnection CreateConnectionFromConfig (string Setting)
  69                 {
  70                         if (Setting == null)
  71                                 throw new System.ArgumentNullException ("Setting");
  72
  73                         return CreateConnection (ConfigurationSettings.AppSettings [Setting]);
  74                 }
  75
  76                 static public IDbConnection CreateConnection(string ConnectionString)
  77                 {
  78                         if (ConnectionString == null)
  79                                 throw new System.ArgumentNullException ("ConnectionString");
  80
  81                         string [] ConnectionAttributes = ConnectionString.Split (new Char [1] { ';' });
  82                         string ProviderName = null;
  83                         string NewConnectionString = "";
  84                         foreach (string s in ConnectionAttributes) {
  85                                 string [] AttributeParts = s.Split (new Char [1] { '=' });
  86                                 if (AttributeParts [0].ToLower ().Trim () == "factory")
  87                                         ProviderName = AttributeParts [1].Trim ();
  88                                 else
  89                                         NewConnectionString += ";" + s;
  90                         }
  91                         NewConnectionString = NewConnectionString.Remove (0, 1); // remove the initial semicolon
  92                         if (ProviderName == null)
  93                                 throw new System.ArgumentException ("The connection string must contain a 'factory=Provider.Class' token", "ConnectionString");
  94                         return CreateConnection (ProviderName, NewConnectionString);
  95                 }
  96
  97                 static public IDbConnection CreateConnection(string ProviderName, string ConnectionString)
  98                 {
  99                         if (ProviderName == null)
 100                                 throw new System.ArgumentNullException("ProviderName");
 101                         if (ConnectionString == null)
 102                                 throw new System.ArgumentNullException ("ConnectionString");
 103
 104                         Provider provider = providers [ProviderName];
 105
 106                         if (provider == null)
 107                                 throw new ArgumentException ("ProviderName", "The specified provider does not exist");
 108
 109                         IDbConnection conn = provider.CreateConnection ();
 110                         conn.ConnectionString = ConnectionString;
 111                         return conn;
 112                 }
 113
 114                 static public IDbCommand CreateStoredProc (IDbConnection Conn, string CommandName)
 115                 {
 116                         if (Conn == null)
 117                                 throw new System.ArgumentNullException ("Conn");
 118                         if (CommandName == null)
 119                                 throw new System.ArgumentNullException ("CommandName");
 120
 121                         IDbCommand cmd = Conn.CreateCommand ();
 122                         cmd.CommandText = CommandName;
 123                         cmd.CommandType = CommandType.StoredProcedure;
 124                         return cmd;
 125                 }
 126
 127                 static public IDbDataAdapter CreateDataAdapter (IDbCommand SelectCommand)
 128                 {
 129                         if (SelectCommand == null)
 130                                 throw new System.ArgumentNullException("SelectCommand");
 131
 132                         Provider provider = providers.FindByCommandType (SelectCommand.GetType ());
 133                         IDbDataAdapter adapter = provider.CreateDataAdapter ();
 134                         adapter.SelectCommand = SelectCommand;
 135                         return adapter;
 136                 }
 137
 138                 static public IDbDataAdapter CreateDataAdapter (string ProviderName)
 139                 {
 140                         if (ProviderName == null)
 141                                 throw new System.ArgumentNullException("ProviderName");
 142
 143                         Provider provider = providers [ProviderName];
 144                         IDbDataAdapter adapter = provider.CreateDataAdapter ();
 145                         return adapter;
 146                 }
 147
 148                 static public IDbDataAdapter CreateDataAdapter (IDbConnection Conn, string SelectCommand)
 149                 {
 150                         if (Conn == null)
 151                                 throw new System.ArgumentNullException ("Conn");
 152                         if (SelectCommand == null)
 153                                 throw new System.ArgumentNullException("SelectCommand");
 154
 155                         IDbCommand cmd = Conn.CreateCommand ();
 156                         cmd.CommandText = SelectCommand;
 157                         return CreateDataAdapter (cmd);
 158                 }
 159
 160                 static public IDbCommand CreateCommand (string ProviderName)
 161                 {
 162                         if (ProviderName == null)
 163                                 throw new System.ArgumentNullException("ProviderName");
 164
 165                         Provider provider = providers [ProviderName];
 166                         return provider.CreateCommand ();
 167                 }
 168
 169                 static public IDbCommand CreateCommand (IDbConnection Conn)
 170                 {
 171                         if (Conn == null)
 172                                 throw new System.ArgumentNullException("Conn");
 173
 174                         return Conn.CreateCommand ();
 175                 }
 176
 177         }
 178 }