When querying table TemporalTableBetween sql throws error non convertible datetime
When use TemporalTableBetween extension. Datetimes can't converted to datetime2 in sql
Exception:
Microsoft.Data.SqlClient.SqlException (0x80131904): Conversion failed when converting date and/or time from character string.
Hello @Ilkhom-S ,
Thank you for contacting us, we will look at it.
Best Regards,
Jon
Sponsorship Help us improve this library
Performance Libraries
context.BulkInsert(list, options => options.BatchSize = 1000);
Entity Framework Extensions • Dapper Plus
Runtime Evaluation
Eval.Execute("x + y", new {x = 1, y = 2}); // return 3
C# Eval Function
@JonathanMagnan , I found that only when current context culture is other than en-us exception thrown. I tested with ru-RU , it's giving error on en-US its ok.
Hello @Ilkhom-S ,
Do you think you could create a runnable project with the issue? It doesn’t need to be your project, just a new solution with the minimum code to reproduce the issue.
My developer told me that it worked when he did the culture test, so perharp we are missing something to reproduce it.
Best Regards,
Jon
Hello, I create sample project to demonstrate problem. You need to apply migration and run console app to see problem
https://github.com/Ilkhom-S/ZZZThreadBug
I commented block where querying with ZZZ extension with default culture, because duplicate hook error was throwing.
Hello @Ilkhom-S ,
It's possible that the GitHub repos is private? We currently receive a Page not found when trying to go in your repository: https://github.com/Ilkhom-S/ZZZThreadBug
If you need to keep the code private, you can send it here: [email protected]
Best Regards,
Jon
Apologize. I make it public
Hello @Ilkhom-S ,
Just to let you know that the issue has been fixed and should be released next week.
Best Regards,
Jon
Thanks,
Hello @Ilkhom-S ,
A new version has been released yesterday that should fix this issue.
If you have the chance to test it, let us know if everything has been fixed correctly.
Best Regards,
Jon
Are you finding this library useful? If so, please consider supporting its continued development by becoming a sponsor.
Additionally, if you think your enterprise would benefit from this library, we encourage you to suggest they become a sponsor as well. Your support will help ensure this library remains alive and well-supported.