How to use connecting string at our web Application?

Question

public static string CONNECTION_STRING = "";
public static string getconnection()
{
if (CONNECTION_STRING.Trim() == "")
{
               CONNECTION_STRING = ConfigurationManager.ConnectionStrings["BloggingDatabase"].ConnectionString;
           }
           return CONNECTION_STRING;
}

   }

Rijwan Ansari · Answer

Your code seems okay to get connection string value using function. However, you can do in this way. Sample: private static string sqlConnectionString = string.Empty; public static string GetConnectionString() { if (string.IsNullOrEmpty(sqlConnectionString)) { sqlConnectionString = ConfigurationManager.ConnectionStrings["BloggingDatabase"].ConnectionString; } return sqlConnectionString; } Now, we use connection string to do database stuffs like adding, updating, deleting and querying records from database. We execute queries (SQL query, Stored Procedures, Views and so on). We can use in ADO.NET, Entity framework and Dapper for database operations. You can find numerous blogs in google. CRUD for ASP.NET using Entity framework, ADO.NET or Dapper.

Rajeesh Menoth · Answer

Hi, The simple microsoft doc for connection string in c# https://docs.microsoft.com/en-us/aspnet/mvc/overview/getting-started/introduction/creating-a-connection-string Another Reference : https://www.c-sharpcorner.com/UploadFile/7d3362/various-ways-to-specify-connection-string-in-Asp-Net-web-app/

Gajendra Jangid · Answer

Try this link https://www.c-sharpcorner.com/UploadFile/7d3362/various-ways-to-specify-connection-string-in-Asp-Net-web-app/