defining connection in class file

Question

Good morning, I am trying to build an application with asp.net mvc and ado.net I want to : 1) Define a connection object 2) Read the connection info from the database and put all the above information in a class that will return a connection object that would be accessible to all the other classes in the project. I am not opening the connetion in that, let's call it, connection class but just definition. Can someone help me out please?

Laxmidhar Sahoo · Answer

using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Threading.Tasks; using System.Data.SqlClient; namespace Tutorial.SqlConn { class DBSQLServerUtils { public static SqlConnection GetDBConnection( string datasource, string database, string username, string password) { // // Data Source=TRAN-VMWARE\SQLEXPRESS;Initial Catalog=simplehr;Persist Security Info=True;User ID=sa;Password=12345 // string connString = @ "Data Source=" +datasource+ ";Initial Catalog=" +database+ ";Persist Security Info=True;User ID=" +username+ ";Password=" +password; SqlConnection conn = new SqlConnection(connString); return conn; } }

Schleid Alex · Answer

I have done that but somehow I cannot create the object from the connection. Would you please post the code? I would really appreciate Regard

Salman Beg · Answer

You need to define everything inside class. Open the connection also inside the method. After that call it. Thanks.

Schleid Alex · Answer

Hi Thank you Salman Beg for you time. I am sorry I have not posted enough information. Here is what I have in mind I create the class dbConnection using system.configuration; using system.data; using system.data.sqlClient; Namespace dbConnection { Public class SqlConnection Connection private sqlConnection _mycon = new SqlConnection; private string _constring; _constring = ConfigurationManager.ConnectionString[0].ConnectionString; _mycon.ConnectionString = _constring; return _mycon } Now I create another class employee.cs public list T { connection MyCon = new Connection(); ..... MyCon.open } I am trying to achieve something like this but I cannot can someone point me my mistakes and help with a solution. Thanks in advance Schleid

Salman Beg · Answer

First create a class. Get connection string from web.config. Write the code for opening connection and everything. So whenever you want to perform any operation like crud then create the object of the class and call that method. Thanks.