[SQL Server] Update datetime2 column does not work
Nobody has claimed this yet.
Assessment
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Newbie friendliness
- 45/100
Research direction
No source file or test is named. Start by reproducing the SQL Server 2016 case with the shown SqlTypeProvider query and SubmitUpdates call, then trace how the datetime2(7) assignment is detected and persisted. Done means the existing row is updated, or a clear update error is raised instead of silently completing.
Written by the indexing model from the issue text.
Description
Description
I cannot update a row containing a datetime2(7) column in SQL Server.
Updates on other datatypes, for example plain int works well.
Inserts with DateTime into this same table works well.
Repro steps
- Sql server 2016
- SqlTypeProvider 1.1.50
type MyDb = SqlDataProvider<ConnectionStringName = "ConnStringInAppConfig", DatabaseVendor = Common.DatabaseProviderTypes.MSSQLSERVER, UseOptionTypes = true>
let ctx = MyDb.GetDataContext()
let entityToUpdate = query { from e in ctx.Dbo.MyTable do where (e.Id = myId) select e }
e.ValidFromDate <- new DateTime(2018, 08, 08)
ctx.SubmitUpdates()
Expected behavior
The column is updated, or else an error is raised that it could not be updated.
Actual behavior
Silently finishes, nothing is updated. No "pendingchanges" remain.
Known workarounds
Delete row and recreate it.
Related information
- SQL Server 2016
- Client on Win10, server on Windows Server 2012
- Latest released version on nuget
- NET Framework 4.6.1
- Dominant language
- F#
- Stars
- 627
- Forks
- 147
- Avg merge
- 2h 2m
- Merged PRs (30d)
- 1
Contributor guide
No contributing guide indexed for this repository
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 fsprojects/SQLProvider
-
enhancement
Difficulty 3/5 1-2 days Newbie friendliness 55/100
fsprojects/SQLProvider#872 · 2 comments ·
-
Repo Assist? Openenhancement
Difficulty 5/5 Over a week Newbie friendliness 10/100
fsprojects/SQLProvider#870 · 1 comment ·
-
postgresql
Difficulty 4/5 3-5 days Newbie friendliness 58/100
fsprojects/SQLProvider#869 · 2 comments ·
-
documentation
Difficulty 2/5 1-3 hours Newbie friendliness 42/100
fsprojects/SQLProvider#868 · 2 comments ·
-
sql server
Difficulty 4/5 3-5 days Newbie friendliness 45/100
fsprojects/SQLProvider#851 · 1 comment ·
All issues in fsprojects/SQLProvider
Similar issues
-
bug: AI Gateway client filter lists "Unknown" twice when NULL and literal Unknown clients coexist Openbug
Difficulty 2/5 1-3 hours Newbie friendliness 90/100
-
[BUG] A column whose default is the empty string is drawn in the ER diagram as having no default Openbug database-provider good first issue hacktoberfest
Difficulty 2/5 1-3 hours Newbie friendliness 90/100
libredb/libredb-studio#1030 · 6 comments ·
-
comp-datalake
Difficulty 2/5 1-3 hours Newbie friendliness 88/100
ClickHouse/ClickHouse#121222 ·
-
bug
Difficulty 2/5 1-3 hours Newbie friendliness 75/100
-
bug redshift
Difficulty 2/5 1-3 hours Newbie friendliness 88/100