defining connection in class file

Schleid Alex

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?

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Laxmidhar Sahoo6y ago
Accepted answer
1. using System;
2. using System.Collections.Generic;
3. using System.Linq;
4. using System.Text;
5. using System.Threading.Tasks;
6. using System.Data.SqlClient;
9. namespace Tutorial.SqlConn
10. {
11. class DBSQLServerUtils
12. {
14. public static SqlConnection
15. GetDBConnection(string datasource, string database, string username, string password)
16. {
17. //
18. // Data Source=TRAN-VMWARE\SQLEXPRESS;Initial Catalog=simplehr;Persist Security Info=True;User ID=sa;Password=12345
19. //
20. string connString = @"Data Source="+datasource+";Initial Catalog="
21. +database+";Persist Security Info=True;User ID="+username+";Password="+password;
23. SqlConnection conn = new SqlConnection(connString);
25. return conn;
26. }
29. }
0

Schleid Alex6y ago

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 Beg6y ago

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

Schleid Alex6y ago

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 Beg6y ago

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.