DbConnectionStringCommon.cs source code in C# .NET

Source code for the .NET framework in C#

                        

Code:

/ Dotnetfx_Win7_3.5.1 / Dotnetfx_Win7_3.5.1 / 3.5.1 / DEVDIV / depot / DevDiv / releases / whidbey / NetFXspW7 / ndp / fx / src / Data / System / Data / Common / DbConnectionStringCommon.cs / 1 / DbConnectionStringCommon.cs

                            //------------------------------------------------------------------------------ 
// 
//      Copyright (c) Microsoft Corporation.  All rights reserved.
// 
// [....] 
// [....]
//----------------------------------------------------------------------------- 
 
    using System;
    using System.Collections; 
    using System.Collections.Generic;
    using System.ComponentModel;
    using System.Data;
    using System.Data.Common; 
    using System.Diagnostics;
    using System.Globalization; 
    using System.Runtime.Serialization; 
    using System.Security.Permissions;
    using System.Text; 
    using System.Text.RegularExpressions;

namespace System.Data.Common {
 
/*
    internal sealed class NamedConnectionStringConverter : StringConverter { 
 
        public NamedConnectionStringConverter() {
        } 

        public override bool GetStandardValuesSupported(ITypeDescriptorContext context) {
            return true;
        } 

        public override bool GetStandardValuesExclusive(ITypeDescriptorContext context) { 
            // Although theoretically this could be true, some people may want to just type in a name 
            return false;
        } 

        public override StandardValuesCollection GetStandardValues(ITypeDescriptorContext context) {
            StandardValuesCollection standardValues = null;
            if (null != context) { 
                DbConnectionStringBuilder instance = (context.Instance as DbConnectionStringBuilder);
                if (null != instance) { 
                    string myProviderName = instance.GetType().Namespace; 

                    List myConnectionNames = new List(); 
                    foreach(System.Configuration.ConnectionStringSetting setting in System.Configuration.ConfigurationManager.ConnectionStrings) {
                        if (myProviderName.EndsWith(setting.ProviderName)) {
                            myConnectionNames.Add(setting.ConnectionName);
                        } 
                    }
                    standardValues = new StandardValuesCollection(myConnectionNames); 
                } 
            }
            return standardValues; 
        }
    }
*/
 
    internal class DbConnectionStringBuilderDescriptor : PropertyDescriptor {
        private Type _componentType; 
        private Type _propertyType; 
        private bool _isReadOnly;
        private bool _refreshOnChange; 

        internal DbConnectionStringBuilderDescriptor(string propertyName, Type componentType, Type propertyType, bool isReadOnly, Attribute[] attributes) : base(propertyName, attributes) {
            //Bid.Trace(" propertyName='%ls', propertyType='%ls'\n", propertyName, propertyType.Name);
            _componentType = componentType; 
            _propertyType = propertyType;
            _isReadOnly = isReadOnly; 
        } 

        internal bool RefreshOnChange { 
            get {
                return _refreshOnChange;
            }
            set { 
                _refreshOnChange = value;
            } 
        } 

        public override Type ComponentType { 
            get {
                return _componentType;
            }
        } 
        public override bool IsReadOnly {
            get { 
                return _isReadOnly; 
            }
        } 
        public override Type PropertyType {
            get {
                return _propertyType;
            } 
        }
        public override bool CanResetValue(object component) { 
            DbConnectionStringBuilder builder = (component as DbConnectionStringBuilder); 
            return ((null != builder) && builder.ShouldSerialize(DisplayName));
        } 
        public override object GetValue(object component) {
            DbConnectionStringBuilder builder = (component as DbConnectionStringBuilder);
            if (null != builder) {
                object value; 
                if (builder.TryGetValue(DisplayName, out value)) {
                    return value; 
                } 
            }
            return null; 
        }
        public override void ResetValue(object component) {
            DbConnectionStringBuilder builder = (component as DbConnectionStringBuilder);
            if (null != builder) { 
                builder.Remove(DisplayName);
 
                if (RefreshOnChange) { 
#if ORACLE
                    ((System.Data.OracleClient.OracleConnectionStringBuilder)builder).ClearPropertyDescriptors(); 
#else
                    builder.ClearPropertyDescriptors();
#endif
                } 
            }
        } 
        public override void SetValue(object component, object value) { 
            DbConnectionStringBuilder builder = (component as DbConnectionStringBuilder);
            if (null != builder) { 
                // via the editor, empty string does a defacto Reset
                if ((typeof(string) == PropertyType) && String.Empty.Equals(value)) {
                    value = null;
                } 
                builder[DisplayName] = value;
 
                if (RefreshOnChange) { 
#if ORACLE
                    ((System.Data.OracleClient.OracleConnectionStringBuilder)builder).ClearPropertyDescriptors(); 
#else
                    builder.ClearPropertyDescriptors();
#endif
                } 
            }
        } 
        public override bool ShouldSerializeValue(object component) { 
            DbConnectionStringBuilder builder = (component as DbConnectionStringBuilder);
            return ((null != builder) && builder.ShouldSerialize(DisplayName)); 
        }
    }

