public DataTable getQueryToDataTableNew(string query, DbContext context)

        {

            DataTable dt= new DataTable();

            try

            {

                using (var cmd = context.Database.Connection.CreateCommand())

                {

                    cmd.CommandType = System.Data.CommandType.Text;

                    cmd.CommandText = query;

 cmd.CommandTimeout = 0;//sınırsız demek

                    SqlDataAdapter da = new SqlDataAdapter((SqlCommand)cmd);

                    da.Fill(dt);

                }

            }

            catch (Exception ex)

            {

                throw ex;

            }

            return dt;

        }

[ApiExplorerSettings(IgnoreApi = true)]

        [NonAction]

        public DataTable getQueryToDataTable(string query, DbContext context)

        {

            DataTable dt = new DataTable();

            try

            {

                using (var cmd = context.Database.GetDbConnection().CreateCommand())

                {

                    cmd.CommandType = System.Data.CommandType.Text;

                    cmd.CommandText = query;

                    SqlDataAdapter da = new SqlDataAdapter((SqlCommand)cmd);

                    da.Fill(dt);

                }

            }

            catch (Exception ex)

            {

            }

            return dt;

        }

        public IActionResult EmployeeList()

        {

            using var c = new Context();//

            var data = getQueryToDataTable("exec  listele", c);

            string json = JsonConvert.SerializeObject(data);

            return Ok(json);

        }

[HttpPost]

        [Route("texboxtipi")]

        public ActionResult<string> texboxtipi(DonemAra model)

        {

            List<DonemAraModelDonus> donemaramdeldonus = new List<DonemAraModelDonus>();//sınıfı listeye çeviriyoruz

            //appsetting.json dan gelen connection string baslangıç

            var configuration = new ConfigurationBuilder().AddJsonFile("appsettings.json", optional: true, reloadOnChange: true).Build();

            var connectionString = configuration.GetConnectionString("DbErzin");//connection string adı

            //appsetting.json dan gelen connection string bitiş

            string json = "";

            using (SqlConnection connection = new SqlConnection(connectionString))

            {

                connection.Open();//bağlantıyı açıyoruz

                string query = " exec aaa_Drup @Baslangic=@Baslangic ,@Bitis=@Bitis";

                SqlCommand command = new SqlCommand(query, connection);

                command.Parameters.AddWithValue("@Baslangic", model.Baslangic);

                command.Parameters.AddWithValue("@Bitis", model.Bitis);

                SqlDataAdapter da = new SqlDataAdapter(command);

                DataTable dataTable = new DataTable();

                da.Fill(dataTable);

                connection.Close();

                json = JsonConvert.SerializeObject(dataTable);

            }

            return Ok(json);

        }