Azure / Azure/data-api-builder

[Bug]: `numeric` data type not supported as a parameter for a stored procedure

Open
#2,059 1 comment 0 reactions 0 assignees View on GitHub
bug mssql triage
Dominant language
C#
Stars
1.5k
Forks
370
Avg merge
3d 17h
Merged PRs (30d)
8

Description

### What happened?

System.Data.Common.SqlDbType
https://learn.microsoft.com/en-us/dotnet/api/system.data.sqldbtype?view=net-8.0
doesn't have a
Numeric
type, thats why we unfortunately see this error. The autodetection is done by querying
sys.dm_exec_describe_first_result_set
which gives back
numeric
from SQL. We will need to handle this discrepancy between these dependencies in DAB explicitly for this and other possible types which may be absent in
System.Data.Common.SqlDataType

image

### Version

main

### What database are you using?

Azure SQL

### What hosting model are you using?

Local (including CLI)

### Which API approach are you accessing DAB through?

REST

### Relevant log output

_No response_

### Code of Conduct

- [X] I agree to follow this project's Code of Conduct

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.