    [Serializable()] 
    internal sealed class ReadOnlyCollection : System.Collections.ICollection, ICollection {
        private T[] _items; 
 
        internal ReadOnlyCollection(T[] items) {
            _items = items; 
#if DEBUG
            for(int i = 0; i < items.Length; ++i) {
                Debug.Assert(null != items[i], "null item");
            } 
#endif
        } 
 
        public void CopyTo(T[] array, int arrayIndex) {
            Array.Copy(_items, 0, array, arrayIndex, _items.Length); 
        }

        void System.Collections.ICollection.CopyTo(Array array, int arrayIndex) {
            Array.Copy(_items, 0, array, arrayIndex, _items.Length); 
        }
 
 
        IEnumerator IEnumerable.GetEnumerator() {
            return new Enumerator(_items); 
        }

        public System.Collections.IEnumerator GetEnumerator() {
            return new Enumerator(_items); 
        }
 
        bool System.Collections.ICollection.IsSynchronized { 
            get { return false; }
        } 

        Object System.Collections.ICollection.SyncRoot {
            get { return _items; }
        } 

        bool ICollection.IsReadOnly { 
            get { return true;} 
        }
 
        void ICollection.Add(T value) {
            throw new NotSupportedException();
        }
 
        void ICollection.Clear() {
            throw new NotSupportedException(); 
        } 

        bool ICollection.Contains(T value) { 
            return Array.IndexOf(_items, value) >= 0;
        }

        bool ICollection.Remove(T value) { 
            throw new NotSupportedException();
        } 
 
        public int Count {
            get { return _items.Length; } 
        }

        [Serializable()]
        internal struct Enumerator : IEnumerator, System.Collections.IEnumerator { // based on List.Enumerator 
            private K[] _items;
            private int _index; 
 
            internal Enumerator(K[] items) {
                _items = items; 
                _index = -1;
            }

            public void Dispose() { 
            }
 
            public bool MoveNext() { 
                return (++_index < _items.Length);
            } 

            public K Current {
                get {
                    return _items[_index]; 
                }
            } 
 
            Object System.Collections.IEnumerator.Current {
                get { 
                    return _items[_index];
                }
            }
 
            void System.Collections.IEnumerator.Reset() {
                _index = -1; 
            } 
        }
    } 

    internal static class DbConnectionStringBuilderUtil {

        internal static bool ConvertToBoolean(object value) { 
            Debug.Assert(null != value, "ConvertToBoolean(null)");
            string svalue = (value as string); 
            if (null != svalue) { 
                if (StringComparer.OrdinalIgnoreCase.Equals(svalue, "true") || StringComparer.OrdinalIgnoreCase.Equals(svalue, "yes"))
                    return true; 
                else if (StringComparer.OrdinalIgnoreCase.Equals(svalue, "false") || StringComparer.OrdinalIgnoreCase.Equals(svalue, "no"))
                    return false;
                else {
                    string tmp = svalue.Trim();  // Remove leading & trailing white space. 
                    if (StringComparer.OrdinalIgnoreCase.Equals(tmp, "true") || StringComparer.OrdinalIgnoreCase.Equals(tmp, "yes"))
                        return true; 
                    else if (StringComparer.OrdinalIgnoreCase.Equals(tmp, "false") || StringComparer.OrdinalIgnoreCase.Equals(tmp, "no")) 
                        return false;
                } 
                return Boolean.Parse(svalue);
            }
            try {
                return ((IConvertible)value).ToBoolean(CultureInfo.InvariantCulture); 
            }
            catch(InvalidCastException e) { 
                throw ADP.ConvertFailed(value.GetType(), typeof(Boolean), e); 
            }
        } 

        internal static bool ConvertToIntegratedSecurity(object value) {
            Debug.Assert(null != value, "ConvertToIntegratedSecurity(null)");
            string svalue = (value as string); 
            if (null != svalue) {
                if (StringComparer.OrdinalIgnoreCase.Equals(svalue, "sspi") || StringComparer.OrdinalIgnoreCase.Equals(svalue, "true") || StringComparer.OrdinalIgnoreCase.Equals(svalue, "yes")) 
                    return true; 
                else if (StringComparer.OrdinalIgnoreCase.Equals(svalue, "false") || StringComparer.OrdinalIgnoreCase.Equals(svalue, "no"))
                    return false; 
                else {
                    string tmp = svalue.Trim();  // Remove leading & trailing white space.
                    if (StringComparer.OrdinalIgnoreCase.Equals(tmp, "sspi") || StringComparer.OrdinalIgnoreCase.Equals(tmp, "true") || StringComparer.OrdinalIgnoreCase.Equals(tmp, "yes"))
                        return true; 
                    else if (StringComparer.OrdinalIgnoreCase.Equals(tmp, "false") || StringComparer.OrdinalIgnoreCase.Equals(tmp, "no"))
                        return false; 
                } 
                return Boolean.Parse(svalue);
            } 
            try {
                return ((IConvertible)value).ToBoolean(CultureInfo.InvariantCulture);
            }
            catch(InvalidCastException e) { 
                throw ADP.ConvertFailed(value.GetType(), typeof(Boolean), e);
            } 
        } 

        internal static int ConvertToInt32(object value) { 
            try {
                return ((IConvertible)value).ToInt32(CultureInfo.InvariantCulture);
            }
            catch(InvalidCastException e) { 
                throw ADP.ConvertFailed(value.GetType(), typeof(Int32), e);
            } 
        } 

        internal static string ConvertToString(object value) { 
            try {
                return ((IConvertible)value).ToString(CultureInfo.InvariantCulture);
            }
            catch(InvalidCastException e) { 
                throw ADP.ConvertFailed(value.GetType(), typeof(String), e);
            } 
        } 
    }
 
    internal static class DbConnectionStringDefaults {
        // all
//        internal const string NamedConnection           = "";
 
        // Odbc
        internal const string Driver                    = ""; 
        internal const string Dsn                       = ""; 

        // OleDb 
        internal const bool   AdoNetPooler              = false;
        internal const string FileName                  = "";
        internal const int    OleDbServices             = ~(/*DBPROPVAL_OS_AGR_AFTERSESSION*/0x00000008 | /*DBPROPVAL_OS_CLIENTCURSOR*/0x00000004); // -13
        internal const string Provider                  = ""; 

        // OracleClient 
        internal const bool   Unicode                   = false; 
        internal const bool   OmitOracleConnectionName  = false;
 
        // SqlClient
        internal const string ApplicationName           = ".Net SqlClient Data Provider";
        internal const bool   AsynchronousProcessing    = false;
        internal const string AttachDBFilename          = ""; 
        internal const int    ConnectTimeout            = 15;
        internal const bool   ConnectionReset           = true; 
        internal const bool   ContextConnection         = false; 
        internal const string CurrentLanguage           = "";
        internal const string DataSource                = ""; 
        internal const bool   Encrypt                   = false;
        internal const bool   Enlist                    = true;
        internal const string FailoverPartner           = "";
        internal const string InitialCatalog            = ""; 
        internal const bool   IntegratedSecurity        = false;
        internal const int    LoadBalanceTimeout        = 0; // default of 0 means don't use 
        internal const bool   MultipleActiveResultSets  = false; 
        internal const int    MaxPoolSize               = 100;
        internal const int    MinPoolSize               = 0; 
        internal const string NetworkLibrary            = "";
        internal const int    PacketSize                = 8000;
        internal const string Password                  = "";
        internal const bool   PersistSecurityInfo       = false; 
        internal const bool   Pooling                   = true;
        internal const bool   TrustServerCertificate    = false; 
        internal const string TypeSystemVersion         = "Latest"; 
        internal const string UserID                    = "";
        internal const bool   UserInstance              = false; 
        internal const bool   Replication               = false;
        internal const string WorkstationID             = "";
        internal const string TransactionBinding        = "Implicit Unbind";
    } 

    internal static class DbConnectionOptionKeywords { 
        // Odbc 
        internal const string Driver                    = "driver";
        internal const string Pwd                       = "pwd"; 
        internal const string UID                       = "uid";

        // OleDb
        internal const string DataProvider              = "data provider"; 
        internal const string ExtendedProperties        = "extended properties";
        internal const string FileName                  = "file name"; 
        internal const string Provider                  = "provider"; 
        internal const string RemoteProvider            = "remote provider";
 
        // common keywords (OleDb, OracleClient, SqlClient)
        internal const string Password                  = "password";
        internal const string UserID                    = "user id";
    } 

    internal static class DbConnectionStringKeywords { 
        // all 
//        internal const string NamedConnection           = "Named Connection";
 
