C# Miscellaneous Examples

C# Basic

C# Data Type

C# OOP

C# IO

C# Graphics & UI

C# Advanced

Read connection string from config file in C#

How to get connection string from app.config in C#:

You can use the ConfigurationManager.ConnectionStrings property to get the connection string from the app.config file in C#. Here is an example:

string connectionString = ConfigurationManager.ConnectionStrings["MyConnectionString"].ConnectionString;
Console.WriteLine("Connection string is: " + connectionString);

This will get the value of the MyConnectionString connection string from the app.config file.

How to get connection string from web.config in C#:

You can use the ConfigurationManager.ConnectionStrings property to get the connection string from the web.config file in C#. Here is an example:

string connectionString = ConfigurationManager.ConnectionStrings["MyConnectionString"].ConnectionString;
Console.WriteLine("Connection string is: " + connectionString);

This will get the value of the MyConnectionString connection string from the web.config file.

Unable to read correctly adding connection string from app.config in C#:

Make sure you have added the connection string correctly to the app.config file. Here is an example of how to add a connection string to the app.config file:

<connectionStrings>
  <add name="MyConnectionString" connectionString="Data Source=myServer;Initial Catalog=myDatabase;Integrated Security=True;" providerName="System.Data.SqlClient" />
</connectionStrings>

Also, make sure you have added the System.Configuration namespace to your class file.

How to retrieve the Database Name from the connectionstring in configuration in C#:

You can use the SqlConnectionStringBuilder class to retrieve the database name from the connection string in configuration in C#. Here is an example:

string connectionString = ConfigurationManager.ConnectionStrings["MyConnectionString"].ConnectionString;
SqlConnectionStringBuilder builder = new SqlConnectionStringBuilder(connectionString);
string databaseName = builder.InitialCatalog;
Console.WriteLine("Database name is: " + databaseName);

This will retrieve the database name from the MyConnectionString connection string in the app.config or web.config file.

How to retrieve the Server Name from the connectionstring in configuration in C#:

You can use the SqlConnectionStringBuilder class to retrieve the server name from the connection string in configuration in C#. Here is an example:

string connectionString = ConfigurationManager.ConnectionStrings["MyConnectionString"].ConnectionString;
SqlConnectionStringBuilder builder = new SqlConnectionStringBuilder(connectionString);
string serverName = builder.DataSource;
Console.WriteLine("Server name is: " + serverName);

This will retrieve the server name from the MyConnectionString connection string in the app.config or web.config file.

C# Read Connection String from Config File:
Read a connection string from the app.config file using ConfigurationManager.ConnectionStrings.
```
string connectionString = ConfigurationManager.ConnectionStrings["ConnectionStringName"].ConnectionString;
```
ConfigurationManager.ConnectionStrings in C#:
Use ConfigurationManager.ConnectionStrings to access connection strings in C#.
```
string connectionString = ConfigurationManager.ConnectionStrings["ConnectionStringName"].ConnectionString;
```
Read Database Connection String from app.config:
Retrieve a database connection string from the app.config file.
```
string connectionString = ConfigurationManager.ConnectionStrings["DatabaseConnection"].ConnectionString;
```

Connection String Settings in C#:

Understand and manage connection string settings in C#.

ConnectionStringSettings connectionStringSettings = ConfigurationManager.ConnectionStrings["ConnectionStringName"];

AppSettings vs ConnectionStrings in C#:

Differentiate between AppSettings and ConnectionStrings sections in the configuration file.

// Reading from AppSettings
string settingValue = ConfigurationManager.AppSettings["SettingKey"];

// Reading from ConnectionStrings
string connectionString = ConfigurationManager.ConnectionStrings["ConnectionStringName"].ConnectionString;

ConfigurationManager.ConnectionStrings Example:
Use ConfigurationManager.ConnectionStrings to retrieve connection strings.
```
string connectionString = ConfigurationManager.ConnectionStrings["MyConnection"].ConnectionString;
```

Web.config Connection String C#:

Access connection strings stored in the web.config file.

string connectionString = ConfigurationManager.ConnectionStrings["DatabaseConnection"].ConnectionString;

C# Read Connection String from JSON Config File:

Read a connection string from a JSON configuration file.

// Reading from JSON file
string json = File.ReadAllText("config.json");
var settings = JsonConvert.DeserializeObject<Dictionary<string, string>>(json);
string connectionString = settings["DatabaseConnection"];

ConnectionStringSettings Class in C#:

Use the ConnectionStringSettings class to work with connection strings.

ConnectionStringSettings connectionStringSettings = ConfigurationManager.ConnectionStrings["MyConnection"];

Read Connection String from XML Config File in C#:

Retrieve a connection string from an XML configuration file.

// Reading from XML file
XDocument doc = XDocument.Load("config.xml");
string connectionString = doc.Root.Element("ConnectionStrings").Element("DatabaseConnection").Value;

Read Encrypted Connection String in C#:

Read an encrypted connection string from the configuration file.

// Decrypting the connection string
Configuration configuration = ConfigurationManager.OpenExeConfiguration(ConfigurationUserLevel.None);
configuration.ConnectionStrings.SectionInformation.UnprotectSection();
configuration.Save(ConfigurationSaveMode.Modified);
ConfigurationManager.RefreshSection("connectionStrings");

// Accessing the connection string
string connectionString = ConfigurationManager.ConnectionStrings["EncryptedConnection"].ConnectionString;

Database Connection Pooling in C#:

Utilize connection pooling for efficient database connections.

using (SqlConnection connection = new SqlConnection(connectionString)) {
    // Connection is automatically pooled
    connection.Open();
    // Perform database operations
}

C# SqlConnectionStringBuilder Example:

Build and manipulate SQL connection strings using SqlConnectionStringBuilder.

SqlConnectionStringBuilder builder = new SqlConnectionStringBuilder();
builder.DataSource = "localhost";
builder.InitialCatalog = "MyDatabase";
builder.UserID = "user";
builder.Password = "password";
string connectionString = builder.ConnectionString;

Entity Framework Connection String in C#:
Access and configure the Entity Framework connection string.
```
string connectionString = ConfigurationManager.ConnectionStrings["MyDbContext"].ConnectionString;
```

Dapper Connection String Configuration in C#:

Configure Dapper to use a specific connection string.

// Set Dapper default connection factory
Dapper.DefaultConnectionFactory = new SqlConnectionFactory(connectionString);