internal void BuildConnectionString(Credentials credentials) { StringBuilder sb = new StringBuilder(); sb.AppendFormat("Server={0}{1};", adminConnection, instance); sb.AppendFormat("Database={0};", database); if (null != credentials) { if (credentials.IsSqlAccount()) { sb.AppendFormat("User ID={0};Password={1};", credentials.GetUsername(), credentials.GetPassword()); } else { sb.Append("Integrated Security=SSPI;"); sb.AppendFormat("uid={0};pwd={1};", credentials.GetUsername(), credentials.GetPassword()); } } else { sb.Append("Integrated Security=SSPI;"); } sb.AppendFormat("Connection Timeout={0};", connectionTimeout); if (!string.IsNullOrEmpty(applicationName)) { sb.Append(applicationName); } if (!string.IsNullOrEmpty(encryptString)) { sb.Append(encryptString); } if (!string.IsNullOrEmpty(trustCertificate)) { sb.Append(trustCertificate); } if (!string.IsNullOrEmpty(workstationId)) { sb.Append(workstationId); } #if DEBUG //Console.WriteLine("ConnectionString: {0}", sb.ToString()); #endif connection = new SqlConnection { ConnectionString = sb.ToString() }; sb.Clear(); GC.Collect(); }
internal bool Connect(Credentials credentials) { #if DEBUG Console.WriteLine("Domain Controller : {0}", domainController); #endif string distinguishedName; if (null != credentials) { try { directoryEntry = new DirectoryEntry(domainController, credentials.GetUsername(), credentials.GetPassword()); distinguishedName = (string)directoryEntry.Properties["distinguishedName"].Value; if (!string.IsNullOrEmpty(ldapPath)) { ldapPath = string.Format("/{0},{1}", ldapPath, distinguishedName); directoryEntry = new DirectoryEntry(domainController + ldapPath, credentials.GetUsername(), credentials.GetPassword()); } } catch (Exception ex) { Console.WriteLine("{0} : {1}", domainController, ex.Message); return(false); } } else { try { directoryEntry = new DirectoryEntry(domainController); distinguishedName = (string)directoryEntry.Properties["distinguishedName"].Value; if (!string.IsNullOrEmpty(ldapPath)) { ldapPath = string.Format("/{0},{1}", ldapPath, distinguishedName); directoryEntry = new DirectoryEntry(domainController + ldapPath); } } catch (Exception ex) { Console.WriteLine("{0} : {1}", domainController, ex.Message); return(false); } } #if DEBUG Console.WriteLine("DistinguishedName : {0}", distinguishedName); #endif return(true); }