        // Odbc
        internal const string Driver                    = "Driver";
        internal const string Dsn                       = "Dsn";
        internal const string FileDsn                   = "FileDsn"; 
        internal const string SaveFile                  = "SaveFile";
 
        // OleDb 
        internal const string FileName                  = "File Name";
        internal const string OleDbServices             = "OLE DB Services"; 
        internal const string Provider                  = "Provider";

        // OracleClient
        internal const string Unicode                   = "Unicode"; 
        internal const string OmitOracleConnectionName  = "Omit Oracle Connection Name";
 
        // SqlClient 
        internal const string ApplicationName           = "Application Name";
        internal const string AsynchronousProcessing    = "Asynchronous Processing"; 
        internal const string AttachDBFilename          = "AttachDbFilename";
        internal const string ConnectTimeout            = "Connect Timeout";
        internal const string ConnectionReset           = "Connection Reset";
        internal const string ContextConnection         = "Context Connection"; 
        internal const string CurrentLanguage           = "Current Language";
        internal const string Encrypt                   = "Encrypt"; 
        internal const string FailoverPartner           = "Failover Partner"; 
        internal const string InitialCatalog            = "Initial Catalog";
        internal const string MultipleActiveResultSets  = "MultipleActiveResultSets"; 
        internal const string NetworkLibrary            = "Network Library";
        internal const string PacketSize                = "Packet Size";
        internal const string Replication               = "Replication";
        internal const string TransactionBinding        = "Transaction Binding"; 
        internal const string TrustServerCertificate    = "TrustServerCertificate";
        internal const string TypeSystemVersion         = "Type System Version"; 
        internal const string UserInstance              = "User Instance"; 
        internal const string WorkstationID             = "Workstation ID";
 
        // common keywords (OleDb, OracleClient, SqlClient)
        internal const string DataSource                = "Data Source";
        internal const string IntegratedSecurity        = "Integrated Security";
        internal const string Password                  = "Password"; 
        internal const string PersistSecurityInfo       = "Persist Security Info";
        internal const string UserID                    = "User ID"; 
 
        // managed pooling (OracleClient, SqlClient)
        internal const string Enlist                    = "Enlist"; 
        internal const string LoadBalanceTimeout        = "Load Balance Timeout";
        internal const string MaxPoolSize               = "Max Pool Size";
        internal const string Pooling                   = "Pooling";
        internal const string MinPoolSize               = "Min Pool Size"; 
    }
 
    internal static class DbConnectionStringSynonyms { 
        //internal const string AsynchronousProcessing = Async;
        internal const string Async                  = "async"; 

        //internal const string ApplicationName        = APP;
        internal const string APP                    = "app";
 
        //internal const string AttachDBFilename       = EXTENDEDPROPERTIES+","+INITIALFILENAME;
        internal const string EXTENDEDPROPERTIES     = "extended properties"; 
        internal const string INITIALFILENAME        = "initial file name"; 

        //internal const string ConnectTimeout         = CONNECTIONTIMEOUT+","+TIMEOUT; 
        internal const string CONNECTIONTIMEOUT      = "connection timeout";
        internal const string TIMEOUT                = "timeout";

        //internal const string CurrentLanguage        = LANGUAGE; 
        internal const string LANGUAGE               = "language";
 
        //internal const string OraDataSource          = SERVER; 
        //internal const string SqlDataSource          = ADDR+","+ADDRESS+","+SERVER+","+NETWORKADDRESS;
        internal const string ADDR                   = "addr"; 
        internal const string ADDRESS                = "address";
        internal const string SERVER                 = "server";
        internal const string NETWORKADDRESS         = "network address";
 
        //internal const string InitialCatalog         = DATABASE;
        internal const string DATABASE               = "database"; 
 
        //internal const string IntegratedSecurity     = TRUSTEDCONNECTION;
        internal const string TRUSTEDCONNECTION      = "trusted_connection"; // underscore introduced in everett 

        //internal const string LoadBalanceTimeout     = ConnectionLifetime;
        internal const string ConnectionLifetime     = "connection lifetime";
 
        //internal const string NetworkLibrary         = NET+","+NETWORK;
        internal const string NET                    = "net"; 
        internal const string NETWORK                = "network"; 

        internal const string WorkaroundOracleBug914652 = "Workaround Oracle Bug 914652"; 

        //internal const string Password               = Pwd;
        internal const string Pwd                    = "pwd";
 
        //internal const string PersistSecurityInfo    = PERSISTSECURITYINFO;
        internal const string PERSISTSECURITYINFO    = "persistsecurityinfo"; 
 
        //internal const string UserID                 = UID+","+User;
        internal const string UID                    = "uid"; 
        internal const string User                   = "user";

