How to check if connection string is valid?

by

You could try to connect? For quick (offline) validation, perhaps use DbConnectionStringBuilder to parse it…

    DbConnectionStringBuilder csb = new DbConnectionStringBuilder();
    csb.ConnectionString = "rubb ish"; // throws

But to check whether the db exists, you’ll need to try to connect. Simplest if you know the provider, of course:

    using(SqlConnection conn = new SqlConnection(cs)) {
        conn.Open(); // throws if invalid
    }

If you only know the provider as a string (at runtime), then use DbProviderFactories:

    string provider = "System.Data.SqlClient"; // for example
    DbProviderFactory factory = DbProviderFactories.GetFactory(provider);
    using(DbConnection conn = factory.CreateConnection()) {
        conn.ConnectionString = cs;
        conn.Open();
    }

More Related Contents:

  1. Entity Framework change connection at runtime
  2. Get connection string from App.config
  3. How can I set an SQL Server connection string?
  4. Entity Framework Timeouts
  5. SQL Express connection string: mdf file location relative to application location
  6. Read connection string from web.config
  7. How to read connection string in .NET Core?
  8. What is the connection string for localdb for version 11
  9. What is IMEX within OLEDB connection strings?
  10. Help with a OleDB connection string for excel files
  11. System.Data.SqlClient.SqlException: Login failed for user
  12. How to fix “The ConnectionString property has not been initialized”
  13. encrypt SQL connectionstring c#
  14. Get ConnectionString from appsettings.json instead of being hardcoded in .NET Core 2.0 App
  15. How do I use Web.Config transform on my connection strings?
  16. Persist Security Info Property=true and Persist Security Info Property=false
  17. Different text editor in .net development environment [closed]
  18. c# when pressing a button add totals together [closed]
  19. byte[] to hex string [duplicate]
  20. I didn’t find “ZipFile” class in the “System.IO.Compression” namespace
  21. Does lock() guarantee acquired in order requested?
  22. How Math.Pow (and so on) actually works
  23. How can you add a Certificate to WebClient (C#)?
  24. IMAP auth in Office 365 using OAuth2
  25. Caching in WCF?
  26. Open dropdown(in a datagrid view) items on a single click
  27. What’s Wrong with an ArrayList?
  28. How to log Trace messages with log4net?
  29. Why do arrays in .net only implement IEnumerable and not IEnumerable?
  30. Call has been made on garbage collected delegate in C#?

Leave a Comment