/// <summary> /// Initializes a connection string for use with integrated security /// </summary> /// <param name="connectString">A complete connection string to the database</param> /// <returns>The initialized connection string data</returns> /// <remarks> /// The connectString should contain a complete functional connection string, including any necessary /// parameters such as userID, password and Integrated Security settings. /// </remarks> internal static ConnectionStringData GetConnectionStringData(string connectString) { ArgumentValidation.CheckForEmptyString(connectString, "Connection String"); ConnectionStringData connectionStringData = GetConnectionStringData(); // Deconstruct the complete connection string and // load it into the connectionStringData object BuildConnectionStringDataFromConnectString(connectionStringData, connectString); return(connectionStringData); }
/// <summary> /// Initializes a connection string for use with integrated security /// </summary> /// <param name="server">The name of the server to connect to</param> /// <param name="database">The name of the database to connect to</param> /// <returns>The initialized connection string data</returns> internal static ConnectionStringData GetConnectionStringData(string server, string database) { ArgumentValidation.CheckForEmptyString(server, "Server"); ArgumentValidation.CheckForEmptyString(database, "Database"); ConnectionStringData connectionStringData = GetConnectionStringData(); connectionStringData.Parameters.Add(new ParameterData("Server", server)); connectionStringData.Parameters.Add(new ParameterData("Database", database)); connectionStringData.Parameters.Add(new ParameterData("Integrated Security", "True")); return(connectionStringData); }
/// <summary> /// Takes a connection string and breaks it down into its component name/value pairs, then loads the pairs /// into a <see cref="ConnectionStringData"/> object. /// </summary> /// <param name="connectionStringData">The data object to be loaded from the connectString</param> /// <param name="connectString">The connection string</param> /// <remarks> /// No attempt is made to validate the connection string nor any of its contents. If the string cannot be parsed /// an exception will be thrown. /// </remarks> internal static void BuildConnectionStringDataFromConnectString(ConnectionStringData connectionStringData, string connectString) { ArgumentValidation.CheckForNullReference(connectionStringData, "Connection String Data"); ArgumentValidation.CheckForEmptyString(connectString, "Connect String"); string[] items = connectString.Split(';'); foreach (string item in items) { if (item.Length > 0) { string[] parms = item.Split('='); connectionStringData.Parameters.Add(new ParameterData(parms[0], parms[1])); } } }
/// <summary> /// Creates a connection string data object initialized with username, password server and database /// </summary> /// <param name="server">The server to connect to</param> /// <param name="database">The database to connect to</param> /// <param name="userID">The UserID to connect as</param> /// <param name="password">The password to connect as</param> /// <returns>An initialized connection string object</returns> internal static ConnectionStringData GetConnectionStringData(string server, string database, string userID, string password) { ArgumentValidation.CheckForEmptyString(server, "Server"); ArgumentValidation.CheckForEmptyString(database, "Database"); ArgumentValidation.CheckForEmptyString(userID, "User ID"); ArgumentValidation.CheckForEmptyString(password, "Password"); ConnectionStringData connectionStringData = GetConnectionStringData(); connectionStringData.Parameters.Add(new ParameterData("Server", server)); connectionStringData.Parameters.Add(new ParameterData("Database", database)); connectionStringData.Parameters.Add(new ParameterData("User ID", userID)); connectionStringData.Parameters.Add(new ParameterData("password", password)); return(connectionStringData); }
/// <summary> /// Initializes a connection string for use with integrated security /// </summary> /// <param name="connectString">A complete connection string to the database</param> /// <param name="userID">The UserId to connect as</param> /// <param name="password">The password to connect as</param> /// <returns>The initialized connection string data</returns> /// <remarks> /// The connectString should contain a complete functional connection string, including any necessary /// parameters such as userID, password and Integrated Security settings. /// </remarks> internal static ConnectionStringData GetConnectionStringData(string connectString, string userID, string password) { ArgumentValidation.CheckForEmptyString(connectString, "Connection String"); ArgumentValidation.CheckForEmptyString(userID, "User ID"); ArgumentValidation.CheckForEmptyString(password, "Password"); ConnectionStringData connectionStringData = GetConnectionStringData(); // Deconstruct the complete connection string and // load it into the connectionStringData object BuildConnectionStringDataFromConnectString(connectionStringData, connectString); // Add the userID and password to the object connectionStringData.Parameters.Add(new ParameterData("User ID", userID)); connectionStringData.Parameters.Add(new ParameterData("password", password)); return(connectionStringData); }