        //internal const string WorkstationID          = WSID;
        internal const string WSID                   = "wsid"; 
    }
} 

// File provided for Reference Use Only by Microsoft Corporation (c) 2007.
//------------------------------------------------------------------------------ 
// 
//      Copyright (c) Microsoft Corporation.  All rights reserved.
// 
// [....] 
// [....]
//----------------------------------------------------------------------------- 
 
    using System;
    using System.Collections; 
    using System.Collections.Generic;
    using System.ComponentModel;
    using System.Data;
    using System.Data.Common; 
    using System.Diagnostics;
    using System.Globalization; 
    using System.Runtime.Serialization; 
    using System.Security.Permissions;
    using System.Text; 
    using System.Text.RegularExpressions;

namespace System.Data.Common {
 
/*
    internal sealed class NamedConnectionStringConverter : StringConverter { 
 
        public NamedConnectionStringConverter() {
        } 

        public override bool GetStandardValuesSupported(ITypeDescriptorContext context) {
            return true;
        } 

        public override bool GetStandardValuesExclusive(ITypeDescriptorContext context) { 
            // Although theoretically this could be true, some people may want to just type in a name 
            return false;
        } 

        public override StandardValuesCollection GetStandardValues(ITypeDescriptorContext context) {
            StandardValuesCollection standardValues = null;
            if (null != context) { 
                DbConnectionStringBuilder instance = (context.Instance as DbConnectionStringBuilder);
                if (null != instance) { 
                    string myProviderName = instance.GetType().Namespace; 

                    List myConnectionNames = new List(); 
                    foreach(System.Configuration.ConnectionStringSetting setting in System.Configuration.ConfigurationManager.ConnectionStrings) {
                        if (myProviderName.EndsWith(setting.ProviderName)) {
                            myConnectionNames.Add(setting.ConnectionName);
                        } 
                    }
                    standardValues = new StandardValuesCollection(myConnectionNames); 
                } 
            }
            return standardValues; 
        }
    }
*/
 
    internal class DbConnectionStringBuilderDescriptor : PropertyDescriptor {
        private Type _componentType; 
        private Type _propertyType; 
        private bool _isReadOnly;
        private bool _refreshOnChange; 

        internal DbConnectionStringBuilderDescriptor(string propertyName, Type componentType, Type propertyType, bool isReadOnly, Attribute[] attributes) : base(propertyName, attributes) {
            //Bid.Trace(" propertyName='%ls', propertyType='%ls'\n", propertyName, propertyType.Name);
            _componentType = componentType; 
            _propertyType = propertyType;
            _isReadOnly = isReadOnly; 
        } 

        internal bool RefreshOnChange { 
            get {
                return _refreshOnChange;
            }
            set { 
                _refreshOnChange = value;
            } 
        } 

        public override Type ComponentType { 
            get {
                return _componentType;
            }
        } 
        public override bool IsReadOnly {
            get { 
                return _isReadOnly; 
            }
        } 
        public override Type PropertyType {
            get {
                return _propertyType;
            } 
        }
        public override bool CanResetValue(object component) { 
            DbConnectionStringBuilder builder = (component as DbConnectionStringBuilder); 
            return ((null != builder) && builder.ShouldSerialize(DisplayName));
        } 
        public override object GetValue(object component) {
            DbConnectionStringBuilder builder = (component as DbConnectionStringBuilder);
            if (null != builder) {
                object value; 
                if (builder.TryGetValue(DisplayName, out value)) {
                    return value; 
                } 
            }
            return null; 
        }
        public override void ResetValue(object component) {
            DbConnectionStringBuilder builder = (component as DbConnectionStringBuilder);
            if (null != builder) { 
                builder.Remove(DisplayName);
 
                if (RefreshOnChange) { 
#if ORACLE
                    ((System.Data.OracleClient.OracleConnectionStringBuilder)builder).ClearPropertyDescriptors(); 
#else
                    builder.ClearPropertyDescriptors();
#endif
                } 
            }
        } 
        public override void SetValue(object component, object value) { 
            DbConnectionStringBuilder builder = (component as DbConnectionStringBuilder);
            if (null != builder) { 
                // via the editor, empty string does a defacto Reset
                if ((typeof(string) == PropertyType) && String.Empty.Equals(value)) {
                    value = null;
                } 
                builder[DisplayName] = value;
 
                if (RefreshOnChange) { 
#if ORACLE
                    ((System.Data.OracleClient.OracleConnectionStringBuilder)builder).ClearPropertyDescriptors(); 
#else
                    builder.ClearPropertyDescriptors();
#endif
                } 
            }
        } 
        public override bool ShouldSerializeValue(object component) { 
            DbConnectionStringBuilder builder = (component as DbConnectionStringBuilder);
            return ((null != builder) && builder.ShouldSerialize(DisplayName)); 
        }
    }

