我在邮递员 https://localhost:44300/api/ViewEvents 中使用以下查询?id=鲍勃。它返回 4 个包含 ID Bob 的不同行,而是返回 4 个完全相同的行。任何帮助将不胜感激。
接口控制器
// GET: api/ViewEvents
[HttpGet]
public async Task<ActionResult<IEnumerable<ViewEvents>>> GetViewEvents(string id)
{
if(id == null)
{
return await _context.ViewEvents.ToListAsync();
}
else
{
var viewEvents = _context.ViewEvents.Where(i => i.Id==(id)).ToList();
if (viewEvents.Count < 1)
{
return NotFound();
}
return viewEvents;
}
}
数据库视图返回正确的结果。
CREATE
ALGORITHM = UNDEFINED
DEFINER = `tim_azure`@`%`
SQL SECURITY DEFINER
VIEW `view_events` AS
SELECT
`e`.`CreatedUserID` AS `id`,
`e`.`ID` AS `eventid`,
`e`.`Event` AS `event`
FROM
`tblevent` `e`
下图包含数据库结构。 数据库结果
我将查询更改为以下内容,由于某种原因它有效。
var viewEvents = _context.Tblevent.Where(i => i.CreatedUserId == (id));
if (id == null)
{
return await _context.Tblevent.ToListAsync();
}
else
{
if (viewEvents.ToList().Count < 1)
{
return NotFound();
}
return viewEvents.ToList();
}
}