Проблема с ответом API ⇐ C#

[Anonymous]

Я создаю GET API, но маршрут, который я определил в API, не запускается. Я пробую все, но он не работает. просмотрите приведенные ниже файлы кодов, которые я добавил в него.
Я настроил конечную точку GET API для извлечения данных из базы данных, но она не запускается, несмотря на мои усилия. Ниже приведены соответствующие файлы кода. Я столкнулся с проблемами конфигурации при попытке получить данные из базы данных.
Файл контроллера API
using Microsoft.Ajax.Utilities;
using System;
using System.Collections.Generic;
using System.Configuration;
using System.Data;
using System.Data.SqlClient;
using System.Linq;
using System.Net.Configuration;
using System.Web;
using System.Web.Mvc;

namespace API_develop.Controllers
{
public class APIController : Controller
{

string congemp = ConfigurationManager.ConnectionStrings["Empconectionstring"].ConnectionString;
// GET: API
[HttpGet]
[Route("API/emodata")]
public IList EMPdatalist()
{
IList getdata = new List();
{
using (SqlConnection conn = new SqlConnection(congemp))
{
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandText = "SELECT id, firstname, lastname, email FROM Employees";

SqlDataAdapter da = new SqlDataAdapter(cmd); // Associate SqlCommand with SqlDataAdapter
DataTable dt = new DataTable();
conn.Open();
da.Fill(dt);

try
{
if (dt != null)
{
foreach (DataRow row in dt.Rows)
{
EMPdatalist emp = new EMPdatalist();
emp.Id = Convert.ToInt32(row["id"].ToString());
emp.FirstName = row["firstname"].ToString();
emp.LastName = row["lastname"].ToString();
emp.Email = row["email"].ToString();
getdata.Add(emp);
}
}
}
catch (Exception ex)
{
// Handle the exception (e.g., log it)
Console.WriteLine(ex.Message);
}
finally
{
conn.Close();
}
}
}
return getdata;
}
}
}
} ```

**API Model Class**

`
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;

namespace API_develop.Models
{
public class EMPdatalist
{
public int Id { get; set; }
public string FirstName { get; set; }
public string LastName { get; set; }
public string Email { get; set; }
public string Gender { get; set; }
}
}
`

**Route Confiq.cs**

` using System.Web.Mvc;
using System.Web.Routing;

namespace API_develop
{
public class RouteConfig
{
public static void RegisterRoutes(RouteCollection routes)
{
routes.IgnoreRoute("{resource}.axd/{*pathInfo}");

routes.MapRoute(
name: "Default",
url: "{controller}/{action}/{id}",
defaults: new { action = "Index", id = UrlParameter.Optional }
);
}
}
}
`

**WebAPIConfig.cs File**

`
using System;
using System.Web.Http;

namespace API_develop
{
public static class WebApiConfig
{
public static void Register(HttpConfiguration config)
{
// Web API routes
config.MapHttpAttributeRoutes();

config.Routes.MapHttpRoute(
name: "DefaultApi",
routeTemplate: "api/{controller}/{action}/{id}",
defaults: new { id = RouteParameter.Optional }
);

GlobalConfiguration.Configuration.Formatters.JsonFormatter.MediaTypeMappings
.Add(new System.Net.Http.Formatting.RequestHeaderMapping("Accept",
"text/html",
StringComparison.InvariantCultureIgnoreCase,
true,
"application/json"));
}
}
}`

**The error i am getting**
[api/API/emodata](https://i.sstatic.net/EfycUeZP.png)

[API/emodata](https://i.sstatic.net/6HixcryB.png)

**Database Script to get the data.**

` USE [TokenAuthDB]
GO
/****** Object: Table [dbo].[Employees] Script Date: 7/5/2024 11:36:19 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Employees](
[Id] [int] IDENTITY(1,1) NOT NULL,
[FirstName] [nvarchar](max) NULL,
[LastName] [nvarchar](max) NULL,
[Email] [nvarchar](max) NULL,
[Gender] [nvarchar](max) NULL,
[CreatedDate] [datetime] NOT NULL,
CONSTRAINT [PK_dbo.Employees] PRIMARY KEY CLUSTERED
(
[Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
SET IDENTITY_INSERT [dbo].[Employees] ON

INSERT [dbo].[Employees] ([Id], [FirstName], [LastName], [Email], [Gender], [CreatedDate]) VALUES (1, N'Benjamin', N'Jones', N'timothydavis@jennings.com', N'Male', CAST(N'2023-06-28T00:00:00.000' AS DateTime))
INSERT [dbo].[Employees] ([Id], [FirstName], [LastName], [Email], [Gender], [CreatedDate]) VALUES (2, N'David', N'Welch', N'lnelson@maldonado.net', N'Female', CAST(N'2020-04-07T00:00:00.000' AS DateTime))
INSERT [dbo].[Employees] ([Id], [FirstName], [LastName], [Email], [Gender], [CreatedDate]) VALUES (3, N'Jason', N'Young', N'powellrebecca@hotmail.com', N'Male', CAST(N'2019-06-19T00:00:00.000' AS DateTime))
INSERT [dbo].[Employees] ([Id], [FirstName], [LastName], [Email], [Gender], [CreatedDate]) VALUES (4, N'Brandon', N'Oneill', N'caseykennedy@yahoo.com', N'Male', CAST(N'2021-07-21T00:00:00.000' AS DateTime))

GO
INSERT [dbo].[Employees] ([Id], [FirstName], [LastName], [Email], [Gender], [CreatedDate]) VALUES (100, N'Mark', N'Figueroa', N'timothy02@gmail.com', N'Male', CAST(N'2022-11-12T00:00:00.000' AS DateTime))
SET IDENTITY_INSERT [dbo].[Employees] OFF
GO
**
`

I change the route setting but it cannot work. please help me to solve this problem so i can understand why i am facing this issue.`


Подробнее здесь: https://stackoverflow.com/questions/787 ... onse-issue