    [Serializable()] 
    internal sealed class ReadOnlyCollection : System.Collections.ICollection, ICollection {
        private T[] _items; 
 
        internal ReadOnlyCollection(T[] items) {
            _items = items; 
#if DEBUG
            for(int i = 0; i < items.Length; ++i) {
                Debug.Assert(null != items[i], "null item");
            } 
#endif
        } 
 
        public void CopyTo(T[] array, int arrayIndex) {
            Array.Copy(_items, 0, array, arrayIndex, _items.Length); 
        }

        void System.Collections.ICollection.CopyTo(Array array, int arrayIndex) {
            Array.Copy(_items, 0, array, arrayIndex, _items.Length); 
        }
 
 
        IEnumerator IEnumerable.GetEnumerator() {
            return new Enumerator(_items); 
        }

        public System.Collections.IEnumerator GetEnumerator() {
            return new Enumerator(_items); 
        }
 
        bool System.Collections.ICollection.IsSynchronized { 
            get { return false; }
        } 

        Object System.Collections.ICollection.SyncRoot {
            get { return _items; }
        } 

        bool ICollection.IsReadOnly { 
            get { return true;} 
        }
 
        void ICollection.Add(T value) {
            throw new NotSupportedException();
        }
 
        void ICollection.Clear() {
            throw new NotSupportedException(); 
        } 

        bool ICollection.Contains(T value) { 
            return Array.IndexOf(_items, value) >= 0;
        }

        bool ICollection.Remove(T value) { 
            throw new NotSupportedException();
        } 
 
        public int Count {
            get { return _items.Length; } 
        }

        [Serializable()]
        internal struct Enumerator : IEnumerator, System.Collections.IEnumerator { // based on List.Enumerator 
            private K[] _items;
            private int _index; 
 
            internal Enumerator(K[] items) {
                _items = items; 
                _index = -1;
            }

            public void Dispose() { 
            }
 
            public bool MoveNext() { 
                return (++_index < _items.Length);
            } 

            public K Current {
                get {
                    return _items[_index]; 
                }
            } 
 
            Object System.Collections.IEnumerator.Current {
                get { 
                    return _items[_index];
                }
            }
 
            void System.Collections.IEnumerator.Reset() {
                _index = -1; 
            } 
        }
    } 

    internal static class DbConnectionStringBuilderUtil {

        internal static bool ConvertToBoolean(object value) { 
            Debug.Assert(null != value, "ConvertToBoolean(null)");
            string svalue = (value as string); 
            if (null != svalue) { 
                if (StringComparer.OrdinalIgnoreCase.Equals(svalue, "true") || StringComparer.OrdinalIgnoreCase.Equals(svalue, "yes"))
                    return true; 
                else if (StringComparer.OrdinalIgnoreCase.Equals(svalue, "false") || StringComparer.OrdinalIgnoreCase.Equals(svalue, "no"))
                    return false;
                else {
                    string tmp = svalue.Trim();  // Remove leading & trailing white space. 
                    if (StringComparer.OrdinalIgnoreCase.Equals(tmp, "true") || StringComparer.OrdinalIgnoreCase.Equals(tmp, "yes"))
                        return true; 
                    else if (StringComparer.OrdinalIgnoreCase.Equals(tmp, "false") || StringComparer.OrdinalIgnoreCase.Equals(tmp, "no")) 
                        return false;
                } 
                return Boolean.Parse(svalue);
            }
            try {
                return ((IConvertible)value).ToBoolean(CultureInfo.InvariantCulture); 
            }
            catch(InvalidCastException e) { 
                throw ADP.ConvertFailed(value.GetType(), typeof(Boolean), e); 
            }
        } 

        internal static bool ConvertToIntegratedSecurity(object value) {
            Debug.Assert(null != value, "ConvertToIntegratedSecurity(null)");
            string svalue = (value as string); 
            if (null != svalue) {
                if (StringComparer.OrdinalIgnoreCase.Equals(svalue, "sspi") || StringComparer.OrdinalIgnoreCase.Equals(svalue, "true") || StringComparer.OrdinalIgnoreCase.Equals(svalue, "yes")) 
                    return true; 
                else if (StringComparer.OrdinalIgnoreCase.Equals(svalue, "false") || StringComparer.OrdinalIgnoreCase.Equals(svalue, "no"))
                    return false; 
                else {
                    string tmp = svalue.Trim();  // Remove leading & trailing white space.
                    if (StringComparer.OrdinalIgnoreCase.Equals(tmp, "sspi") || StringComparer.OrdinalIgnoreCase.Equals(tmp, "true") || StringComparer.OrdinalIgnoreCase.Equals(tmp, "yes"))
                        return true; 
                    else if (StringComparer.OrdinalIgnoreCase.Equals(tmp, "false") || StringComparer.OrdinalIgnoreCase.Equals(tmp, "no"))
                        return false; 
                } 
                return Boolean.Parse(svalue);
            } 
            try {
                return ((IConvertible)value).ToBoolean(CultureInfo.InvariantCulture);
            }
            catch(InvalidCastException e) { 
                throw ADP.ConvertFailed(value.GetType(), typeof(Boolean), e);
            } 
        } 

