❔ EF8 SqlQuery with PostgreSQL, put variable as string in FormattableString
Hi,
I'm trying use SqlQuery with custom types.
Error:
This line getting error cause the method converting this query to
But I need that:
How can I do that?
I'm trying use SqlQuery with custom types.
_context.Database.SqlQuery<T>(@$"SELECT * FROM ""public"".{_tableName} WHERE ""Id""={Guid.Parse(id)}").SingleOrDefaultAsync();Error:
Npgsql.PostgresException (0x80004005): 42601: syntax error at or near "$1"This line getting error cause the method converting this query to
SELECT * FROM "public".@p0 WHERE "Id"=@p1But I need that:
SELECT * FROM "public"."Posts" WHERE "Id"=@p0How can I do that?
