C# – How to read a connectionstring in .net 4.5

cconnection-stringnetvb.netweb.config

How do I read a value from the web.config file for a connectionstring in the 4.5 .net framework?

I'm using system.configuration which I have a reference to and a using statement, but the only thing coming up after that to use is .ConfigurationSettings.Appsettings.

No connectionstringsettings.

Best Answer

using System.Configuration;

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

Edit (Adding in a reference to System.Configuration:

Right click on your project -> Add Reference -> Select the .NET Tab -> Select System.Configuration -> OK

http://msdn.microsoft.com/en-us/library/system.configuration.configurationmanager.aspx

Related Solutions

C# – How to enumerate an enum

foreach (Suit suit in (Suit[]) Enum.GetValues(typeof(Suit)))
{
}

Note: The cast to (Suit[]) is not strictly necessary, but it does make the code 0.5 ns faster.

C# – Case insensitive ‘Contains(string)’

You could use the String.IndexOf Method and pass StringComparison.OrdinalIgnoreCase as the type of search to use:

string title = "STRING";
bool contains = title.IndexOf("string", StringComparison.OrdinalIgnoreCase) >= 0;

Even better is defining a new extension method for string:

public static class StringExtensions
{
    public static bool Contains(this string source, string toCheck, StringComparison comp)
    {
        return source?.IndexOf(toCheck, comp) >= 0;
    }
}

Note, that null propagation ?. is available since C# 6.0 (VS 2015), for older versions use

if (source == null) return false;
return source.IndexOf(toCheck, comp) >= 0;

USAGE:

string title = "STRING";
bool contains = title.Contains("string", StringComparison.OrdinalIgnoreCase);

Best Answer

Related Solutions

C# – How to enumerate an enum

C# – Case insensitive ‘Contains(string)’

Related Topic