        internal static int ConvertToInt32(object value) { 
            try {
                return ((IConvertible)value).ToInt32(CultureInfo.InvariantCulture);
            }
            catch(InvalidCastException e) { 
                throw ADP.ConvertFailed(value.GetType(), typeof(Int32), e);
            } 
        } 

        internal static string ConvertToString(object value) { 
            try {
                return ((IConvertible)value).ToString(CultureInfo.InvariantCulture);
            }
            catch(InvalidCastException e) { 
                throw ADP.ConvertFailed(value.GetType(), typeof(String), e);
            } 
        } 
    }
 
    internal static class DbConnectionStringDefaults {
        // all
//        internal const string NamedConnection           = "";
 
        // Odbc
        internal const string Driver                    = ""; 
        internal const string Dsn                       = ""; 

        // OleDb 
        internal const bool   AdoNetPooler              = false;
        internal const string FileName                  = "";
        internal const int    OleDbServices             = ~(/*DBPROPVAL_OS_AGR_AFTERSESSION*/0x00000008 | /*DBPROPVAL_OS_CLIENTCURSOR*/0x00000004); // -13
        internal const string Provider                  = ""; 

        // OracleClient 
        internal const bool   Unicode                   = false; 
        internal const bool   OmitOracleConnectionName  = false;
 
        // SqlClient
        internal const string ApplicationName           = ".Net SqlClient Data Provider";
        internal const bool   AsynchronousProcessing    = false;
        internal const string AttachDBFilename          = ""; 
        internal const int    ConnectTimeout            = 15;
        internal const bool   ConnectionReset           = true; 
        internal const bool   ContextConnection         = false; 
        internal const string CurrentLanguage           = "";
        internal const string DataSource                = ""; 
        internal const bool   Encrypt                   = false;
        internal const bool   Enlist                    = true;
        internal const string FailoverPartner           = "";
        internal const string InitialCatalog            = ""; 
        internal const bool   IntegratedSecurity        = false;
        internal const int    LoadBalanceTimeout        = 0; // default of 0 means don't use 
        internal const bool   MultipleActiveResultSets  = false; 
        internal const int    MaxPoolSize               = 100;
        internal const int    MinPoolSize               = 0; 
        internal const string NetworkLibrary            = "";
        internal const int    PacketSize                = 8000;
        internal const string Password                  = "";
        internal const bool   PersistSecurityInfo       = false; 
        internal const bool   Pooling                   = true;
        internal const bool   TrustServerCertificate    = false; 
        internal const string TypeSystemVersion         = "Latest"; 
        internal const string UserID                    = "";
        internal const bool   UserInstance              = false; 
        internal const bool   Replication               = false;
        internal const string WorkstationID             = "";
        internal const string TransactionBinding        = "Implicit Unbind";
    } 

    internal static class DbConnectionOptionKeywords { 
        // Odbc 
        internal const string Driver                    = "driver";
        internal const string Pwd                       = "pwd"; 
        internal const string UID                       = "uid";

        // OleDb
        internal const string DataProvider              = "data provider"; 
        internal const string ExtendedProperties        = "extended properties";
        internal const string FileName                  = "file name"; 
        internal const string Provider                  = "provider"; 
        internal const string RemoteProvider            = "remote provider";
 
        // common keywords (OleDb, OracleClient, SqlClient)
        internal const string Password                  = "password";
        internal const string UserID                    = "user id";
    } 

    internal static class DbConnectionStringKeywords { 
        // all 
//        internal const string NamedConnection           = "Named Connection";
 
        // Odbc
        internal const string Driver                    = "Driver";
        internal const string Dsn                       = "Dsn";
        internal const string FileDsn                   = "FileDsn"; 
        internal const string SaveFile                  = "SaveFile";
 
        // OleDb 
        internal const string FileName                  = "File Name";
        internal const string OleDbServices             = "OLE DB Services"; 
        internal const string Provider                  = "Provider";

