无法运行我的查询，我在数据库中的“ users”上有一个“ Id”，这是postgres的“ uuid”类型，在点网核心上有一个GUID ID，我想让您的用户拥有相同的ID，然后返回该用户。
public async Task<T> GetById(Guid entity)
{
try
{
connection.Open();
var result = await this.connection.QueryFirstAsync(askForId, entity);
return result;
}
catch (Exception e)
{
throw e;
}
finally
{
connection.Close();
}
}
实体的值为：
entity: {675d83ca-c7b6-4efe-bf98-46a48e8a28fd}
我的查询是这样的：
private readonly string askForId = "SELECT * FROM Users WHERE Id = @Id";
如何解决这个问题：
"ClassName": "Npgsql.PostgresException",
"Message": "External component has thrown an exception.",
"Data": {
"Severity": "ERROR",
"InvariantSeverity": "ERROR",
"SqlState": "42883",
"MessageText": "operator does not exist: @ uuid",
"Hint": "No operator matches the given name and argument type. You might need to add an explicit type cast.",
"Position": 32,
"File": "parse_oper.c",
"Line": "731",
"Routine": "op_error"
},
}
我将查询仅从@Id更改为@id：
private readonly string askForId = "SELECT * FROM Users WHERE Id = @id";
和改变QueryFirstAsync，以QueryFirstOrDefaultAsync监守我需要知道，如果不发现什么。
public async Task<T> GetById(Guid entity)
{
try
{
connection.Open();
var result = await this.connection.QueryFirstOrDefaultAsync<T>(askForId, new { id = entity});
return result;
}
catch (Exception e)
{
throw e;
}
finally
{
connection.Close();
}
}
并将其更改entity为新的{ id = entity}并能很好地查询
本文收集自互联网，转载请注明来源。
如有侵权，请联系[email protected] 删除。
我来说两句