Writing my own Provider Class in ASP.NET

Question

Note: I DON't want to write custom membership provider.

I want to write my own Provider class so I can define it in web.config and access it like Membership class.

Here is a sample of my class (it has many other static methods):

public static class MySqlHelper
{
    private static string constring = ConfigurationManager.ConnectionStrings["MyConnString"].ConnectionString;

    public static int ExecuteNonQuery(string mysqlquery)
    {
        SqlConnection conn = new SqlConnection(connString);
    SqlCommand cmd = new SqlCommand(mysqlquery, conn);
    int result;

    try
    {
        conn.Open();
        result= cmd.ExecuteNonQuery();
    }
    finally
    {
        conn.Close();
    }
    return result;

    }
}

Usage: MySqlHelper.ExecuteNonQuery("select * from customers");

Now as you see I have hard-coded the name of connectionstring i.e. "MyConnString". I am planning to make it dynamic.

So I was wondering if I can make it like static built-in Membership class, where I can define the connectionStringName in web.config. This way the class can be made re-usable without always naming my connectionstring in web.config to "MyConnString".

1: I DON'T want to pass connectionstring in every static method as a parameter.

2: I must be able to access the methods similar to Membership.CreateUser i.e. static.

I am looking over the web in parallel but any inputs/guidance will help.

Edited: I have updated my code sample, to clear some confusion about issues using static class. Here is a new question I posted to clarify that. Sorry about confusion.

Answer 1

the only thing i can think of that meets the qualifications you laid out is to use dependency injection, a static constructor, and inject in an something like an IConnectionStringProvider. this seems like about the most convoluted thing i can think of, so you might like it. :)

edit

after reading your comment, it seems like you just want to be able to reference any connection string, but only one connection string per application. i'd say just add an element to appSettings named MySqlProviderConnection with the value being the name of the connection string you want to use.

then in your helper, check for the existence of the appsetting, get its value, and pass it in to your ConfigurationManager.ConnectionStrings call. that way your provider could use any connection you want, without changing any code.