public void Initialize(string connectionString)
{
var parser = new DbConnectionStringBuilder {ConnectionString = connectionString};
var fileName = parser.ContainsKey("Filename")
? parser["Filename"].ToString()
: Path.Combine(Directory.GetCurrentDirectory(), "PlayPass.log");
var appendMode = !parser.ContainsKey("Append") || (parser["Append"].ToString() == "1");
_file = new StreamWriter(fileName, appendMode) {AutoFlush = true};
}
protected void CheckAssertions(string connectionString)
{
DbConnectionStringBuilder dbConnection = new DbConnectionStringBuilder { ConnectionString = connectionString };
foreach (ConnectionStringSetting setting in StringSettings)
{
if (dbConnection.ContainsKey(setting.SettingName))
{
AssertState.Equal(setting.ExpectedValue, dbConnection[setting.SettingName].ToString());
}
else
{
throw new AssertionException(string.Format("Connection String setting [{0}] not found", setting.SettingName));
}
}
if (dbConnection.Keys != null)
AssertState.Equal(StringSettings.Count, dbConnection.Keys.Count);
else
{
throw new AssertionException("No StringSetting values were found");
}
if (CheckConnectivity)
using (SqlConnection sqlConnection = (new SqlConnection(connectionString)))
sqlConnection.Open();
}
/// <summary>
/// Replaces any existing 'enlist' parameter in the connection string
/// with a value indicating that manual enlist is necessary.
/// </summary>
/// <remarks>
/// ODP.NET supports 3 values for 'enlist'; 'true', 'false' and 'dynamic'.
/// 'dynamic' effectively works the same as 'false' in System.Data.OracleClient.
/// </remarks>
protected override void ReplaceEnlistInConnectionString(DbConnectionStringBuilder dbConnectionStringBuilder)
{
if (dbConnectionStringBuilder.ContainsKey("enlist"))
dbConnectionStringBuilder.Remove("enlist");
dbConnectionStringBuilder.Add("enlist", "dynamic");
}
private static string GetDataSourceFilePath(DbConnectionStringBuilder builder, string connectionString)
{
builder.ConnectionString = connectionString;
if (!builder.ContainsKey("Data Source"))
{
throw new ArgumentException("A 'Data Source' parameter was expected in the supplied connection string, but it was not found.");
}
return ConnectionStringHelper.ResolveDataSourceFilePath(builder["Data Source"].ToString());
}
public IDbConnection Get(string connectionString)
{
var csb = new DbConnectionStringBuilder();
csb.ConnectionString = connectionString;
string providerName = string.Empty;
if (csb.ContainsKey("Provider"))
providerName = InterpretProviderName(csb["Provider"].ToString());
if (string.IsNullOrEmpty(providerName) && csb.ContainsKey("Driver"))
providerName= "Odbc";
if (string.IsNullOrEmpty(providerName))
providerName="SqlClient";
if (string.IsNullOrEmpty(providerName))
throw new ArgumentException(string.Format("No provider found for connectionString '{0}'", connectionString));
return Get(providerName, connectionString);
}
/// <summary>
/// Extracts the provider from the connection string or uses the default.
/// </summary>
/// <param name="csb">The DbConnectionStringBuilder object to use.</param>
/// <returns>the string type of the provider.</returns>
private static string GetProvider(DbConnectionStringBuilder csb)
{
string provider = "System.Data.SqlClient"; // default factory provider
if (csb.ContainsKey("provider"))
{
provider = csb["provider"].ToString();
csb.Remove("provider");
}
return provider;
}
public void CanUploadFileToRootDirUsingProperties()
{
using (var file = new DummyFile(1024 * 1024 * 3))
{
var csb = new DbConnectionStringBuilder { ConnectionString = Cs };
Sftp.Host = csb["host"] as string;
Sftp.Username = csb["username"] as string;
Sftp.Password = csb["password"] as string;
Sftp.Hostkey = csb["hostkey"] as string;
Sftp.Port = csb.ContainsKey("port") ? csb["port"] as string : string.Empty;
Sftp.UploadFile(file.FileInfo.FullName, true);
}
}
/// <summary>
/// Initializes the Queue List with custom settings
/// </summary>
public void Initialize(string connectionString)
{
var parser = new DbConnectionStringBuilder {ConnectionString = connectionString};
if (parser.ContainsKey("Data Source"))
_skipFilePath = parser["Data Source"].ToString();
else
{
var mediaStorageLocation = PlayOnSettings.GetMediaStorageLocation();
if (mediaStorageLocation == "")
throw new Exception("Unable to find PlayLater's Media Storage Location");
_skipFilePath = mediaStorageLocation;
}
if (!Directory.Exists(_skipFilePath))
throw new Exception(String.Format("Queue List data path does not exists: {0}", _skipFilePath));
}
protected DynamicModel(DbConnectionStringBuilder connectionStringBuilder, string tableName = "",
string primaryKeyField = "", string descriptorField = "")
{
TableName = tableName == "" ? this.GetType().Name : tableName;
PrimaryKeyField = string.IsNullOrEmpty(primaryKeyField) ? "ID" : primaryKeyField;
DescriptorField = descriptorField;
string _providerName =
connectionStringBuilder.ContainsKey("ProviderName")
? (string) connectionStringBuilder["ProviderName"]
: "System.Data.SqlClient";
_factory = DbProviderFactories.GetFactory(_providerName);
ConnectionString = connectionStringBuilder.ConnectionString;
}
public static IQueueList GetQueueList(string connectionString)
{
var parser = new DbConnectionStringBuilder {ConnectionString = connectionString};
if (!parser.ContainsKey("Provider"))
throw new Exception("Queue List Provider Type is not specified");
var providerType = parser["Provider"].ToString().ToUpper();
if (!Classes.ContainsKey(providerType))
throw new Exception(String.Format("Unregistered Queue List Provider Type: {0}", providerType));
var type = Classes[providerType];
var instance = (IQueueList) Activator.CreateInstance(type);
instance.Initialize(connectionString);
return instance;
}
public void CanCreateConnection()
{
var provider = new MicrOrmConnectionProvider(DbUtility.ConnectionStringName);
var connection = provider.CreateConnection();
Assert.NotNull(connection);
Assert.AreEqual(ConnectionState.Closed, connection.State);
var connectionStringActual = new DbConnectionStringBuilder {ConnectionString = connection.ConnectionString};
foreach (string key in provider.ConnectionString.Keys)
{
Assert.True(connectionStringActual.ContainsKey(key));
Assert.AreEqual(provider.ConnectionString[key], connectionStringActual[key]);
}
}
public static ILogger GetLogger(string connectionString, bool debugMode, bool verboseMode)
{
var parser = new DbConnectionStringBuilder {ConnectionString = connectionString};
if (!parser.ContainsKey("Provider"))
throw new Exception("Logger Provider Type is not specified");
var providerType = parser["Provider"].ToString().ToUpper();
if (!Classes.ContainsKey(providerType))
throw new Exception(String.Format("Unregistered Logger Provider Type: {0}", providerType));
var type = Classes[providerType];
var instance = (ILogger) Activator.CreateInstance(type);
instance.DebugMode = debugMode;
instance.VerboseMode = verboseMode;
instance.Initialize(connectionString);
return instance;
}
public static string ExtractSchemaName(this string connectionString, out string schemaName)
{
const string key = "Queue Schema";
var connectionStringParser = new DbConnectionStringBuilder
{
ConnectionString = connectionString
};
if (connectionStringParser.ContainsKey(key))
{
schemaName = (string) connectionStringParser[key];
connectionStringParser.Remove(key);
connectionString = connectionStringParser.ConnectionString;
}
else
{
schemaName = null;
}
return connectionString;
}
/// <summary>
/// Gets the command timeout (in seconds) from
/// the connection string (if the CommandTimeout key is specified).
/// </summary>
private static int? GetCommandTimeout(DbConnectionStringBuilder csb)
{
const string key = "CommandTimeout";
int? value = null;
if (csb.ContainsKey(key))
{
int iValue;
if (Int32.TryParse(csb[key].ToString(), out iValue))
{
// ignore negative values
if (iValue >= 0)
{
value = iValue;
}
}
csb.Remove(key);
}
return value;
}
/// <summary>
/// Initialize the Connection Parameters using the Connection String Settings
/// </summary>
/// <param name="settings"></param>
public void ReadConnectionParameters(ConnectionStringSettings settings)
{
var connectionString = new DbConnectionStringBuilder { ConnectionString = settings.ConnectionString };
if (connectionString.ContainsKey("Database"))
{
DatabaseName = (string)connectionString["Database"];
}
if (connectionString.ContainsKey("DriverClass"))
{
Connection_DriverClass = (string)connectionString["DriverClass"];
connectionString.Remove("DriverClass");
}
else
throw new ConnectionElementNotFoundException("DriverClass");
if (connectionString.ContainsKey("Dialect"))
{
Dialect = (string)connectionString["Dialect"];
connectionString.Remove("Dialect");
}
else
throw new ConnectionElementNotFoundException("Dialect");
if (connectionString.ContainsKey("proxyfactory.factory_class"))
{
ProxyFactoryClass = (string)connectionString["proxyfactory.factory_class"];
connectionString.Remove("proxyfactory.factory_class");
}
if (connectionString.ContainsKey("TablePrefix"))
{
TablePrefix = (string)connectionString["TablePrefix"];
connectionString.Remove("TablePrefix");
}
if (connectionString.ContainsKey("show_sql"))
{
ShowSql = (string)connectionString["NHibernateInterceptor"] == "true";
connectionString.Remove("show_sql");
}
if (connectionString.ContainsKey("NHibernateInterceptor"))
{
Interceptor = (string)connectionString["NHibernateInterceptor"];
connectionString.Remove("NHibernateInterceptor");
}
if (connectionString.ContainsKey("CreatedOn"))
{
FieldCreatedOn = (string)connectionString["CreatedOn"];
connectionString.Remove("CreatedOn");
}
if (connectionString.ContainsKey("UpdatedOn"))
{
FieldUpdatedOn = (string)connectionString["UpdatedOn"];
connectionString.Remove("UpdatedOn");
}
if (connectionString.ContainsKey("CreatedBy"))
{
FieldCreatedBy = (string)connectionString["CreatedBy"];
connectionString.Remove("CreatedBy");
}
if (connectionString.ContainsKey("UpdatedBy"))
{
FieldUpdatedBy = (string)connectionString["UpdatedBy"];
connectionString.Remove("UpdatedBy");
}
Connection_ConnectionString = connectionString.ConnectionString;
}
internal static string InjectEFAttributesIntoConnectionString(string sourceConnectionString, string providerInvariantName)
{
// if the provider connection string's provider property is "System.Data.SqlClient" then add the
// MARS attribute (value is true if SQL Server version >= 9, false otherwise). Also add the App
// attribute (with fixed value EntityFramework) - which is useful for statistics on server.
if (!string.Equals(providerInvariantName, SqlClientProviderName, StringComparison.Ordinal))
{
return sourceConnectionString;
}
var configFileConnectionBuilder = new DbConnectionStringBuilder();
try
{
configFileConnectionBuilder.ConnectionString = sourceConnectionString;
}
catch (ArgumentException)
{
return sourceConnectionString;
}
// add MARS property if it does not already exist
object marsValue;
if (!configFileConnectionBuilder.TryGetValue(XmlAttrNameMultipleActiveResultSets, out marsValue))
{
configFileConnectionBuilder[XmlAttrNameMultipleActiveResultSets] = true.ToString();
}
// add App attribute if neither App nor Application Name property is already set
if (!configFileConnectionBuilder.ContainsKey(ProviderConnectionStringPropertyNameApp)
&& !configFileConnectionBuilder.ContainsKey(ProviderConnectionStringPropertyNameApplicationName))
{
// note: fixed value so no localization;
configFileConnectionBuilder[ProviderConnectionStringPropertyNameApp] = "EntityFramework";
}
return configFileConnectionBuilder.ConnectionString;
}
private static void SetDataHelperNamesLegacyConnectionString(DbConnectionStringBuilder connectionStringBuilder)
{
// get the data layer type and parse it
var datalayerType = String.Empty;
if (connectionStringBuilder.ContainsKey(ConnectionStringDataLayerIdentifier))
{
datalayerType = connectionStringBuilder[ConnectionStringDataLayerIdentifier].ToString();
connectionStringBuilder.Remove(ConnectionStringDataLayerIdentifier);
}
_connectionString = connectionStringBuilder.ConnectionString;
var datalayerTypeParts = datalayerType.Split(",".ToCharArray());
_dataHelperTypeName = datalayerTypeParts[0].Trim();
_dataHelperAssemblyName = datalayerTypeParts.Length < 2
? string.Empty
: datalayerTypeParts[1].Trim();
if (datalayerTypeParts.Length > 2 || (_dataHelperTypeName.Length == 0 && _dataHelperAssemblyName.Length > 0))
throw new ArgumentException("Illegal format of data layer property. Should be 'DataLayer = Full_Type_Name [, Assembly_Name]'.", "connectionString");
}
private static DbConnection GetConnection(string connectionString)
{
string providerName = null;
var csb = new DbConnectionStringBuilder { ConnectionString = connectionString };
if (csb.ContainsKey("provider"))
{
providerName = csb["provider"].ToString();
}
else
{
var css = ConfigurationManager.ConnectionStrings.Cast<ConnectionStringSettings>().FirstOrDefault(x => string.Equals(x.ConnectionString, connectionString, StringComparison.OrdinalIgnoreCase));
if (css != null) providerName = css.ProviderName;
}
if (providerName != null)
{
var providerExists = DbProviderFactories.GetFactoryClasses().Rows.Cast<DataRow>().Any(r => r[2].Equals(providerName));
if (providerExists)
{
var factory = DbProviderFactories.GetFactory(providerName);
return factory.CreateConnection();
}
}
return null;
}
private string GetDatabaseName(string constr)
{
DbConnectionStringBuilder builder = new DbConnectionStringBuilder();
builder.ConnectionString = constr;
if(builder.ContainsKey("Initial Catalog"))
{
return (string)builder["Initial Catalog"];
}
else if(builder.ContainsKey("Database"))
{
return (string)builder["Database"];
}
else if(builder.ContainsKey("AttachDBFileName"))
{
return (string)builder["AttachDBFileName"];
}
else if(builder.ContainsKey("Data Source")
&& ((string)builder["Data Source"]).EndsWith(".sdf", StringComparison.OrdinalIgnoreCase))
{
return (string)builder["Data Source"];
}
else
{
return _services.Model.DatabaseName;
}
}
/// <summary>
/// Replaces any existing 'enlist' parameter in the connection String
/// with a value indicating that manual enlist is necessary.
/// </summary>
protected virtual void ReplaceEnlistInConnectionString(DbConnectionStringBuilder dbConnectionStringBuilder)
{
if (dbConnectionStringBuilder.ContainsKey("enlist"))
dbConnectionStringBuilder.Remove("enlist");
dbConnectionStringBuilder.Add("enlist", false);
}
public void ConnectionString()
{
DbConnectionStringBuilder sb;
sb = new DbConnectionStringBuilder();
sb.ConnectionString = "A=B";
Assert.True(sb.ContainsKey("A"));
Assert.Equal("a=B", sb.ConnectionString);
Assert.Equal(1, sb.Count);
Assert.Equal(1, sb.Keys.Count);
sb.ConnectionString = null;
Assert.False(sb.ContainsKey("A"));
Assert.Equal(string.Empty, sb.ConnectionString);
Assert.Equal(0, sb.Count);
Assert.Equal(0, sb.Keys.Count);
sb = new DbConnectionStringBuilder();
sb.ConnectionString = "A=B";
sb.ConnectionString = string.Empty;
Assert.False(sb.ContainsKey("A"));
Assert.Equal(string.Empty, sb.ConnectionString);
Assert.Equal(0, sb.Count);
Assert.Equal(0, sb.Keys.Count);
sb = new DbConnectionStringBuilder();
sb.ConnectionString = "A=B";
sb.ConnectionString = "\r ";
Assert.False(sb.ContainsKey("A"));
Assert.Equal(string.Empty, sb.ConnectionString);
Assert.Equal(0, sb.Count);
Assert.Equal(0, sb.Keys.Count);
}
public void ContainsKey ()
{
builder ["SourceType"] = "DBC";
builder.Add ("Port", "56");
Assert.IsTrue (builder.ContainsKey ("SourceType"), "#A1");
Assert.IsTrue (builder.ContainsKey ("Port"), "#A2");
Assert.IsFalse (builder.ContainsKey ("Dsn"), "#A3");
Assert.IsFalse (builder.ContainsKey ("Driver"), "#A4");
Assert.IsFalse (builder.ContainsKey ("xyz"), "#A5");
builder ["Dsn"] = "myDsn";
Assert.IsTrue (builder.ContainsKey ("Dsn"), "#A6");
builder ["Driver"] = "SQL Server";
Assert.IsTrue (builder.ContainsKey ("Driver"), "#A7");
builder ["abc"] = "pqr";
Assert.IsTrue (builder.ContainsKey ("ABC"), "#A8");
Assert.IsFalse (builder.ContainsKey (string.Empty), "#A9");
builder = new DbConnectionStringBuilder (false);
builder ["SourceType"] = "DBC";
builder.Add ("Port", "56");
Assert.IsTrue (builder.ContainsKey ("SourceType"), "#A1");
Assert.IsTrue (builder.ContainsKey ("Port"), "#A2");
Assert.IsFalse (builder.ContainsKey ("Dsn"), "#A3");
Assert.IsFalse (builder.ContainsKey ("Driver"), "#A4");
Assert.IsFalse (builder.ContainsKey ("xyz"), "#A5");
builder ["Dsn"] = "myDsn";
Assert.IsTrue (builder.ContainsKey ("Dsn"), "#A6");
builder ["Driver"] = "SQL Server";
Assert.IsTrue (builder.ContainsKey ("Driver"), "#A7");
builder ["abc"] = "pqr";
Assert.IsTrue (builder.ContainsKey ("ABC"), "#A8");
Assert.IsFalse (builder.ContainsKey (string.Empty), "#A9");
builder = new DbConnectionStringBuilder (true);
builder ["SourceType"] = "DBC";
builder.Add ("Port", "56");
Assert.IsTrue (builder.ContainsKey ("SourceType"), "#A1");
Assert.IsTrue (builder.ContainsKey ("Port"), "#A2");
Assert.IsFalse (builder.ContainsKey ("Dsn"), "#A3");
Assert.IsFalse (builder.ContainsKey ("Driver"), "#A4");
Assert.IsFalse (builder.ContainsKey ("xyz"), "#A5");
builder ["Dsn"] = "myDsn";
Assert.IsTrue (builder.ContainsKey ("Dsn"), "#A6");
builder ["Driver"] = "SQL Server";
Assert.IsTrue (builder.ContainsKey ("Driver"), "#A7");
builder ["abc"] = "pqr";
Assert.IsTrue (builder.ContainsKey ("ABC"), "#A8");
Assert.IsFalse (builder.ContainsKey (string.Empty), "#A9");
}
public void Remove()
{
Assert.False(_builder.Remove("Dsn"));
Assert.False(_builder.Remove("Driver"));
_builder.Add("DriverID", "790");
_builder["DefaultDir"] = "C:\\";
Assert.True(_builder.Remove("DriverID"));
Assert.False(_builder.ContainsKey("DriverID"));
Assert.False(_builder.Remove("DriverID"));
Assert.False(_builder.ContainsKey("DriverID"));
Assert.True(_builder.Remove("defaulTdIr"));
Assert.False(_builder.ContainsKey("DefaultDir"));
Assert.False(_builder.Remove("defaulTdIr"));
Assert.False(_builder.Remove("userid"));
Assert.False(_builder.Remove(string.Empty));
Assert.False(_builder.Remove("\r"));
Assert.False(_builder.Remove("a;"));
_builder["Dsn"] = "myDsn";
Assert.True(_builder.Remove("Dsn"));
Assert.False(_builder.ContainsKey("Dsn"));
Assert.False(_builder.Remove("Dsn"));
_builder["Driver"] = "SQL Server";
Assert.True(_builder.Remove("Driver"));
Assert.False(_builder.ContainsKey("Driver"));
Assert.False(_builder.Remove("Driver"));
_builder = new DbConnectionStringBuilder(false);
Assert.False(_builder.Remove("Dsn"));
Assert.False(_builder.Remove("Driver"));
_builder.Add("DriverID", "790");
_builder["DefaultDir"] = "C:\\";
Assert.True(_builder.Remove("DriverID"));
Assert.False(_builder.ContainsKey("DriverID"));
Assert.False(_builder.Remove("DriverID"));
Assert.False(_builder.ContainsKey("DriverID"));
Assert.True(_builder.Remove("defaulTdIr"));
Assert.False(_builder.ContainsKey("DefaultDir"));
Assert.False(_builder.Remove("defaulTdIr"));
Assert.False(_builder.Remove("userid"));
Assert.False(_builder.Remove(string.Empty));
Assert.False(_builder.Remove("\r"));
Assert.False(_builder.Remove("a;"));
_builder["Dsn"] = "myDsn";
Assert.True(_builder.Remove("Dsn"));
Assert.False(_builder.ContainsKey("Dsn"));
Assert.False(_builder.Remove("Dsn"));
_builder["Driver"] = "SQL Server";
Assert.True(_builder.Remove("Driver"));
Assert.False(_builder.ContainsKey("Driver"));
Assert.False(_builder.Remove("Driver"));
_builder = new DbConnectionStringBuilder(true);
Assert.False(_builder.Remove("Dsn"));
Assert.False(_builder.Remove("Driver"));
_builder.Add("DriverID", "790");
_builder["DefaultDir"] = "C:\\";
Assert.True(_builder.Remove("DriverID"));
Assert.False(_builder.ContainsKey("DriverID"));
Assert.False(_builder.Remove("DriverID"));
Assert.False(_builder.ContainsKey("DriverID"));
Assert.True(_builder.Remove("defaulTdIr"));
Assert.False(_builder.ContainsKey("DefaultDir"));
Assert.False(_builder.Remove("defaulTdIr"));
Assert.False(_builder.Remove("userid"));
Assert.False(_builder.Remove(string.Empty));
Assert.False(_builder.Remove("\r"));
Assert.False(_builder.Remove("a;"));
_builder["Dsn"] = "myDsn";
Assert.True(_builder.Remove("Dsn"));
Assert.False(_builder.ContainsKey("Dsn"));
Assert.False(_builder.Remove("Dsn"));
_builder["Driver"] = "SQL Server";
Assert.True(_builder.Remove("Driver"));
Assert.False(_builder.ContainsKey("Driver"));
Assert.False(_builder.Remove("Driver"));
}
public void ContainsKey()
{
_builder["SourceType"] = "DBC";
_builder.Add("Port", "56");
Assert.True(_builder.ContainsKey("SourceType"));
Assert.True(_builder.ContainsKey("Port"));
Assert.False(_builder.ContainsKey("Dsn"));
Assert.False(_builder.ContainsKey("Driver"));
Assert.False(_builder.ContainsKey("xyz"));
_builder["Dsn"] = "myDsn";
Assert.True(_builder.ContainsKey("Dsn"));
_builder["Driver"] = "SQL Server";
Assert.True(_builder.ContainsKey("Driver"));
_builder["abc"] = "pqr";
Assert.True(_builder.ContainsKey("ABC"));
Assert.False(_builder.ContainsKey(string.Empty));
_builder = new DbConnectionStringBuilder(false);
_builder["SourceType"] = "DBC";
_builder.Add("Port", "56");
Assert.True(_builder.ContainsKey("SourceType"));
Assert.True(_builder.ContainsKey("Port"));
Assert.False(_builder.ContainsKey("Dsn"));
Assert.False(_builder.ContainsKey("Driver"));
Assert.False(_builder.ContainsKey("xyz"));
_builder["Dsn"] = "myDsn";
Assert.True(_builder.ContainsKey("Dsn"));
_builder["Driver"] = "SQL Server";
Assert.True(_builder.ContainsKey("Driver"));
_builder["abc"] = "pqr";
Assert.True(_builder.ContainsKey("ABC"));
Assert.False(_builder.ContainsKey(string.Empty));
_builder = new DbConnectionStringBuilder(true);
_builder["SourceType"] = "DBC";
_builder.Add("Port", "56");
Assert.True(_builder.ContainsKey("SourceType"));
Assert.True(_builder.ContainsKey("Port"));
Assert.False(_builder.ContainsKey("Dsn"));
Assert.False(_builder.ContainsKey("Driver"));
Assert.False(_builder.ContainsKey("xyz"));
_builder["Dsn"] = "myDsn";
Assert.True(_builder.ContainsKey("Dsn"));
_builder["Driver"] = "SQL Server";
Assert.True(_builder.ContainsKey("Driver"));
_builder["abc"] = "pqr";
Assert.True(_builder.ContainsKey("ABC"));
Assert.False(_builder.ContainsKey(string.Empty));
}
private String GetProviderName(string connectionString)
{
var csb = new DbConnectionStringBuilder {ConnectionString = connectionString};
String providerName = null;
if (csb.ContainsKey("provider")) {
providerName = csb["provider"].ToString();
} else {
var css = ConfigurationManager
.ConnectionStrings
.Cast<ConnectionStringSettings>()
.FirstOrDefault(x => x.ConnectionString == connectionString);
if (css != null) providerName = css.ProviderName;
}
return providerName;
}
private void SyncSelectedObjects(TreeNode selectedNode, bool nodeChecked)
{
if ((selectedNode == this.siteTree.TopNode) ||
(null == this.siteTree.Tag))
{
return;
}
SelectedObjects selectedObjs = (SelectedObjects)this.siteTree.Tag;
Type objectType = selectedNode.Tag.GetType();
//
// Add or remove selected items from the selected objects list.
//
if (nodeChecked) {
if(typeof(string) == objectType && selectedNode.Tag == "AddDB")
{
AddDbConnectionDialog dbDialog = new AddDbConnectionDialog();
if(dbDialog.ShowDialog() == DialogResult.OK)
{
string dbConnectionString = dbDialog.textBoxDbConnectionString.Text.Trim();
try
{
var dbConn = new DbConnectionStringBuilder { ConnectionString = dbConnectionString };
// dbConn.ConnectionString = dbConnectionString;
if (dbConn.ContainsKey("Provider") && (dbConn["Provider"].ToString() == "SQLOLEDB" || dbConn["Provider"].ToString().Contains("SQLNCLI")))
{
dbConn.Remove("Provider");
}
var sqlConn = new SqlConnectionStringBuilder(dbConn.ConnectionString);
//sqlConn.ConnectionString = dbConnectionString;
Site site = (Site)selectedNode.Parent.Tag;
Database db = new Database("", sqlConn.InitialCatalog, sqlConn.ConnectionString) { ParentSite = site };
site.Add(db);
selectedNode.Tag = db;
objectType = typeof(Database);
}
catch (System.ArgumentException ex)
{
string message = "Invalid connection string.\r\n\r\nValid connection string should be like\r\n 'Data Source=<servername>; Initial Catalog=<intialCatalog>; Trusted_Connection=<Yes|No>'";
MessageBox.Show(message);
selectedNode.Tag = "AddDB";
selectedNode.Checked = false;
TraceHelper.Tracer.WriteTrace(message);
return;
}
}
else
{
selectedNode.Tag = "AddDB";
selectedNode.Checked = false;
return;
}
}
//
// If this is a child node, and it's been checked, make sure its
// parent nodes are checked.
//
TreeNode nodeParent = selectedNode.Parent;
while (null != nodeParent) {
if (!nodeParent.Checked) {
nodeParent.Checked = true;
}
nodeParent = nodeParent.Parent;
}
if (typeof(Site) == objectType) {
if (!selectedObjs.SelectedSites.Contains((Site)selectedNode.Tag)) {
selectedObjs.SelectedSites.Add((Site)selectedNode.Tag);
}
// It's actually not possible to check (enable) anything
// in the tree without at least one site being checked.
this.StartButton.Enabled = true;
}
else if (typeof(Database) == objectType)
{
if (!selectedObjs.SelectedDatabases.Contains((Database)selectedNode.Tag))
{
selectedObjs.SelectedDatabases.Add((Database)selectedNode.Tag);
}
}
else if (typeof(IISServer) == objectType)
{
if (!selectedObjs.SelectedServers.Contains((IISServer)selectedNode.Tag))
{
selectedObjs.SelectedServers.Add((IISServer)selectedNode.Tag);
}
}
}
else
{
if (typeof(Site) == objectType)
{
if (selectedObjs.SelectedSites.Contains((Site)selectedNode.Tag))
{
selectedObjs.SelectedSites.Remove((Site)selectedNode.Tag);
}
}
else if (typeof(Database) == objectType)
{
if (selectedObjs.SelectedDatabases.Contains((Database)selectedNode.Tag))
{
selectedObjs.SelectedDatabases.Remove((Database)selectedNode.Tag);
}
}
else if (typeof(IISServer) == objectType)
{
if (!selectedObjs.SelectedServers.Contains((IISServer)selectedNode.Tag))
{
selectedObjs.SelectedServers.Remove((IISServer)selectedNode.Tag);
}
}
this.StartButton.Enabled = (0 != selectedObjs.SelectedSites.Count());
}
}
/// <summary>
/// Initializes a new instance of the <see cref="ControlStringHandler"/> class.
/// </summary>
/// <param name="controlString">The control string.</param>
public WatinControlStringHandler(string controlString)
{
_ContolStringBuilder = new DbConnectionStringBuilder();
_ContolStringBuilder.ConnectionString = controlString;
// Set WaitForComplete if we need to wait for the control
if (_ContolStringBuilder.ContainsKey("WaitForComplete"))
{
WaitForComplete = Convert.ToBoolean(_ContolStringBuilder["WaitForComplete"]);
}
else
{
WaitForComplete = true;
}
// Set the report viewer
if (_ContolStringBuilder.ContainsKey("IsInReportViewer"))
{
IsInReportViewer = Convert.ToBoolean(_ContolStringBuilder["IsInReportViewer"]);
}
else
{
IsInReportViewer = false;
}
// Set frame controller
if (_ContolStringBuilder.ContainsKey("Frame"))
{
Frame = _ContolStringBuilder["Frame"].ToString();
}
// Set HtmlDialog controller
if (_ContolStringBuilder.ContainsKey("HTMLDialog"))
{
HTMLDialog = _ContolStringBuilder["HTMLDialog"].ToString();
}
// Set HtmlDialog controller
if (_ContolStringBuilder.ContainsKey("Table"))
{
TableDefinition = _ContolStringBuilder["Table"].ToString();
}
// get the type of HTML control, e.g Button or Link
if (_ContolStringBuilder.ContainsKey("Type"))
{
ControlType = Convert.ToString(_ContolStringBuilder["Type"]).ToLower();
}
EvaluateAndConstructWatiNAttribute();
}
public void ConnectionString ()
{
DbConnectionStringBuilder sb;
sb = new DbConnectionStringBuilder ();
sb.ConnectionString = "A=B";
Assert.IsTrue (sb.ContainsKey ("A"), "#A1");
Assert.AreEqual ("a=B", sb.ConnectionString, "#A2");
Assert.AreEqual (1, sb.Count, "#A3");
Assert.AreEqual (1, sb.Keys.Count, "#A4");
sb.ConnectionString = null;
Assert.IsFalse (sb.ContainsKey ("A"), "#B1");
Assert.AreEqual (string.Empty, sb.ConnectionString, "#B2");
Assert.AreEqual (0, sb.Count, "#B3");
Assert.AreEqual (0, sb.Keys.Count, "#B4");
sb = new DbConnectionStringBuilder ();
sb.ConnectionString = "A=B";
sb.ConnectionString = string.Empty;
Assert.IsFalse (sb.ContainsKey ("A"), "#C1");
Assert.AreEqual (string.Empty, sb.ConnectionString, "#C2");
Assert.AreEqual (0, sb.Count, "#C3");
Assert.AreEqual (0, sb.Keys.Count, "#C4");
sb = new DbConnectionStringBuilder ();
sb.ConnectionString = "A=B";
sb.ConnectionString = "\r ";
Assert.IsFalse (sb.ContainsKey ("A"), "#D1");
Assert.AreEqual (string.Empty, sb.ConnectionString, "#D2");
Assert.AreEqual (0, sb.Count, "#D3");
Assert.AreEqual (0, sb.Keys.Count, "#D4");
}
private void SetConnectionString(string connectionString)
{
if (String.IsNullOrEmpty(connectionString) || String.IsNullOrEmpty(connectionString.Trim()))
throw new ArgumentNullException("connectionString", ExecutionStringManager.MissingConnectionString);
DbConnectionStringBuilder dcsb = new DbConnectionStringBuilder();
dcsb.ConnectionString = connectionString;
// Don't allow the client to specify an auto-enlist value since we decide whether to participate in a transaction
// (enlist for writing and not for reading).
if (dcsb.ContainsKey("enlist"))
{
throw new ArgumentException(ExecutionStringManager.InvalidEnlist);
}
this.connString = connectionString;
//
// We only support sqlclient, sql is the only data store our OOB services talk to.
localProvider = Provider.SqlClient;
}
public void Remove ()
{
Assert.IsFalse (builder.Remove ("Dsn"), "#A1");
Assert.IsFalse (builder.Remove ("Driver"), "#A2");
builder.Add ("DriverID", "790");
builder ["DefaultDir"] = "C:\\";
Assert.IsTrue (builder.Remove ("DriverID"), "#B1");
Assert.IsFalse (builder.ContainsKey ("DriverID"), "#B2");
Assert.IsFalse (builder.Remove ("DriverID"), "#B3");
Assert.IsFalse (builder.ContainsKey ("DriverID"), "#B4");
Assert.IsTrue (builder.Remove ("defaulTdIr"), "#B5");
Assert.IsFalse (builder.ContainsKey ("DefaultDir"), "#B6");
Assert.IsFalse (builder.Remove ("defaulTdIr"), "#B7");
Assert.IsFalse (builder.Remove ("userid"), "#B8");
Assert.IsFalse (builder.Remove (string.Empty), "#B9");
Assert.IsFalse (builder.Remove ("\r"), "#B10");
Assert.IsFalse (builder.Remove ("a;"), "#B11");
builder ["Dsn"] = "myDsn";
Assert.IsTrue (builder.Remove ("Dsn"), "#C1");
Assert.IsFalse (builder.ContainsKey ("Dsn"), "#C2");
Assert.IsFalse (builder.Remove ("Dsn"), "#C3");
builder ["Driver"] = "SQL Server";
Assert.IsTrue (builder.Remove ("Driver"), "#D1");
Assert.IsFalse (builder.ContainsKey ("Driver"), "#D2");
Assert.IsFalse (builder.Remove ("Driver"), "#D3");
builder = new DbConnectionStringBuilder (false);
Assert.IsFalse (builder.Remove ("Dsn"), "#A1");
Assert.IsFalse (builder.Remove ("Driver"), "#A2");
builder.Add ("DriverID", "790");
builder ["DefaultDir"] = "C:\\";
Assert.IsTrue (builder.Remove ("DriverID"), "#B1");
Assert.IsFalse (builder.ContainsKey ("DriverID"), "#B2");
Assert.IsFalse (builder.Remove ("DriverID"), "#B3");
Assert.IsFalse (builder.ContainsKey ("DriverID"), "#B4");
Assert.IsTrue (builder.Remove ("defaulTdIr"), "#B5");
Assert.IsFalse (builder.ContainsKey ("DefaultDir"), "#B6");
Assert.IsFalse (builder.Remove ("defaulTdIr"), "#B7");
Assert.IsFalse (builder.Remove ("userid"), "#B8");
Assert.IsFalse (builder.Remove (string.Empty), "#B9");
Assert.IsFalse (builder.Remove ("\r"), "#B10");
Assert.IsFalse (builder.Remove ("a;"), "#B11");
builder ["Dsn"] = "myDsn";
Assert.IsTrue (builder.Remove ("Dsn"), "#C1");
Assert.IsFalse (builder.ContainsKey ("Dsn"), "#C2");
Assert.IsFalse (builder.Remove ("Dsn"), "#C3");
builder ["Driver"] = "SQL Server";
Assert.IsTrue (builder.Remove ("Driver"), "#D1");
Assert.IsFalse (builder.ContainsKey ("Driver"), "#D2");
Assert.IsFalse (builder.Remove ("Driver"), "#D3");
builder = new DbConnectionStringBuilder (true);
Assert.IsFalse (builder.Remove ("Dsn"), "#A1");
Assert.IsFalse (builder.Remove ("Driver"), "#A2");
builder.Add ("DriverID", "790");
builder ["DefaultDir"] = "C:\\";
Assert.IsTrue (builder.Remove ("DriverID"), "#B1");
Assert.IsFalse (builder.ContainsKey ("DriverID"), "#B2");
Assert.IsFalse (builder.Remove ("DriverID"), "#B3");
Assert.IsFalse (builder.ContainsKey ("DriverID"), "#B4");
Assert.IsTrue (builder.Remove ("defaulTdIr"), "#B5");
Assert.IsFalse (builder.ContainsKey ("DefaultDir"), "#B6");
Assert.IsFalse (builder.Remove ("defaulTdIr"), "#B7");
Assert.IsFalse (builder.Remove ("userid"), "#B8");
Assert.IsFalse (builder.Remove (string.Empty), "#B9");
Assert.IsFalse (builder.Remove ("\r"), "#B10");
Assert.IsFalse (builder.Remove ("a;"), "#B11");
builder ["Dsn"] = "myDsn";
Assert.IsTrue (builder.Remove ("Dsn"), "#C1");
Assert.IsFalse (builder.ContainsKey ("Dsn"), "#C2");
Assert.IsFalse (builder.Remove ("Dsn"), "#C3");
builder ["Driver"] = "SQL Server";
Assert.IsTrue (builder.Remove ("Driver"), "#D1");
Assert.IsFalse (builder.ContainsKey ("Driver"), "#D2");
Assert.IsFalse (builder.Remove ("Driver"), "#D3");
}
