public ResponseDTO <dynamic> ExecuteQuery(ExecuteQueryRequestDTO requestQuery)
{
try
{
string connectionString = "Data Source=DESKTOP-46MKD1L; Integrated Security=True;Initial Catalog=" + requestQuery.Database + ";";
var dataTable = new DataTable();
using (SqlConnection con = new SqlConnection(connectionString))
{
con.Open();
using (SqlCommand cmd = new SqlCommand(requestQuery.Query, con))
{
using (SqlDataReader dr = cmd.ExecuteReader())
{
dataTable.Load(dr);
}
}
}
return(Responses.OKGetAll <dynamic>("Class", new
{
columns = dataTable.Columns.Cast <DataColumn>()
.Select(x => x.ColumnName)
.ToArray(),
Rows = dataTable.Rows.Cast <DataRow>()
.Select(x => x.ItemArray)
.ToArray(),
}));
}
catch (Exception ex)
{
return(Responses.SomethingWentWrong <dynamic>(ex.Message, null));
}
}
public IActionResult ExecuteQuery(ExecuteQueryRequestDTO executeQueryRequestDTO)
{
return(Ok(_databaseTutorUOW.QueryBuilderRepo.ExecuteQuery(executeQueryRequestDTO)));
}
