使用 MSSQL 数据库的类的权宜之计

创建了一个特殊的帮助类来连接和使用数据库。

如果不需要或没有经验，使用这样的课程是否合理Entity Framework。请大家指出不足并提出其他意见。

类本身：

public class DBHelper
{
        public static string sqlConnectionString = "Data Source=<default>;Initial Catalog=<default>;Persist Security Info=<default>;User ID=<default>;Password=<default>";
        public bool connectionOnline = false;
        public SqlConnection sqlConnection = null;
        public DBHelper(string _DataSource, string _InitialCatalog, string _User, string _Password)
        {
                string AssebledConnectionString =
                        "Data Source=" + _DataSource + ";" +
                        "Initial Catalog=" + _InitialCatalog + ";" +
                        "Persist Security Info=True;" +
                        "User ID=" + _User + ";" +
                        "Password=" + _Password;
                connectionOnline = false;
                InitializeConnection(AssebledConnectionString);
        }
        public DBHelper()
        {
                connectionOnline = false;
                InitializeConnection(sqlConnectionString);
        }
        public DBHelper(string sqlCustomConnectionString = null)
        {
                connectionOnline = false;
                InitializeConnection(sqlCustomConnectionString);
        }
        public void Dispose()
        {
                this.DisengageConnection();
                sqlConnection = null;
        }
        void InitializeConnection(string sqlCustomConnectionString = null)
        {
                try
                {
                        if ((connectionOnline) || (sqlConnection != null)) return;
                        sqlConnection = new SqlConnection(sqlCustomConnectionString ?? sqlConnectionString);
                        sqlConnection.Open();
                        connectionOnline = true;
                }
                catch
                {
                        connectionOnline = false;
                        //Не удалось соединиться с базой данных
                }
        }
        void DisengageConnection()
        {
                if ((!connectionOnline) || (sqlConnection == null)) return;
                sqlConnection.Close();
                connectionOnline = false;
        }
        public SqlCommand GetStoredProc(string procedureName)
        {
                SqlCommand sqlCommand = new SqlCommand(procedureName, sqlConnection)
                {
                        CommandType = CommandType.StoredProcedure
                };
                return sqlCommand;
        }
        public DataSet GetDataSet(SqlCommand sqlCommand)
        {
                SqlDataAdapter sqlDataAdapter = new SqlDataAdapter(sqlCommand);
                DataSet dsTable = new DataSet();
                sqlDataAdapter.Fill(dsTable);
                return dsTable;
        }
        public DataTable GetResultTable(SqlCommand sqlCommand, int dataTableNumber = 0)
        {
                SqlDataAdapter sqlDataAdapter = new SqlDataAdapter(sqlCommand);
                DataSet dsTable = new DataSet();
                sqlDataAdapter.Fill(dsTable);
                if ((dsTable.Tables.Count > 0) && (dsTable.Tables.Count - 1 >= dataTableNumber))
                {
                        return dsTable.Tables[dataTableNumber];
                }
                else
                {
                        return new DataTable();
                }
        }        
}    

使用存储过程的示例：

DBHelper db = new DBHelper();
SqlCommand sqlCommand = db.GetStoredProc("<имя хранимой процедуры>");
sqlCommand.Parameters.AddWithValue("@<имя параметра 1>",<param1_value>);
sqlCommand.Parameters.AddWithValue("@<имя параметра 2>",<param2_value>);
//...
sqlCommand.Parameters.AddWithValue("@<имя параметра N>",<paramN_value>);
//далее действия в зависимости от характера хранимой процедуры
//либо простое исполнение
sqlCommand.ExecuteNonQuery();
//либо получение данных
DataTable dataTable = db.GetResultTable(sqlCommand);