Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Support DateOnly and TimeOnly within table-valued parameters #17

Open
alansingfield opened this issue Jul 23, 2024 · 1 comment
Open

Support DateOnly and TimeOnly within table-valued parameters #17

alansingfield opened this issue Jul 23, 2024 · 1 comment
Assignees
@alansingfield

Comments

@alansingfield
Copy link
Owner

Microsoft.Data.SqlClient doesn't accept DateOnly / TimeOnly within TVPs - this is possibly a bug (see dotnet/SqlClient#2687 ) so we should work around this by converting from DateOnly to DateTime and TimeOnly to TimeSpan.
@alansingfield alansingfield self-assigned this Jul 23, 2024
@alansingfield
Copy link
Owner Author

Very recently resolved - dotnet/SqlClient#2258
I should be able to revert my workaround once updated to Microsoft.Data.SqlClient 6.0.1

alansingfield added a commit that referenced this issue Feb 23, 2025
@alansingfield
#17 No more need for special case workaround for DateOnly / TimeOnly …
3ba4e9d 
…in table-valued parameters as this has been resolved in Microsoft.Data.SqlClient 6.0.1
alansingfield added a commit that referenced this issue Feb 23, 2025
@alansingfield
Merge pull request #21 from alansingfield/features/17-dateonly-timeon…
9a79d85 
…ly-resolution

#17 No more need for special case workaround for DateOnly / TimeOnly …
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@alansingfield alansingfield

Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@alansingfield