Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Create A Generic Base Class
Message
General information
Forum:
ASP.NET
Category:
Coding, syntax and commands
Title:
Create A Generic Base Class
Miscellaneous
Thread ID:
01322719
Message ID:
01322719
Views:
47
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
Next
Reply
Map
View

Click here to load this message in the networking platform