Parameter prefix being swapped between ":" and "@" carrying over to other
concurrently generated queries.
---------------------------------------------------------------------------------------------------------
Key: DNET-974
URL: http://tracker.firebirdsql.org/browse/DNET-974
Project: .NET Data provider
Issue Type: Bug
Components: ADO.NET Provider
Affects Versions: 7.5.0.0
Environment: Windows Core 3.1/5.0/Framework 4.8
Reporter: Benjamyn Williams
Assignee: Jiri Cincura
Priority: Critical
Error is described in this "Resolved" issue
http://tracker.firebirdsql.org/browse/DNET-945
Critical as this is affecting medical information.
This is an error with concurrent query generation due to the changing of
sqlGenerationHelper.ParameterNameMarker in the singleton DbUpdateSqlGenerator
within methods AppendUpdateOperation and AppendDeleteOperation when queries are
being constructed concurrently.
This has caused mismatches between parameters and the query text where the
query would be referring to "@p0" while the parameters object has ":p0".
This needs to be solved so that changing the ParameterNameMarker for named
parameters will not affect other concurrent query generation.
Confirmed this by redirecting those particular parts (extracting the internal
methods that EF uses) to a new version of sqlGenerationHelper (As it required
no dependencies) with ":" instead of using the current one.
The test project on the previous issue was able to replicate this.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
