Breaking News: Grepper is joining You.com. Read the official announcement!

sql queries are stored in database settings.

theenescresta answered on August 10, 2023 Popularity 1/10 Helpfulness 1/10

answer sql queries are stored in database settings.

sql queries are stored in database settings.

Comment

using Microsoft.Data.SqlClient;
using System.Data;

[HttpGet]
public IActionResult ExecuteQuery(string requestType, string parameter)
{
    string connectionString = Configuration.GetConnectionString("DefaultConnection");
    string sqlQuery;

    // Retrieve the SQL query for the specified request type from the configuration settings
    sqlQuery = Configuration.GetSection("SqlQueries").GetValue<string>(requestType);

    if (string.IsNullOrEmpty(sqlQuery))
    {
        return BadRequest("Invalid requestType parameter");
    }

    // Execute the SQL query using the connection string and parameter
    using (SqlConnection connection = new SqlConnection(connectionString))
    {
        using (SqlCommand command = new SqlCommand(sqlQuery, connection))
        {
            command.Parameters.Add("@param", SqlDbType.VarChar).Value = parameter;

            connection.Open();
            DataTable dataTable = new DataTable();
            using (SqlDataAdapter dataAdapter = new SqlDataAdapter(command))
            {
                dataAdapter.Fill(dataTable);
            }
            connection.Close();

            // Convert the DataTable to a JSON string and return it as the response
            string jsonResult = JsonConvert.SerializeObject(dataTable, Formatting.Indented);
            return Ok(jsonResult);
        }
    }
}

Popularity 1/10 Helpfulness 1/10 Language sql

Source: chat.openai.com

Tags: database sql

Link to this answer
Share Copy Link

Contributed on Aug 10 2023

theenescresta

0 Answers Avg Quality 2/10

sql queries are stored in database settings.

Contents

More Related Answers

sql queries are stored in database settings.

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.