Microsoft OracleClient Provider and Positional Parameters Binding

Question

Does anyone know how to get the Microsoft OracleClient Provider to support binding parameters by position, currently it does that only by Name and there does not seem to be any option to specify to use positional parameters. I know that Oracle's ODP.NET supports positional parameters, but i want this in Microsoft's provider.

Answer 1

I believe OracleClient via Microsoft does not unfortunately which has bit me on several occasions. As you likely are aware, OracleClient has been deprecated as of .net 4.0 so if this is a necessity you will likely need to use a third party ADO.net data provider for to accomplish this.