ASP.NET MVC without Entity Framework database connection

Question

I have a project that uses ASP.NET MVC and follows three tier architecture. I want to add a class library that will have a base class which will contain the connection string and in the child class that connection string has to be called by pass the data source as string.

Base class:

public class DALConnection {
     public SqlConnection con = new SqlConnection("Data Source=ABC;Initial Catalog=HotelMgmt;Integrated Security=True");
}

Child class:

public class DataAccessOperation: DALConnection {
    // Some code
}

Instead of this I want to pass the connection string to the base class through child class as string.

Kirthika Murugavel · Accepted Answer · 2017-08-17 11:50:02Z

1

Do you think you could use the constructors to do that? (as below)

Base class:

public class DALConnection {

     public SqlConnection con;

     public DALConnection(string connectionString)
     {
          con = new SqlConnection(connectionString);
     }

}

Child class:

public class DataAccessOperation: DALConnection {

    //Some code
    public DataAccessOperation() : base("Data Source=ABC;Initial Catalog=HotelMgmt;Integrated Security=True")
    {

    }
}

edited Aug 17, 2017 at 11:50

Kirthika Murugavel

176 bronze badges

answered Sep 30, 2016 at 11:42

Rick Wolff

77512 silver badges31 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Kirthika Murugavel · Accepted Answer · 2017-08-17 09:58:56Z

1

Use a constructor to pass the connections strings and have the derived class call the base constructor.

Base class

public class DALConnection {
    protected string connectionString = "Data Source=ABC;Initial Catalog=HotelMgmt;Integrated Security=True";
    public SqlConnection con;

    public DALConnection(string connectionString) {
        if(connectionString!=null)
            this.connectionString = connectionString;
        con = new SqlConnection(this.connectionString);
    }
}

Child class:

public class DataAccessOperation: DALConnection {

    DataAccessOperation(string connectionString) : base(connectionString) {
    }

}

edited Aug 17, 2017 at 9:58

Kirthika Murugavel

176 bronze badges

answered Sep 30, 2016 at 11:42

Nkosi

249k38 gold badges472 silver badges506 bronze badges

Comments

garrati · Accepted Answer · 2016-09-30 11:59:50Z

0


public class DALConnection 
{
      public DALConnection(string _conString)
      {
            if(!String.IsNullOrEmpty(_conString))
            {
                con=new SqlConnection(_conString);
            }
            else 
            {
                //error handling
            }
      }      

      private SqlConnection con;

}

public class DataAccessOperation: DALConnection 
{
      public DataAccessOperation (string _conString) :base (_conString)
      {
      }


}

answered Sep 30, 2016 at 11:59

garrati

511 silver badge9 bronze badges

Collectives™ on Stack Overflow

ASP.NET MVC without Entity Framework database connection

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related