FromSqlRaw() and ParameterDirection.Output
Nobody has claimed this yet.
Assessment
- Difficulty
- 5/5
- Estimated time
- Over a week
- Newbie friendliness
- 35/100
Research direction
Start with the FromSqlRaw entry point and the mentioned src/EFCore.Relational/Storage/RelationalCommand.cs. Review how raw SQL commands are configured and how the SQL Server and MySQL differences affect output parameters. Done should be a defined mechanism for executing an appropriate stored-procedure command through raw SQL, with its behavior and provider limitations documented.
Written by the indexing model from the issue text.
Description
This is tangentially related to Get output parameter value of a stored procedure using EF Core FromSql(...) is always null.
With SQL Server you can use code shown in How to use a SQL output parameter with FromSqlInterpolated? to get output parameters from a stored procedure.
However as discussed in Parameter direction not supported in CommandType.Text this is not possible in MySQL when CommandType in ADO.NET is set to CommandType.Text.
However setting CommandType to CommandType.StoredProcedure is not an option when using FromSqlRaw() in EF Core as RelationalCommand class doesn't set CommandType and will default to CommandType.Text.
Could there be a mechanism when executing a stored procedure via raw SQL query to set CommandType to CommandType.StoredProcedure? Maybe a new method FromSqlProcRaw()?
- Dominant language
- C#
- Stars
- 14.8k
- Forks
- 3.4k
- Avg merge
- 2d 5h
- Merged PRs (30d)
- 134
Contributor guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
More from dotnet/efcore
-
Difficulty 4/5 3-5 days Newbie friendliness 55/100
-
customer-reported
Difficulty 5/5 Over a week Newbie friendliness 38/100
-
area-cosmos area-vector-search
Difficulty 5/5 Over a week Newbie friendliness 25/100
-
area-cosmos
Difficulty 5/5 Over a week Newbie friendliness 25/100
-
area-tools needs-design
Difficulty 4/5 3-5 days Newbie friendliness 25/100
Similar issues
-
Difficulty 2/5 1-3 hours Newbie friendliness 86/100
-
:watch: Not Triaged 11.0 fundamentals/subsvc
Difficulty 2/5 1-3 hours Newbie friendliness 92/100
dotnet/AspNetCore.Docs#37699 ·
-
Difficulty 2/5 1-3 hours Newbie friendliness 72/100
SubtitleEdit/subtitleedit#15108 · 1 comment ·
-
area/docs-content Bug pulumi/docs
Difficulty 1/5 1-3 hours Newbie friendliness 94/100
-
agentic-workflows untriaged
Difficulty 2/5 1-3 hours Newbie friendliness 76/100