Parameter discovery problem with .net 4.5&EL6&ODP.NET

user13302347

I get below problem after migration from Enterprise library 5 to 6 with ODP.NET

It throws me error as "Parameter discovery is not supported for connections using GenericDatabase. You must specify the parameters explicitly, or configure the connection to use a type deriving from Database that supports parameter discovery."

My code looks like below

     using (DbCommand command = database.GetStoredProcCommand(query,paramArray))
            {
                isSuccessful = database.ExecuteNonQuery(command);
               
            }

Could you help me with this?

user13302347

Thank you all. we are able to resolve this issue with parameter discovery. Instead of ODP.net from Oracle, I needed to use odp.net from EntLibContrib from nuget. Hope it might help someone else who would like to pass array of parameters instead of binding each parameter separately which would be cumbersome if we need to call 100s of procedures.

user13302347

Thank you all. we are able to resolve this issue with parameter discovery. Instead of ODP.net from Oracle, I needed to use odp.net from EntLibContrib from nuget. Hope it might help someone else who would like to pass array of parameters instead of binding each parameter separately which would be cumbersome if we need to call 100s of procedures.