public virtual DataTable QueryDataTable(String sql, String tableName, DbParameter[] parameters, CommandType cmdType = CommandType.Text)
{
using (var cmd = _dbConnection.CreateCommand())
{
cmd.CommandText = sql;
cmd.CommandType = cmdType;
if (parameters != null && parameters.Length > 0)
{
cmd.Parameters.AddRange(parameters);
}
using (var adapter = _database.GetDataAdapter())
{
var table = String.IsNullOrEmpty(tableName) ? new DataTable() : new DataTable(tableName);
adapter.SelectCommand = cmd;
adapter.Fill(table);
return(table);
}
}
}
