Connection String

Ramco Ramco

5y1k.NET

string cs = ConfigurationManager.ConnectionStrings["Cnn"].ConnectionString;

I want that this code shoudl be written at one place & not in any Model.

Thanks

7 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sachin Singh5y ago
Accepted answer
create one static class and a static method anywhere in your project
public static class Common
  {
  public static string GetCon()
{
    string connectionString =
      ConfigurationManager.ConnectionStrings["Cnn"].ConnectionString;
return connectionString;
}
  }
now call this as
string cs=Common.GetCon();
Kiran Mohanty5y ago
Hi,
you can't define class property inside it's constructor. Define it as below.
namespace MyApplication.Models
{
  public class Common
  {
    public static string connectionString =
      ConfigurationManager.ConnectionStrings["Cnn"].ConnectionString;
  }
}
Ramco Ramco5y ago
Hi

I have created like this. Is it o.k

Thanks
Salman Beg5y ago
In your solution, create a common class and in that define connection string and wherever you want to access it just use that common class and access that connection string. See this below link for example, https://www.c-sharpcorner.com/UploadFile/7d3362/various-ways-to-specify-connection-string-in-Asp-Net-web-app/ https://stackoverflow.com/questions/13927352/single-declaration-of-connection-string-in-application
Ramco Ramco5y ago
Hi Sachin

I am trying like this , it is giving error :- } expected

namespace MyApplication.Models
{
public class Common
{
public Common()
{
public static string connectionString = ConfigurationManager.ConnectionStrings["Cnn"].ConnectionString;
}
}
}

Thanks
Ramco Ramco5y ago
Hi Suresh

Where i should define this

Thanks
Suresh M5y ago
youe can define the connection string in constan

public const string cs = ConfigurationManager.ConnectionStrings["Cnn"].ConnectionString;

Define this in your common class