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; }