Does .net framework include interface for configuring connection to SQL Server?

Question

Does anybody know if .Net Framework include interface for configuring connection to SQL Server? For example in Java/Oracle we have Universal Connection Pool (UCP) and oracle.ucp.ConnectionLabelingCallback it can helps to configure your database connection. And now I try to find the same feature in .Net/SqlServer. Firstable I would like to handle each connection to database and make some things before my application will execute some statemens (sql queries). For example: I'd like to audit user activities. Any user of my application try to add data in the database and I need to log this activity. Before executing insert query I can save transaction_id for this user in the database and after insert I can get this user by transaction_id (User it is not database user, but it is a user of my application because my application uses only one account to connect to Sql Server). Thank you for help and I apologize for my English.

Answer 1

Your asking two questions. I'll answer the one in the title. .Net has the SqlConnection class. See https://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlconnection(v=vs.110).aspx

Here is how it is typically used. The using ensures its disposed of properly.

using (SqlConnection connection = new SqlConnection(connectionString))
{

    connection.Open();
    // Do work here; connection closed on following line.
}

You will also want to know how the connection string is formatted. See:

How to set SQL Server connection string?

https://www.connectionstrings.com/sql-server-2012/

In addition to the SqlConnection, there are more ways to control how a query is run using the SqlCommand. See https://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlcommand(v=vs.110).aspx

Here is a simple example:

     SqlConnection conn = new SqlConnection(connectionString);

     using (SqlCommand cmd = new SqlCommand(commandText, conn)) {
        cmd.CommandType = CommandType.Text;
        cmd.Parameters.AddRange(parameters);

        conn.Open();
        SqlDataReader reader = cmd.ExecuteReader();


     }

You can google ADO.NET examples for more. Like http://www.csharp-station.com/Tutorial/AdoDotNet/Lesson02