CODEWITHSUNDEEP
c#sqlconnection
user1590636
user1590636

Reputation: 1194

in c# global connection to be used in all classes

I've a connection string saved to Properties.Settings.Default, i need to use an sql connection in all classes without having to declare it everytime, so how should it be declared?

Upvotes: 2

Views: 21977

Answers (5)

Moha Dehghan
Moha Dehghan

Reputation: 18443

You actually don't need to use a single SqlConnection everywhere. A better approach would be to create a class to manage you data access. Typically this is the duty of your Data Access Layer (DAL). DAL is a set of classes that handle all the database related stuff.

A very simple class for this purpose could be something like this:

public class DatabaseManager
{
    private static DatabaseManager _instance;
    private DatabaseManager()
    {
    }

    static DatabaseManager()
    {
        _instance = new DatabaseManager();
    }

    public DatabaseManager Instance
    {
        get { return _instance; }
    }

    private string GetConnectionString()
    {
        return Properties.Settings.Default.MyConnectionString;
    }

    public SqlConnection CreateConnection()
    {
        return new SqlConnection(GetConnectionString());
    }
}

You can extend this class to contain another methods to execute your queries.

I highly recommend you to use an ORM (Object-Relational Mapper) like Entity Framework.

Upvotes: 2

Codesleuth
Codesleuth

Reputation: 10541

I've have something similar set up in an old project like so. It's worth noting that you should always be using a new SqlConnection for all your operations, because of connection pooling.

public static class SqlConnectionUtil
{
    public static string DefaultConnectionString { get; private set; }

    static SqlConnectionUtil()
    {
        SqlConnectionUril.DefaultConnectionString = 
                Properties.Settings.Default.TheConnectionString;
    }

    public static SqlConnection Create()
    {
        return new SqlConnection(SqlConnectionUtil.DefaultConnectionString);
    }
}

You would then use it like this.

using (var connection = SqlConnectionUtil.Create())
{
    using (var command = connection.CreateCommand())
    {
        // do things.
    }
}

Upvotes: 1

user1968030
user1968030

Reputation:

You can use this code for get coonection string

      var      defaultConn= new SqlConnection(ConfigurationManager.AppSettings["defaultConn"].ToString());

Upvotes: 0

andy
andy

Reputation: 6079

It can be done with the help of STATIC variable in any class

Upvotes: 2

BlackBear
BlackBear

Reputation: 22979

Whenever you instantiate a new object pass to its constructor a reference to that connection.

Upvotes: 1

Related Questions