Dynamic connectionstring without web.config RSS

• • Reply
  

  whisky

  Participant

  1162 Points

  577 Posts

  Dynamic connectionstring without web.config

  Dec 03, 2012 12:21 PM|LINK

  Hi,

  I am using EntLib and I need to pass a connectionstring dynamically and connect to a stored procedure.

  How can I do that?

   

  This is what I tried but I get an error:

  public class CustomDatabaseFactory
  {
      private string serverName;
      private string connectionString;
      private string databaseName;
  
      public CustomDatabaseFactory(string ServerName, string DatabaseName)
      {
  
          this.serverName = ServerName;
  
          this.databaseName = DatabaseName;
  
      }
  
  
      static readonly DbProviderFactory dbProviderFactory =
          DbProviderFactories.GetFactory("System.Data.SqlClient");
      public Database CreateDatabase(string connectionString)
      {
          Database db = null;
  
          //database mydb = new EnterpriseLibrary.Data.Sql.SqlDatabase("connection string here");
  
          db = new GenericDatabase(connectionString, dbProviderFactory);
          return db;
      }
  
      public Database GetDatabase(string connectionString)
      {
  
          DbConnectionStringBuilder builder = new DbConnectionStringBuilder();
  
          Database db = null;
  
          db = new GenericDatabase(connectionString, dbProviderFactory);
  
          return db;
  
      }
  
      public DataTable PMHistory(int Id, string connectionString)
      {
          string spName = "stp_pm_History";
  
          DataTable dt = new DataTable();
          Database db = DatabaseFactory.CreateDatabase(connectionString);
  
          object[] parameters = { Id };
  
          DbCommand command = db.GetStoredProcCommand(spName, parameters);
  
          return dt;
  
      }
  
  
  
  }
  
  public partial class _Default : System.Web.UI.Page
  {
      protected ExportFile createFile;
      
      protected void Page_Load(object sender, EventArgs e)
      {
          try
          {
           string    connectionString = "Data Source=SQLDEV01;Initial Catalog=test;Persist Security Info=True;User ID=rrrrr;Password=xxxxx";
                    CustomDatabaseFactory getData = new CustomDatabaseFactory("", "");
           getData.PMHistory(1, connectionString); //FALLS HERE         }
  
          catch (Exception ex)
          {
              Response.Write(ex.ToString());
          }
      }
  }

  System.Configuration.ConfigurationErrorsException: The requested database Data Source=SQLDEV01;Initial Catalog=test;Persist Security Info=True;User ID=rrrrr;Password=xxxxx is not defined in configuration. at Microsoft.Practices.EnterpriseLibrary.Data.DatabaseConfigurationView.ValidateConnectionStringSettings

  Thanks for the help