Web.Config File

    The main benefits of having a config file in any web project is that it is a single file which contain

  • Database connections
  • Caching Settings
  • Session states
  • Error Handling
  • Security   
 and if you want to change any configuration setting than you just need to change at a single place and need not to deploy the project again  and if you put all those code in different files like you are giving connection string in each file where you need and than you need a  change in the string than you need to change the code in all the  file at every place which will be a tedious task and Moreover  you  need to rebuild the solution and deploy it again.      

Comments

  1. AlleviationsDecember 17, 2019 at 12:55 AM

    my project do not have any config file so how to deal with it??

    ReplyDelete
    Replies
    1. AlleviationsJanuary 14, 2020 at 4:04 AM

      depends on requirements still u can make a file giving it name as app.config and add the requisite tag in it

      Delete

Post a Comment

Popular posts from this blog

Npgsql query and format with output parameters

  public string UploadExceldata(string json)         {             string connectionString = String.Format(new Connection().ConnectionString);             DataSet ds = new DataSet();             BaseResultData oBaseResult = new BaseResultData();             var connection = new Npgsql.NpgsqlConnection(connectionString);             try             {                                if (!(connection.State == ConnectionState.Open))                 {                     connection.Open();                 }                 //NpgsqlTransaction trans = connection.BeginTransaction();                 var command = new Npgsql.NpgsqlCommand("systemtracker_dbo.pr_create_user_from_excel_json", connection);                 command.CommandType = System.Data.CommandType.StoredProcedure;                 IDbDataAdapter dbDataAdapter = new NpgsqlDataAdapter();                 //Parameter Settings                 var parameter = command.CreateParameter();                 parameter.ParameterName =
Read more

Npgsql Helper class

 using System; using System.Collections.Generic; using System.Text; using System.Data; using Npgsql; using NpgsqlTypes; namespace AI_Portal_Cloud.DAL {     public class clsPSQLHelper : IDisposable     {         private NpgsqlConnection connection = null;         private String connectionString = "dbConnection";         private NpgsqlDataAdapter sqlData = new NpgsqlDataAdapter();         public NpgsqlCommand sqlCmd = new NpgsqlCommand();                  // {0} : IP, {1} : DB Name, {2} : userID, {3} : userPW         private String connectionFormat = "Server={0};Database={1};User Id={2};Password={3};Port={4}";         public String ConnectionString         {             set             {                 connectionString = value;             }         }         #region Constructors         public clsPSQLHelper()         {             //             // TODO: Add constructor logic here             //             string strConn = String.Format(new Connection().ConnectionS
Read more