Code:
/ Net / Net / 3.5.50727.3053 / DEVDIV / depot / DevDiv / releases / whidbey / netfxsp / ndp / fx / src / Data / System / Data / Common / DbConnectionStringCommon.cs / 5 / 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
This book is available now!
Buy at Amazon US or
Buy at Amazon UK
- StylusPointPropertyInfoDefaults.cs
- DynamicEntity.cs
- BoundField.cs
- Int32CollectionConverter.cs
- PackageDigitalSignature.cs
- ConfigViewGenerator.cs
- FontStyle.cs
- StyleTypedPropertyAttribute.cs
- Ipv6Element.cs
- PropertyGrid.cs
- ObjectListCommandCollection.cs
- PkcsMisc.cs
- ToolStripRendererSwitcher.cs
- TypeUnloadedException.cs
- IteratorFilter.cs
- JournalEntry.cs
- ErrorFormatter.cs
- ApplySecurityAndSendAsyncResult.cs
- WbemException.cs
- FontDriver.cs
- SQLDecimalStorage.cs
- MenuCommand.cs
- OletxDependentTransaction.cs
- CodeLabeledStatement.cs
- DragStartedEventArgs.cs
- DbParameterHelper.cs
- FlowDocumentScrollViewer.cs
- SupportingTokenDuplexChannel.cs
- DataGridCell.cs
- WinEventHandler.cs
- TimeSpanValidator.cs
- CodeArrayIndexerExpression.cs
- WindowsToolbarItemAsMenuItem.cs
- TargetInvocationException.cs
- Char.cs
- GenericIdentity.cs
- InternalConfigSettingsFactory.cs
- RequestCachingSection.cs
- XmlSchemaComplexContent.cs
- QueryTaskGroupState.cs
- SqlComparer.cs
- FamilyTypefaceCollection.cs
- DocumentGridPage.cs
- PixelFormats.cs
- _SafeNetHandles.cs
- RulePatternOps.cs
- ValidatorCompatibilityHelper.cs
- XmlSchemaAttributeGroupRef.cs
- FixedDSBuilder.cs
- Decorator.cs
- CustomError.cs
- InkCanvasAutomationPeer.cs
- HoistedLocals.cs
- NullableBoolConverter.cs
- VirtualPathProvider.cs
- Resources.Designer.cs
- TraceProvider.cs
- LocatorPart.cs
- TrackingLocationCollection.cs
- DataColumnChangeEvent.cs
- MsmqTransportElement.cs
- XamlParser.cs
- DataSourceCache.cs
- TypeKeyValue.cs
- RectConverter.cs
- webclient.cs
- DecoderBestFitFallback.cs
- Geometry3D.cs
- log.cs
- RegexNode.cs
- WinInetCache.cs
- ProxyOperationRuntime.cs
- CompModSwitches.cs
- AutomationAttributeInfo.cs
- WindowInteractionStateTracker.cs
- DesignerCapabilities.cs
- NativeBuffer.cs
- LockCookie.cs
- OdbcTransaction.cs
- SortDescription.cs
- Animatable.cs
- RewritingValidator.cs
- StringUtil.cs
- CursorInteropHelper.cs
- TimeZoneNotFoundException.cs
- SQLDateTimeStorage.cs
- RoutedPropertyChangedEventArgs.cs
- ThicknessAnimation.cs
- XAMLParseException.cs
- RawKeyboardInputReport.cs
- ProfileModule.cs
- ExtenderControl.cs
- EventListenerClientSide.cs
- QuadraticEase.cs
- FileCodeGroup.cs
- PolicyConversionContext.cs
- SqlParameterizer.cs
- ScalarType.cs
- RawStylusInput.cs
- ResourcePermissionBaseEntry.cs