ShpToSql.SqlConnectionControl.SqlConnectionString.WithDatabase C# (CSharp) Method

WithDatabase() public method

Creates a copy of this connection string with the specified database instead of the current
public WithDatabase ( string databaseName ) : SqlConnectionString
databaseName string Name of the database.
return SqlConnectionString
        public SqlConnectionString WithDatabase(string databaseName)
        {
            return new SqlConnectionString
                       {
                           Server = Server,
                           Database = databaseName,
                           IntegratedSecurity = IntegratedSecurity,
                           UserName = UserName,
                           Password = Password,
                           Pooling = Pooling
                       };
        }

Usage Example

Esempio n. 1
0
        public List<string> GetDatabases(SqlConnectionString connectionString)
        {
            var databases = new List<string>();

            using (var conn = new SqlConnection(connectionString.WithDatabase("master")))
            {
                conn.Open();
                var serverConnection = new ServerConnection(conn);
                var server = new Server(serverConnection);
                databases.AddRange(from Database database in server.Databases select database.Name);
            }

            return databases;
        }
All Usage Examples Of ShpToSql.SqlConnectionControl.SqlConnectionString::WithDatabase