| public Add ( string keyword, object value ) : void | ||
| keyword | string | |
| value | object | |
| Результат | void | |
private void instancesComboBox_SelectedIndexChanged(object sender, EventArgs e)
{
string server = (string)instancesComboBox.SelectedItem;
DbConnectionStringBuilder builder = new DbConnectionStringBuilder();
builder.Add("Data Source", server);
builder.Add("Initial Catalog", "master");
builder.Add("Integrated Security", "SSPI");
using ( SqlConnection conn = new SqlConnection(builder.ConnectionString) )
{
SqlCommand cmd = new SqlCommand("select name from sys.databases", conn);
conn.Open();
using ( SqlDataReader reader = cmd.ExecuteReader() )
{
List<string> dbs = new List<string>();
while ( reader.Read() )
{
dbs.Add(reader.GetString(0));
}
dbsComboBox.DataSource = dbs;
}
}
}
static void Main()
{
DbConnectionStringBuilder dcsBuilder = new DbConnectionStringBuilder();
dcsBuilder.Add("User ID", "wjzgis");
dcsBuilder.Add("Password", "wjzgis");
dcsBuilder.Add("Service Name", "sunz");
dcsBuilder.Add("Host", "172.16.1.9");
dcsBuilder.Add("Integrated Security", false);
string licPath = Application.StartupPath + "\\DDTek.lic";
//dcsBuilder.Add("License Path", licPath);
//若路径中存在空格，则会在路径名称前加上"\""
string conStr = dcsBuilder.ConnectionString;
conStr = conStr.Replace("\"", "");
Configuration config = new Configuration();
config.AddDirectory(new System.IO.DirectoryInfo( System.IO.Path.Combine(Application.StartupPath, "DataMapping")));
config.Properties["connection.connection_string"] = conStr;
NHibernate.ISessionFactory sFactory = config.BuildSessionFactory();
NHibernate.ISession session = sFactory.OpenSession();
Application.EnableVisualStyles();
Application.SetCompatibleTextRenderingDefault(false);
Application.Run(new Form1());
}
/// <summary>
/// get default connection string.
/// </summary>
/// <returns>Connection String</returns>
public static string GetConnectionString()
{
DbConnectionStringBuilder connectBuilder = new DbConnectionStringBuilder();
connectBuilder.Add("Data Source", "localhost");
connectBuilder.Add("Database", "bookstore");
connectBuilder.Add("User ID", "root");
connectBuilder.Add("Password", "v*elocIpEd");
return connectBuilder.ConnectionString;
}
/// <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");
}
public string GetConnectionString(AbstractConnection connection) {
if (string.IsNullOrEmpty(ServerProperty))
return string.Empty;
var builder = new DbConnectionStringBuilder { { ServerProperty, connection.Server } };
if (!string.IsNullOrEmpty(connection.Database)) {
builder.Add(DatabaseProperty, connection.Database);
}
if (!String.IsNullOrEmpty(connection.User)) {
builder.Add(UserProperty, connection.User);
builder.Add(PasswordProperty, connection.Password);
} else {
if (!String.IsNullOrEmpty(TrustedProperty)) {
builder.Add(TrustedProperty, true);
}
}
if (PersistSecurityInfoProperty != string.Empty && connection.PersistSecurityInfo != string.Empty) {
builder.Add(PersistSecurityInfoProperty, connection.PersistSecurityInfo);
}
if (connection.Port <= 0)
return builder.ConnectionString;
if (PortProperty == string.Empty) {
builder[ServerProperty] += "," + connection.Port;
} else {
builder.Add("Port", connection.Port);
}
return builder.ConnectionString;
}
public Form1()
{
InitializeComponent();
DataTable dtProviderFactorys = DbProviderFactories.GetFactoryClasses();
DbConnectionStringBuilder dcsBuilder = new DbConnectionStringBuilder();
dcsBuilder.Add("User ID", "hzzgis");
dcsBuilder.Add("Password", "hzzgis");
dcsBuilder.Add("Service Name", "sunz");
dcsBuilder.Add("Host", "172.16.1.9");
dcsBuilder.Add("Integrated Security", false);
string licPath = Application.StartupPath + "\\DDTek.lic";
if (!System.IO.File.Exists(licPath))
licPath = CretateDDTekLic.CreateLic();
dcsBuilder.Add("License Path", licPath);
//若路径中存在空格，则会在路径名称前加上"\""
string conStr = dcsBuilder.ConnectionString;
conStr = conStr.Replace("\"", "");
DDTek.Oracle.OracleConnection orclConnection = new DDTek.Oracle.OracleConnection(conStr);
DDTek.Oracle.OracleCommand cmd = new DDTek.Oracle.OracleCommand();
DDTek.Oracle.OracleDataAdapter adapter = new DDTek.Oracle.OracleDataAdapter();
adapter.SelectCommand = cmd;
DbDataAdapter dAdapter = adapter;
DbCommand dbCommand = dAdapter.SelectCommand;
orclConnection.Open();
//Configuration config = new Configuration();
//ISessionFactory pFactory = config.BuildSessionFactory();
//ISession pSession= pFactory.OpenSession(orclConnection as IDbConnection);
//DbProviderFactory factory = DbProviderFactories.GetFactory("System.Data.OracleClient");
//IDbConnection dbConn = factory.CreateConnection();
//if (dbConn != null)
// MessageBox.Show("Connection Created");
//Conn.ConnectionString = "Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=" + Server + ")(PORT=" + Port + ")))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=" + Service + ")));user id=" + User + ";password="******";pooling = true;Unicode=True";
IDbConnection dbConn=new System.Data.OleDb.OleDbConnection();
string Server = "sunzvm-lc", Port = "1521", Service = "sunz", User = "******", PWD = "hzzgis";
//dbConn.ConnectionString = "Provider=OraOLEDB.Oracle.1;Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=" + Server + ")(PORT=" + Port + ")))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=" + Service + ")));user id=" + User + ";password="******";pooling = true;Unicode=True";
dbConn.ConnectionString = "Provider=MSDAORA.1;Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=" + Server + ")(PORT=" + Port + ")))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=" + Service + ")));user id=" + User + ";password="******";pooling = true;Unicode=True";
try
{
dbConn.Open();
}
catch(Exception exp)
{
MessageBox.Show(exp.ToString());
}
}
public void EquivalentToTest ()
{
builder.Add (SERVER, SERVER_VALUE);
DbConnectionStringBuilder sb2 = new DbConnectionStringBuilder ();
sb2.Add (SERVER, SERVER_VALUE);
bool value = builder.EquivalentTo (sb2);
Assert.IsTrue (value, "builder comparision does not work!");
// negative tests
sb2.Add (SERVER + "1", SERVER_VALUE);
value = builder.EquivalentTo (sb2);
Assert.IsFalse (value, "builder comparision does not work for not equivalent strings!");
}
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.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");
}
public void TryGetValueTest ()
{
object value = null;
builder ["DriverID"] = "790";
builder.Add ("Server", "C:\\");
Assert.IsTrue (builder.TryGetValue ("DriverID", out value), "#A1");
Assert.AreEqual ("790", value, "#A2");
Assert.IsTrue (builder.TryGetValue ("SERVER", out value), "#B1");
Assert.AreEqual ("C:\\", value, "#B2");
Assert.IsFalse (builder.TryGetValue (string.Empty, out value), "#C1");
Assert.IsNull (value, "#C2");
Assert.IsFalse (builder.TryGetValue ("a;", out value), "#D1");
Assert.IsNull (value, "#D2");
Assert.IsFalse (builder.TryGetValue ("\r", out value), "#E1");
Assert.IsNull (value, "#E2");
Assert.IsFalse (builder.TryGetValue (" ", out value), "#F1");
Assert.IsNull (value, "#F2");
Assert.IsFalse (builder.TryGetValue ("doesnotexist", out value), "#G1");
Assert.IsNull (value, "#G2");
Assert.IsFalse (builder.TryGetValue ("Driver", out value), "#H1");
Assert.IsNull (value, "#H2");
Assert.IsFalse (builder.TryGetValue ("Dsn", out value), "#I1");
Assert.IsNull (value, "#I2");
builder = new DbConnectionStringBuilder (false);
builder ["DriverID"] = "790";
builder.Add ("Server", "C:\\");
Assert.IsTrue (builder.TryGetValue ("DriverID", out value), "#A1");
Assert.AreEqual ("790", value, "#A2");
Assert.IsTrue (builder.TryGetValue ("SERVER", out value), "#B1");
Assert.AreEqual ("C:\\", value, "#B2");
Assert.IsFalse (builder.TryGetValue (string.Empty, out value), "#C1");
Assert.IsNull (value, "#C2");
Assert.IsFalse (builder.TryGetValue ("a;", out value), "#D1");
Assert.IsNull (value, "#D2");
Assert.IsFalse (builder.TryGetValue ("\r", out value), "#E1");
Assert.IsNull (value, "#E2");
Assert.IsFalse (builder.TryGetValue (" ", out value), "#F1");
Assert.IsNull (value, "#F2");
Assert.IsFalse (builder.TryGetValue ("doesnotexist", out value), "#G1");
Assert.IsNull (value, "#G2");
Assert.IsFalse (builder.TryGetValue ("Driver", out value), "#H1");
Assert.IsNull (value, "#H2");
Assert.IsFalse (builder.TryGetValue ("Dsn", out value), "#I1");
Assert.IsNull (value, "#I2");
builder = new DbConnectionStringBuilder (true);
builder ["DriverID"] = "790";
builder.Add ("Server", "C:\\");
Assert.IsTrue (builder.TryGetValue ("DriverID", out value), "#A1");
Assert.AreEqual ("790", value, "#A2");
Assert.IsTrue (builder.TryGetValue ("SERVER", out value), "#B1");
Assert.AreEqual ("C:\\", value, "#B2");
Assert.IsFalse (builder.TryGetValue (string.Empty, out value), "#C1");
Assert.IsNull (value, "#C2");
Assert.IsFalse (builder.TryGetValue ("a;", out value), "#D1");
Assert.IsNull (value, "#D2");
Assert.IsFalse (builder.TryGetValue ("\r", out value), "#E1");
Assert.IsNull (value, "#E2");
Assert.IsFalse (builder.TryGetValue (" ", out value), "#F1");
Assert.IsNull (value, "#F2");
Assert.IsFalse (builder.TryGetValue ("doesnotexist", out value), "#G1");
Assert.IsNull (value, "#G2");
Assert.IsFalse (builder.TryGetValue ("Driver", out value), "#H1");
Assert.IsNull (value, "#H2");
Assert.IsFalse (builder.TryGetValue ("Dsn", out value), "#I1");
Assert.IsNull (value, "#I2");
}
private void okButton_Click(object sender, EventArgs e)
{
DbConnectionStringBuilder builder = new DbConnectionStringBuilder();
builder.Add("Data Source", instancesComboBox.Text);
builder.Add("Initial Catalog", dbsComboBox.Text);
builder.Add("Integrated Security", "SSPI");
ConnectionString = builder.ConnectionString;
DialogResult = DialogResult.OK;
Close();
}
private void initialize(string path, bool hasHeaders, bool hasMixedData)
{
string fullPath = Path.GetFullPath(path);
string extension = Path.GetExtension(path);
if (!File.Exists(fullPath))
throw new FileNotFoundException("File could not be found.", fullPath);
string tempFileName = Path.GetTempFileName();
File.Copy(fullPath, tempFileName, true);
// Reader Settings
HasHeaders = hasHeaders;
HasMixedData = hasMixedData;
switch (extension)
{
case ".xls": Version = "Excel 8.0"; break; // Excel 95-2003
case ".xlsx": Version = "Excel 12.0"; break; // Excel 2007+
default: throw new ArgumentException("File type could not be determined by file extension.", "path");
}
if (IntPtr.Size == 4 && extension == ".xls")
Provider = "Microsoft.Jet.OLEDB.4.0"; // for x86/95-2003
else Provider = "Microsoft.ACE.OLEDB.12.0"; // for x64/95-2007+
var strBuilder = new DbConnectionStringBuilder();
strBuilder.Add("Provider", Provider);
strBuilder.Add("Data Source", tempFileName);
strBuilder.Add("Extended Properties", Version + ";" +
"HDR=" + (HasHeaders ? "Yes" : "No") + ';' +
"Imex=" + (HasMixedData ? "2" : "0") + ';');
strConnection = strBuilder.ToString();
}
/// <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 TryGetValueTest()
{
object value = null;
_builder["DriverID"] = "790";
_builder.Add("Server", "C:\\");
Assert.True(_builder.TryGetValue("DriverID", out value));
Assert.Equal("790", value);
Assert.True(_builder.TryGetValue("SERVER", out value));
Assert.Equal("C:\\", value);
Assert.False(_builder.TryGetValue(string.Empty, out value));
Assert.Null(value);
Assert.False(_builder.TryGetValue("a;", out value));
Assert.Null(value);
Assert.False(_builder.TryGetValue("\r", out value));
Assert.Null(value);
Assert.False(_builder.TryGetValue(" ", out value));
Assert.Null(value);
Assert.False(_builder.TryGetValue("doesnotexist", out value));
Assert.Null(value);
Assert.False(_builder.TryGetValue("Driver", out value));
Assert.Null(value);
Assert.False(_builder.TryGetValue("Dsn", out value));
Assert.Null(value);
_builder = new DbConnectionStringBuilder(false);
_builder["DriverID"] = "790";
_builder.Add("Server", "C:\\");
Assert.True(_builder.TryGetValue("DriverID", out value));
Assert.Equal("790", value);
Assert.True(_builder.TryGetValue("SERVER", out value));
Assert.Equal("C:\\", value);
Assert.False(_builder.TryGetValue(string.Empty, out value));
Assert.Null(value);
Assert.False(_builder.TryGetValue("a;", out value));
Assert.Null(value);
Assert.False(_builder.TryGetValue("\r", out value));
Assert.Null(value);
Assert.False(_builder.TryGetValue(" ", out value));
Assert.Null(value);
Assert.False(_builder.TryGetValue("doesnotexist", out value));
Assert.Null(value);
Assert.False(_builder.TryGetValue("Driver", out value));
Assert.Null(value);
Assert.False(_builder.TryGetValue("Dsn", out value));
Assert.Null(value);
_builder = new DbConnectionStringBuilder(true);
_builder["DriverID"] = "790";
_builder.Add("Server", "C:\\");
Assert.True(_builder.TryGetValue("DriverID", out value));
Assert.Equal("790", value);
Assert.True(_builder.TryGetValue("SERVER", out value));
Assert.Equal("C:\\", value);
Assert.False(_builder.TryGetValue(string.Empty, out value));
Assert.Null(value);
Assert.False(_builder.TryGetValue("a;", out value));
Assert.Null(value);
Assert.False(_builder.TryGetValue("\r", out value));
Assert.Null(value);
Assert.False(_builder.TryGetValue(" ", out value));
Assert.Null(value);
Assert.False(_builder.TryGetValue("doesnotexist", out value));
Assert.Null(value);
Assert.False(_builder.TryGetValue("Driver", out value));
Assert.Null(value);
Assert.False(_builder.TryGetValue("Dsn", out value));
Assert.Null(value);
}
private static string GetConnectionString(string fileOrConnectionString)
{
if (fileOrConnectionString.IndexOf('=') > 0)
{
return fileOrConnectionString;
}
DbConnectionStringBuilder builder = new DbConnectionStringBuilder();
if (fileOrConnectionString.EndsWith(".mdf", StringComparison.OrdinalIgnoreCase))
{
builder.Add("AttachDBFileName", fileOrConnectionString);
builder.Add("Server", @"localhost\sqlexpress");
builder.Add("Integrated Security", "SSPI");
builder.Add("User Instance", "true");
builder.Add("MultipleActiveResultSets", "true");
}
else
{
if (!fileOrConnectionString.EndsWith(".sdf", StringComparison.OrdinalIgnoreCase))
{
return fileOrConnectionString;
}
builder.Add("Data Source", fileOrConnectionString);
}
return builder.ToString();
}
/// <summary>
/// Taken from CodeRun.DataModel.Database
/// </summary>
/// <param name="fileOrServerOrConnectionString"></param>
/// <returns></returns>
private static string FixInitialConnectionString(string fileOrServerOrConnectionString)
{
//if (fileOrServerOrConnectionString.Contains(DataDirectoryKeyword) && HostingEnvironment.IsHosted)
//{
// fileOrServerOrConnectionString = fileOrServerOrConnectionString.Replace(DataDirectoryKeyword, HostingEnvironment.MapPath("~/App_Data"));
//}
if (fileOrServerOrConnectionString.IndexOf('=') >= 0)
{
return fileOrServerOrConnectionString;
}
DbConnectionStringBuilder builder = new DbConnectionStringBuilder();
if (fileOrServerOrConnectionString.EndsWith(".mdf", StringComparison.OrdinalIgnoreCase))
{
builder.Add("Initial Catalog", fileOrServerOrConnectionString);//changed
builder.Add("Server", DefaultDbServer);
builder.Add("Integrated Security", "SSPI");
//removed builder.Add("User Instance", "true");
builder.Add("MultipleActiveResultSets", "true");
}
else if (fileOrServerOrConnectionString.EndsWith(".sdf", StringComparison.OrdinalIgnoreCase))
{
builder.Add("Data Source", fileOrServerOrConnectionString);
}
else
{
return fileOrServerOrConnectionString;
//builder.Add("Server", fileOrServerOrConnectionString);
//builder.Add("Database", db.Mapping.DatabaseName);
//builder.Add("Integrated Security", "SSPI");
}
return builder.ToString();
}
//private void Delete()
//{
// Process proc = new Process();
// proc.StartInfo.CreateNoWindow = true;
// proc.StartInfo.FileName = "cmd.exe";
// proc.StartInfo.UseShellExecute = false;
// proc.StartInfo.RedirectStandardError = true;
// proc.StartInfo.RedirectStandardInput = true;
// proc.StartInfo.RedirectStandardOutput = true;
// proc.Start();
// proc.StandardInput.WriteLine("del " + m_strFilePathName.Substring(0, m_strFilePathName.Length - 3) + "ldb");
// proc.StandardInput.WriteLine("del " + m_strFilePathName);
// //proc.StandardInput.WriteLine("delete " + m_strPath + ".tmp.mdb");
// proc.Close();
//}
private bool Connect(string strFilePathName)
{
try
{
m_strFilePathName = strFilePathName;
if (File.Exists(strFilePathName))
{
try
{
File.Delete(strFilePathName);
}
catch (Exception ee)
{
//Delete();
strFilePathName += "_1.mdb";
}
}
try
{
ADOX.Catalog catalog = new ADOX.Catalog();
catalog.Create("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + strFilePathName + ";Jet OLEDB:Engine Type=5");
System.Runtime.InteropServices.Marshal.FinalReleaseComObject(catalog.ActiveConnection);
System.Runtime.InteropServices.Marshal.FinalReleaseComObject(catalog);
}
catch (Exception ee)
{
}
DbConnectionStringBuilder dcsBuilder = new DbConnectionStringBuilder();
dcsBuilder.Clear();
dcsBuilder.Add("Provider", "Microsoft.Jet.Oledb.4.0");
dcsBuilder.Add("User ID", "Admin");
dcsBuilder.Add("Password", "");
dcsBuilder.Add("Data Source", @strFilePathName);
m_pOleDbConnection = new OleDbConnection(dcsBuilder.ConnectionString);
m_pOleDbConnection.Open();
//m_pPolygonNodeTable = new PolygonNodeTable(m_pOleDbConnection, true);
//m_pLineNodeExTable = new LineNodeExTable(m_pOleDbConnection, true);
//m_pLineNodeTable = new LineNodeTable(m_pOleDbConnection, true);
return true;
}
catch (Exception ex)
{
Logger.WriteErrorLog(ex);
}
return false;
}
private string GetOrganizationCrmConnectionString()
{
DbConnectionStringBuilder dbcb = new DbConnectionStringBuilder();
//dbcb.Add("Url", OrganizationServiceUrl.Replace("/XRMServices/2011/Organization.svc", ""));
dbcb.Add("Url", !string.IsNullOrEmpty(OriginalUrl) ? OriginalUrl : WebApplicationUrl);
if (IsCustomAuth)
{
if (!UseIfd)
{
if (!string.IsNullOrEmpty(UserDomain))
{
dbcb.Add("Domain", UserDomain);
}
}
string username = UserName;
if (UseIfd)
{
if (!string.IsNullOrEmpty(UserDomain))
{
username = string.Format("{0}\\{1}", UserDomain, UserName);
}
}
if (string.IsNullOrEmpty(userPassword))
{
throw new Exception("User password cannot be null. If the user password is not stored in configuration file, you should request it from the end user");
}
var decryptedPassword = CryptoManager.Decrypt(userPassword, ConnectionManager.CryptoPassPhrase,
ConnectionManager.CryptoSaltValue,
ConnectionManager.CryptoHashAlgorythm,
ConnectionManager.CryptoPasswordIterations,
ConnectionManager.CryptoInitVector,
ConnectionManager.CryptoKeySize);
dbcb.Add("Username", username);
dbcb.Add("Password", decryptedPassword);
}
if (UseIfd && !string.IsNullOrEmpty(HomeRealmUrl))
{
dbcb.Add("HomeRealmUri", HomeRealmUrl);
}
//append timeout in seconds to connectionstring
dbcb.Add("Timeout", Timeout.ToString(@"hh\:mm\:ss"));
//dbcb.Add("AuthType", "OAuth");
//dbcb.Add("ClientId", "eec38f99-9962-4bb3-99fa-5e04f4bb0ea5");
//dbcb.Add("LoginPrompt", "Auto");
//dbcb.Add("RedirectUri", "http://localhost/TOTO");
//dbcb.Add("TokenCacheStorePath", "c:\\temp");
//dbcb.Add("AuthType", UseOsdp ? "Office365" : (UseIfd ? "IFD" : "AD"));
return dbcb.ToString();
}
public string ToString(bool commandLine)
{
if (commandLine)
{
string targets = string.Join(" ", Targets.Select(t => t.Name == t.Schema ? t.Name : t.Name + ":" + t.Schema).ToArray());
DbConnectionStringBuilder csb = new DbConnectionStringBuilder();
csb.ConnectionString = Provider.ConnectionString;
csb.Add("Provider", Provider.Name);
string batch = BatchSize != DefaultBatchSize ? " batch:" + BatchSize : "";
string cmdLine = string.Format("{7} source:\"{0}\" target:\"{1}\"{2}{3}{4}{5} {6}", Source,
csb.ConnectionString, batch, Indices ? " indices" : "",
FullText ? " fulltext" : "", Split ? " split" : "", targets,
Path.GetFileName(Assembly.GetExecutingAssembly().Location));
return cmdLine;
}
else
{
return
string.Format("Source : {0}\r\nTarget : {1}\r\nOptions : {2}", Source, Target, Options);
}
}
private string GetDiscoveryCrmConnectionString()
{
DbConnectionStringBuilder dbcb = new DbConnectionStringBuilder();
dbcb.Add("Url", string.Format("{0}://{1}:{2}",
UseSsl ? "https" : "http",
UseIfd ? ServerName : UseOsdp ? "disco." + ServerName : UseOnline ? "dev." + ServerName : ServerName,
ServerPort == 0 ? (UseSsl ? 443 : 80) : ServerPort));
if (IsCustomAuth)
{
if (!UseIfd)
{
if (!string.IsNullOrEmpty(UserDomain))
{
dbcb.Add("Domain", UserDomain);
}
}
string username = UserName;
if (UseIfd)
{
if (!string.IsNullOrEmpty(UserDomain))
{
username = string.Format("{0}\\{1}", UserDomain, UserName);
}
}
if (string.IsNullOrEmpty(userPassword))
{
throw new Exception("User password cannot be null. If the user password is not stored in configuration file, you should request it from the end user");
}
var decryptedPassword = CryptoManager.Decrypt(userPassword, ConnectionManager.CryptoPassPhrase,
ConnectionManager.CryptoSaltValue,
ConnectionManager.CryptoHashAlgorythm,
ConnectionManager.CryptoPasswordIterations,
ConnectionManager.CryptoInitVector,
ConnectionManager.CryptoKeySize);
dbcb.Add("Username", username);
dbcb.Add("Password", decryptedPassword);
}
if (UseOnline && !UseOsdp)
{
ClientCredentials deviceCredentials;
do
{
deviceCredentials = DeviceIdManager.LoadDeviceCredentials() ??
DeviceIdManager.RegisterDevice();
} while (deviceCredentials.UserName.Password.Contains(";")
|| deviceCredentials.UserName.Password.Contains("=")
|| deviceCredentials.UserName.Password.Contains(" ")
|| deviceCredentials.UserName.UserName.Contains(";")
|| deviceCredentials.UserName.UserName.Contains("=")
|| deviceCredentials.UserName.UserName.Contains(" "));
dbcb.Add("DeviceID", deviceCredentials.UserName.UserName);
dbcb.Add("DevicePassword", deviceCredentials.UserName.Password);
}
if (UseIfd && !string.IsNullOrEmpty(HomeRealmUrl))
{
dbcb.Add("HomeRealmUri", HomeRealmUrl);
}
return dbcb.ToString();
}
private string GetOrganizationCrmConnectionString()
{
DbConnectionStringBuilder dbcb = new DbConnectionStringBuilder();
dbcb.Add("Url", OrganizationServiceUrl.Replace("/XRMServices/2011/Organization.svc", ""));
if (IsCustomAuth)
{
if (!UseIfd)
{
if (!string.IsNullOrEmpty(UserDomain))
{
dbcb.Add("Domain", UserDomain);
}
}
string username = UserName;
if (UseIfd)
{
if (!string.IsNullOrEmpty(UserDomain))
{
username = string.Format("{0}\\{1}", UserDomain, UserName);
}
}
if (string.IsNullOrEmpty(userPassword))
{
throw new Exception("User password cannot be null. If the user password is not stored in configuration file, you should request it from the end user");
}
var decryptedPassword = CryptoManager.Decrypt(userPassword, ConnectionManager.CryptoPassPhrase,
ConnectionManager.CryptoSaltValue,
ConnectionManager.CryptoHashAlgorythm,
ConnectionManager.CryptoPasswordIterations,
ConnectionManager.CryptoInitVector,
ConnectionManager.CryptoKeySize);
dbcb.Add("Username", username);
dbcb.Add("Password", decryptedPassword);
}
if (UseOnline)
{
ClientCredentials deviceCredentials;
do
{
deviceCredentials = DeviceIdManager.LoadDeviceCredentials() ??
DeviceIdManager.RegisterDevice();
} while (deviceCredentials.UserName.Password.Contains(";")
|| deviceCredentials.UserName.Password.Contains("=")
|| deviceCredentials.UserName.Password.Contains(" ")
|| deviceCredentials.UserName.UserName.Contains(";")
|| deviceCredentials.UserName.UserName.Contains("=")
|| deviceCredentials.UserName.UserName.Contains(" "));
dbcb.Add("DeviceID", deviceCredentials.UserName.UserName);
dbcb.Add("DevicePassword", deviceCredentials.UserName.Password);
}
if (UseIfd && !string.IsNullOrEmpty(HomeRealmUrl))
{
dbcb.Add("HomeRealmUri", HomeRealmUrl);
}
//append timeout in seconds to connectionstring
dbcb.Add("Timeout", Timeout.ToString(@"hh\:mm\:ss"));
return dbcb.ToString();
}
private string GetConnectionString(string fileOrServerOrConnectionString)
{
if(fileOrServerOrConnectionString.IndexOf('=') >= 0)
{
return fileOrServerOrConnectionString;
}
DbConnectionStringBuilder builder = new DbConnectionStringBuilder();
if(fileOrServerOrConnectionString.EndsWith(".mdf", StringComparison.OrdinalIgnoreCase))
{
// if just a database file is specified, default to local SqlExpress instance
builder.Add("AttachDBFileName", fileOrServerOrConnectionString);
builder.Add("Server", "localhost\\sqlexpress");
builder.Add("Integrated Security", "SSPI");
builder.Add("User Instance", "true");
builder.Add("MultipleActiveResultSets", "true");
}
else if(fileOrServerOrConnectionString.EndsWith(".sdf", StringComparison.OrdinalIgnoreCase))
{
// A SqlCE database file has been specified
builder.Add("Data Source", fileOrServerOrConnectionString);
}
else
{
builder.Add("Server", fileOrServerOrConnectionString);
builder.Add("Database", _services.Model.DatabaseName);
builder.Add("Integrated Security", "SSPI");
}
return builder.ToString();
}
//Eric 6.25
public static DataTable getXLSLeadsRecordsTable(string file, bool hasHeader)
{
DbConnectionStringBuilder builder = new DbConnectionStringBuilder();
// builder.Add("Provider", "Microsoft.Jet.OleDb.4.0");
builder.Add("Provider", "Microsoft.ACE.OLEDB.12.0");
builder.Add("Data Source", file);
if (hasHeader) // if the file contains a header
// builder.Add("Extended Properties", "Excel 8.0;HDR=Yes");
builder.Add("Extended Properties", "Excel 12.0;HDR=Yes;IMEX=1;");
else
//builder.Add("Extended Properties", "Excel 8.0;HDR=No");
builder.Add("Extended Properties", "Excel 12.0;HDR=No;IMEX=1;");
string conStr = builder.ToString();
OleDbConnection dbConn = new OleDbConnection(conStr);
DataTable dt = new DataTable();
try
{
dbConn.Open();
DataTable dtsheet = dbConn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, new object[] { null, null, null, "TABLE" });
String[] sWorksheet = new String[dtsheet.Rows.Count];
int i = 0;
foreach (DataRow row in dtsheet.Rows)
{
sWorksheet[i++] += row["TABLE_NAME"].ToString();
}
//char chSplit = '$';
//sWorksheet = sWorksheet.Split(chSplit).GetValue(0).ToString() + "$";
OleDbCommand cmd = new OleDbCommand();
cmd.CommandText = "Select * FROM [" + sWorksheet[0].Replace("''", "'") + "]";
cmd.Connection = dbConn;
OleDbDataAdapter objAd = new OleDbDataAdapter();
objAd.SelectCommand = cmd;
objAd.Fill(dt);
}
catch (Exception ex)
{
throw ex;
}
finally
{
dbConn.Close();
}
return dt;
}
static void Main(string[] args)
{
// set up variables with default values
string dbName = ConfigurationManager.AppSettings["DefaultDbName"];
string folderName = ConfigurationManager.AppSettings["DefaultFolderName"];
// set up capitalized word list
List<string> capitalizedWords = new List<string>();
foreach (var word in ConfigurationManager.AppSettings["CapitalizedWordList"].Split(','))
capitalizedWords.Add(word.Trim());
// prepare for songs
List<Song> songs = new List<Song>();
// get argument list
if (args.Length > 0)
dbName = args[0];
if (args.Length > 1)
folderName = args[1];
// ensure database exists
if (!File.Exists(dbName))
throw new FileNotFoundException("Could not find database file!", dbName);
// ensure folder exists (or create it)
if (!Directory.Exists(folderName))
Directory.CreateDirectory(folderName);
// build the connection string
DbConnectionStringBuilder builder = new DbConnectionStringBuilder();
builder.ConnectionString = ConfigurationManager.ConnectionStrings["Access"].ConnectionString;
builder.Add("Data Source", dbName);
// get a new connection
using (IDbConnection conn = new System.Data.OleDb.OleDbConnection(builder.ConnectionString))
{
conn.Open();
IDbCommand cmd = conn.CreateCommand();
cmd.CommandText = "SELECT SongTitle, Song, Chorus2, Chorus3, Chorus4, Verse1, Verse2, Verse3, Verse4 FROM Songs";
using(IDataReader reader = cmd.ExecuteReader(CommandBehavior.CloseConnection))
{
Song currSong;
while (reader.Read())
{
currSong = new Song(
System.Threading.Thread.CurrentThread.CurrentCulture.TextInfo.ToTitleCase(Regex.Replace(reader.GetString(0).ToLower(), @"\s+", " "))
);
for (int i = 1; i < reader.FieldCount; i++)
if ((!reader.IsDBNull(i)) && (!string.IsNullOrWhiteSpace(reader.GetString(i))))
currSong.Parts.Add(x[reader.GetName(i)], Normalize(reader.GetString(i), capitalizedWords));
songs.Add(currSong);
}
}
}
foreach (var song in songs)
song.Serialize(File.Open(Path.Combine(folderName, MakeValidFileName(song.Name + ".txt")), FileMode.Truncate, FileAccess.Write, FileShare.Write));
}
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"));
}
/// <inheritdoc/>
public virtual string GetConnectionString(NetworkCredential credential, Firma company)
{
var csb = new DbConnectionStringBuilder()
{
BrowsableConnectionString = true,
};
csb.Add("UserID", credential.UserName);
csb.Add("Password", credential.Password);
csb.Add("DatabaseName", company?.Owner ?? DefaultDatabase);
csb.Add("DatabaseFile", GetDatabasePath(company));
csb.Add("ServerName", "lxdbsrv");
csb.Add("CommLinks", $"TCPIP(Host={HostName})");
return csb.ConnectionString;
}
private string ConvertConnectionStringToNewPath(
string providerInvariantName, string filePathKey, string oldConnectionString, string newFilePath, bool useDataDirectoryMacro)
{
if (string.IsNullOrEmpty(filePathKey))
{
Debug.Fail("requires non-null, non-empty filePathKey");
return oldConnectionString;
}
if (LocalDataUtil.IsSqlMobileConnectionString(providerInvariantName))
{
// DbConnectionString does not support SQL Mobile
return GenerateNewSqlMobileConnectionString(oldConnectionString, newFilePath, useDataDirectoryMacro);
}
var dbConnectionStringBuilder = new DbConnectionStringBuilder();
dbConnectionStringBuilder.ConnectionString = oldConnectionString;
object filePathObject;
dbConnectionStringBuilder.TryGetValue(filePathKey, out filePathObject);
var filePath = filePathObject as string;
if (string.IsNullOrEmpty(filePath))
{
Debug.Fail("could not find filePath for filePathKey=" + filePathKey);
return oldConnectionString;
}
// replace old path with new one
dbConnectionStringBuilder.Remove(filePathKey);
if (useDataDirectoryMacro)
{
dbConnectionStringBuilder.Add(filePathKey, DataDirectoryMacro + Path.DirectorySeparatorChar + Path.GetFileName(newFilePath));
}
else
{
dbConnectionStringBuilder.Add(filePathKey, newFilePath);
}
return dbConnectionStringBuilder.ConnectionString;
}
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));
}
public void EquivalentToTest()
{
_builder.Add(SERVER, SERVER_VALUE);
DbConnectionStringBuilder sb2 = new DbConnectionStringBuilder();
sb2.Add(SERVER, SERVER_VALUE);
bool value = _builder.EquivalentTo(sb2);
Assert.True(value);
// negative tests
sb2.Add(SERVER + "1", SERVER_VALUE);
value = _builder.EquivalentTo(sb2);
Assert.False(value);
}
/// <summary>
/// Creates a connection string from the connection structure
/// </summary>
/// <param name="objConn">Instance of ConnectionStructure structure that holds a connection string to a database</param>
/// <returns>Connection String</returns>
private static string GetConnectionString(ConnectionStructure objConn)
{
DbConnectionStringBuilder objConnectionBuilder = new DbConnectionStringBuilder();
string ConnectionString;
try
{
objConnectionBuilder.Add("Data Source", objConn.DataSource);
objConnectionBuilder.Add("Initial Catalog", objConn.InitialCatalog);
objConnectionBuilder.Add("Trusted_Connection", objConn.TrustedConnection);
objConnectionBuilder.Add("User ID", objConn.UserID);
objConnectionBuilder.Add("Password", objConn.Password);
objConnectionBuilder.Add("Persist Security Info", objConn.PersistSecurityInfo);
objConnectionBuilder.Add("Min Pool Size", objConn.MinPoolSize);
objConnectionBuilder.Add("Max Pool Size", objConn.MaxPoolSize);
objConnectionBuilder.Add("Enlist", objConn.Enlist);
objConnectionBuilder.Add("Async", objConn.Async);
objConnectionBuilder.Add("MultipleActiveResultSets", objConn.MultipleActiveResultSets);
ConnectionString = objConnectionBuilder.ConnectionString;
}
catch (Exception ex)
{
throw new Exception(ex.ToString());
}
//finally
//{
// objConnectionBuilder = null;
//}
return ConnectionString;
}
