ORA-01745: invalid host/bind variable name when parameters are reused in the linq query version 10.0.1.134.7 & EF7
Using 10.0.1.134.7 & EF7
When in .net the same variable is used more than once in a linq query, the bind variable in the query is rendered the second with 2 time ':' thus ::p__query_varname
eg. excerpt:
qry = qry.Where(z => z.DidoDocDosVersies.Where(y => (y.VersieVan <= query.VersieVan || y.VersieVan == null) && (y.VersieTot >= query.VersieVan || y.VersieTot == null)).Any());
renders as:
WHERE ("t".VERSIENUMMER_VAN <= :p__query_VersieVan_2 OR ("t".VERSIENUMMER_VAN IS NULL)) AND ("t".VERSIENUMMER_TOT >= ::p__query_VersieVan_2 OR ("t".VERSIENUMMER_TOT IS NULL)))