        // OracleClient
        internal const string Unicode                   = "Unicode"; 
        internal const string OmitOracleConnectionName  = "Omit Oracle Connection Name";
 
        // SqlClient 
        internal const string ApplicationName           = "Application Name";
        internal const string AsynchronousProcessing    = "Asynchronous Processing"; 
        internal const string AttachDBFilename          = "AttachDbFilename";
        internal const string ConnectTimeout            = "Connect Timeout";
        internal const string ConnectionReset           = "Connection Reset";
        internal const string ContextConnection         = "Context Connection"; 
        internal const string CurrentLanguage           = "Current Language";
        internal const string Encrypt                   = "Encrypt"; 
        internal const string FailoverPartner           = "Failover Partner"; 
        internal const string InitialCatalog            = "Initial Catalog";
        internal const string MultipleActiveResultSets  = "MultipleActiveResultSets"; 
        internal const string NetworkLibrary            = "Network Library";
        internal const string PacketSize                = "Packet Size";
        internal const string Replication               = "Replication";
        internal const string TransactionBinding        = "Transaction Binding"; 
        internal const string TrustServerCertificate    = "TrustServerCertificate";
        internal const string TypeSystemVersion         = "Type System Version"; 
        internal const string UserInstance              = "User Instance"; 
        internal const string WorkstationID             = "Workstation ID";
 
        // common keywords (OleDb, OracleClient, SqlClient)
        internal const string DataSource                = "Data Source";
        internal const string IntegratedSecurity        = "Integrated Security";
        internal const string Password                  = "Password"; 
        internal const string PersistSecurityInfo       = "Persist Security Info";
        internal const string UserID                    = "User ID"; 
 
        // managed pooling (OracleClient, SqlClient)
        internal const string Enlist                    = "Enlist"; 
        internal const string LoadBalanceTimeout        = "Load Balance Timeout";
        internal const string MaxPoolSize               = "Max Pool Size";
        internal const string Pooling                   = "Pooling";
        internal const string MinPoolSize               = "Min Pool Size"; 
    }
 
    internal static class DbConnectionStringSynonyms { 
        //internal const string AsynchronousProcessing = Async;
        internal const string Async                  = "async"; 

        //internal const string ApplicationName        = APP;
        internal const string APP                    = "app";
 
        //internal const string AttachDBFilename       = EXTENDEDPROPERTIES+","+INITIALFILENAME;
        internal const string EXTENDEDPROPERTIES     = "extended properties"; 
        internal const string INITIALFILENAME        = "initial file name"; 

        //internal const string ConnectTimeout         = CONNECTIONTIMEOUT+","+TIMEOUT; 
        internal const string CONNECTIONTIMEOUT      = "connection timeout";
        internal const string TIMEOUT                = "timeout";

        //internal const string CurrentLanguage        = LANGUAGE; 
        internal const string LANGUAGE               = "language";
 
        //internal const string OraDataSource          = SERVER; 
        //internal const string SqlDataSource          = ADDR+","+ADDRESS+","+SERVER+","+NETWORKADDRESS;
        internal const string ADDR                   = "addr"; 
        internal const string ADDRESS                = "address";
        internal const string SERVER                 = "server";
        internal const string NETWORKADDRESS         = "network address";
 
        //internal const string InitialCatalog         = DATABASE;
        internal const string DATABASE               = "database"; 
 
        //internal const string IntegratedSecurity     = TRUSTEDCONNECTION;
        internal const string TRUSTEDCONNECTION      = "trusted_connection"; // underscore introduced in everett 

        //internal const string LoadBalanceTimeout     = ConnectionLifetime;
        internal const string ConnectionLifetime     = "connection lifetime";
 
        //internal const string NetworkLibrary         = NET+","+NETWORK;
        internal const string NET                    = "net"; 
        internal const string NETWORK                = "network"; 

        internal const string WorkaroundOracleBug914652 = "Workaround Oracle Bug 914652"; 

        //internal const string Password               = Pwd;
        internal const string Pwd                    = "pwd";
 
        //internal const string PersistSecurityInfo    = PERSISTSECURITYINFO;
        internal const string PERSISTSECURITYINFO    = "persistsecurityinfo"; 
 
        //internal const string UserID                 = UID+","+User;
        internal const string UID                    = "uid"; 
        internal const string User                   = "user";

        //internal const string WorkstationID          = WSID;
        internal const string WSID                   = "wsid"; 
    }
} 

// File provided for Reference Use Only by Microsoft Corporation (c) 2007.

                        

Link Menu

Network programming in C#, Network Programming in VB.NET, Network Programming in .NET
This book is available now!
Buy at Amazon US or
Buy at Amazon UK