public DataSet GetDataSet(string sql)
{
var command = _sqlConnection.CreateCommand();
command.CommandText = sql;
_setSqlParameters(command);
if (_sqlTransaction != null)
{
command.Transaction = _sqlTransaction;
}
var adapter = SqlObject.CreateAdapter(command);
DataSet dtSet = new DataSet();
adapter.Fill(dtSet);
SqlParameters = new List <SqlParamWrapper>();
return(dtSet);
}