| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302 |
- //
- // System.Data.OleDb.OleDbConnection
- //
- // Authors:
- // Konstantin Triger <[email protected]>
- // Boris Kirzner <[email protected]>
- //
- // (C) 2006 Mainsoft Corporation (http://www.mainsoft.com)
- //
- //
- // Permission is hereby granted, free of charge, to any person obtaining
- // a copy of this software and associated documentation files (the
- // "Software"), to deal in the Software without restriction, including
- // without limitation the rights to use, copy, modify, merge, publish,
- // distribute, sublicense, and/or sell copies of the Software, and to
- // permit persons to whom the Software is furnished to do so, subject to
- // the following conditions:
- //
- // The above copyright notice and this permission notice shall be
- // included in all copies or substantial portions of the Software.
- //
- // THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND,
- // EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF
- // MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND
- // NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE
- // LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION
- // OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION
- // WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.
- //
- using System;
- using System.Collections;
- using System.Collections.Specialized;
- using System.Text;
- using System.Globalization;
- namespace Mainsoft.Data.Configuration
- {
- public class ConnectionStringDictionary: IConnectionStringDictionary
- {
- #region Fields
- private readonly IDictionary _dictionary;
- private readonly NameValueCollection _mapping;
- private readonly NameValueCollection _actualKeys;
- #endregion // Fields
- #region Constructors
- public ConnectionStringDictionary(string connectionString, NameValueCollection defaultMapping)
- {
- _actualKeys = new NameValueCollection();
- _dictionary = Parse (connectionString);
- _mapping = defaultMapping;
- }
- #endregion // Constructors
- #region Methods
- public string GetConnectionStringKey (string key)
- {
- string cached = _actualKeys [key];
- if (cached != null)
- return cached;
- if (_mapping != null)
- for(int i = 0, c = _mapping.Keys.Count; i < c; i++) {
- if (string.Compare(key, _mapping.Keys[i], true,
- CultureInfo.InvariantCulture) == 0) {
- string[] values = _mapping.GetValues(i);
- for(int j = 0; j < values.Length; j++) {
- string actualKey = values[j];
- if (_dictionary.Contains (actualKey)) {
- _actualKeys.Add (key, actualKey);
- return actualKey;
- }
- }
- }
- }
- if (_dictionary.Contains(key))
- return key;
- return null;
- }
- public static IDictionary Parse (string connectionString)
- {
- IDictionary userParameters = CollectionsUtil.CreateCaseInsensitiveHashtable();
- if (connectionString == null || connectionString.Length == 0) {
- return userParameters;
- }
- //connectionString += ";";
- bool inQuote = false;
- bool inDQuote = false;
- bool inName = true;
- string name = String.Empty;
- string value = String.Empty;
- StringBuilder sb = new StringBuilder (connectionString.Length);
- for (int i = 0; i < connectionString.Length; i ++) {
- char c = connectionString [i];
- char peek;
- if (i == connectionString.Length - 1)
- peek = '\0';
- else
- peek = connectionString [i + 1];
- switch (c) {
- case '\'':
- if (inDQuote)
- sb.Append (c);
- else if (peek == c) {
- sb.Append(c);
- i ++;
- }
- else
- inQuote = !inQuote;
- break;
- case '"':
- if (inQuote)
- sb.Append(c);
- else if (peek == c) {
- sb.Append(c);
- i ++;
- }
- else
- inDQuote = !inDQuote;
- break;
- case ';':
- if (inDQuote || inQuote)
- sb.Append(c);
- else {
- if (name != null && name.Length > 0) {
- value = sb.ToString();
- userParameters [name.Trim()] = value.Trim();
- }
- inName = true;
- name = String.Empty;
- value = String.Empty;
- sb.Length = 0;
- }
- break;
- case '=':
- if (inDQuote || inQuote || !inName)
- sb.Append (c);
- else if (peek == c) {
- sb.Append (c);
- i += 1;
- }
- else {
- name = sb.ToString();
- sb.Length = 0;
- inName = false;
- }
- break;
- case ' ':
- if (inQuote || inDQuote)
- sb.Append(c);
- else if (sb.Length > 0 && peek != ';')
- sb.Append(c);
- break;
- default:
- sb.Append(c);
- break;
- }
- }
- if (inDQuote || inQuote)
- throw new ArgumentException("connectionString");
- if (name != null && name.Length > 0) {
- value = sb.ToString();
- userParameters [name.Trim()] = value.Trim();
- }
- return userParameters;
- }
- #endregion // Methods
- #region IDictionary Members
- public virtual bool IsFixedSize
- {
- get { return _dictionary.IsFixedSize; }
- }
- public virtual bool IsReadOnly
- {
- get { return _dictionary.IsReadOnly; }
- }
- public virtual ICollection Keys
- {
- get {
- return _dictionary.Keys;
- }
- }
- public virtual object this [object key] {
- get {
- if (!(key is String))
- throw new ArgumentException("key is not string");
- string skey = (string)key;
- skey = GetConnectionStringKey(skey);
- if (skey == null)
- return null;
- return _dictionary[skey];
- }
- set {
- if (!(key is String))
- throw new ArgumentException("key is not string");
- string skey = (string)key;
- skey = GetConnectionStringKey(skey);
- if (skey == null)
- skey = (string)key;
- _dictionary[skey] = value;
- }
- }
- public virtual ICollection Values
- {
- get { return _dictionary.Values; }
- }
- public virtual void Add (object key, object value)
- {
- _dictionary.Add ((string)key, (string)value);
- }
- public virtual void Clear ()
- {
- _dictionary.Clear ();
- }
- public virtual bool Contains (object key)
- {
- return _dictionary.Contains (key);
- }
- public virtual IDictionaryEnumerator GetEnumerator ()
- {
- return _dictionary.GetEnumerator ();
- }
- public virtual void Remove (object key)
- {
- _dictionary.Remove ((string)key);
- }
- #endregion // IDictionary Members
- #region IEnumerable Members
- IEnumerator IEnumerable.GetEnumerator ()
- {
- return this.GetEnumerator();
- }
- #endregion // IEnumerable Members
- #region ICollection Members
- public virtual bool IsSynchronized
- {
- get { return ((ICollection)_dictionary).IsSynchronized; }
- }
- public virtual int Count
- {
- get { return _dictionary.Count; }
- }
- public virtual void CopyTo (Array array, int index)
- {
- _dictionary.CopyTo (array, index);
- }
- public virtual object SyncRoot
- {
- get {return ((ICollection)_dictionary).SyncRoot; }
- }
- #endregion // ICollection Members
- }
- }
|