DbDatabase Class

The SqlDatabase class contains the core functionality of establishing a connection with an SQL Server database and executing simple stored procedures. USAGE - Create a class which derives from this, and specify a Provider. I.E public bool IsUser(string userName, string password) { Provider = connectionString.ProviderName; string queryText = string.Format("select * from users where UserID = {0} and password = {1}",GetDBParameterString("UserId"),GetDBParameterString("Password")); DbParameter[] parameters = { GetParameter("UserId",userName), GetParameter("Password",password) }; parameters[0].Value = userName; parameters[1].Value = password; DbResultSet resultSet = RunQuery(ConnectionString.ConnectionString, queryText, parameters); bool isUser = resultSet.HasRows; resultSet.Close(); return isUser; } The DbResultSet class can be used to iterate through returned data quite nicely : i.e. DbResultSet resultSet = RunQuery(ConnectionString.ConnectionString, queryText, parameters); while(resultset.Next(){ string returnedValue = resultSet.GetString("ReturnedFieldName"); } resultSet.Close(); More functionality for the DbResultSet is explained in the DbResultSet file, and the ResultSet file.

public abstract class DbDatabase

Public MustInherit Class DbDatabase