FromSqlRaw() - inconsistent/incorrect documentation

[wschlegel]

When I follow this documentation: https://docs.microsoft.com/en-us/dotnet/api/microsoft.entityframeworkcore.relationalqueryableextensions.fromsqlraw?view=efcore-5.0 I get an error message:

FormatException: Input string was not in a correct format.

Example:

Context.Entity.FromSqlRaw("SELECT * FROM dbo.SomeFunction({@MyParameter})", new SqlParameter("@MyParameter", "some value"))

However, when I follow this documentation: https://docs.microsoft.com/en-us/ef/core/querying/raw-sql, the SQL created is sound and the query is executed correctly:

Example:

Context.Entity.FromSqlRaw("SELECT * FROM dbo.SomeFunction(@MyParameter)", new SqlParameter("@MyParameter", "some value"))

Here the parameters are specified without curly braces - which I think is logical, since there is no string interpolation going on here.

It seems to me that parts of the documentation are wrong.

Hence, I suggest adjusting the documentation and removing the curly braces when passing in named parameters.

---

Document Details

⚠ Do not edit this section. It is required for docs.microsoft.com ➟ GitHub issue linking.

• ID: 8c59797d-462b-c382-e0e4-714794c5e1c4
• Version Independent ID: 13cac8b0-625e-1b34-73a1-b52c74ababf6
• Content: RelationalQueryableExtensions.FromSqlRaw<TEntity>(DbSet<TEntity>, String, Object[]) Method (Microsoft.EntityFrameworkCore)
• Content Source: dotnet/xml/Microsoft.EntityFrameworkCore/RelationalQueryableExtensions.xml
• Product: ef-core-api
• GitHub Login: @dotnet-bot
• Microsoft Alias: avickers