Is there any connection string parser in C#?

by

Yes, there’s the System.Data.Common.DbConnectionStringBuilder class.

The DbConnectionStringBuilder class
provides the base class from which the
strongly typed connection string
builders (SqlConnectionStringBuilder,
OleDbConnectionStringBuilder, and so
on) derive. The connection string
builders let developers
programmatically create syntactically
correct connection strings, and parse
and rebuild existing connection
strings.

The subclasses of interest are:

System.Data.EntityClient.EntityConnectionStringBuilder
System.Data.Odbc.OdbcConnectionStringBuilder
System.Data.OleDb.OleDbConnectionStringBuilder
System.Data.OracleClient.OracleConnectionStringBuilder
System.Data.SqlClient.SqlConnectionStringBuilder

For example, to “peek out the Data Source” from a SQL-server connection string, you can do:

var builder = new SqlConnectionStringBuilder(connectionString);
var dataSource = builder.DataSource;

More Related Contents:

  1. How to use HttpWebRequest (.NET) asynchronously?
  2. Easiest way to compare arrays in C#
  3. XML serialization of interface property
  4. How do arrays in C# partially implement IList?
  5. What is the best way to store user settings for a .NET application?
  6. How to save a List on Settings.Default?
  7. Escape invalid XML characters in C#
  8. Can I get command line arguments of other processes from .NET/C#?
  9. How can I treat the circle as a control after drawing it? – Moving and selecting shapes
  10. How to run a Task on a custom TaskScheduler using await?
  11. How to read attribute value from XmlNode in C#?
  12. What is the fastest way to create a checksum for large files in C#
  13. How to set system environment variable in C#?
  14. Entity Framework/Linq to SQL: Skip & Take
  15. Button inside a WinForms textbox
  16. Why is LINQ .Where(predicate).First() faster than .First(predicate)?
  17. How to extend IdentityUser with custom property
  18. How to concatenate two IEnumerable into a new IEnumerable?
  19. Is there an IEnumerable implementation that only iterates over it’s source (e.g. LINQ) once?
  20. C# int, Int32 and enums
  21. How to do an “in” query in entity framework?
  22. TLS 1.2 not negotiated in .NET 4.7 without explicit ServicePointManager.SecurityProtocol call
  23. Better way to install IIS7 programmatically
  24. Explanation of Func
  25. Subscribe to INotifyPropertyChanged for nested (child) objects
  26. How do I minimize a WinForms application to the notification area?
  27. .net connection pooling
  28. Encryption compatible between Android and C#
  29. Repository Pattern, POCO, and Business Entities
  30. Two Types not equal that should be

Leave a Comment