Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Create A Generic Base Class
Message
Information générale
Forum:
ASP.NET
Catégorie:
Code, syntaxe and commandes
Titre:
Create A Generic Base Class
Divers
Thread ID:
01322719
Message ID:
01322719
Vues:
48
I have the following code which returns a SQL Connection object:
public SqlConnection GetConnection()
{
    // Get the connection string
    string sConnString = _GetConnString();

    // Create a connection and assign the connection string to it
    SqlConnection oConn = new SqlConnection();
    oConn.ConnectionString = sConnString;

    // Try to open the connection
    try
    {
        oConn.Open();
    }
    catch (SqlException e)
    { 
    }


    // Test the connection and if the connection was opened, return the connection
    // otherwise return null
    if (oConn.State == ConnectionState.Open)
    {
        // Return the connection
        return oConn;
    }
    else
    {
        return null;
    }

}
I anticipate having to connect to other DB's, so I would like to create an abstract base
class that has the GetConnection method, as well as other data methods. It will also
have connection string and other DB related properties on it. Then, all I have to do is
subclass it and modify it where needed.

I'm not sure how to write a base class for this. Can anyone help out a newby?

Thanks
Everything makes sense in someone's mind
public class SystemCrasher :ICrashable
In addition, an integer field is not for irrational people
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform