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?