ODP.NET and parameters

Question

Hello guys!

I have built a common app that works with PostgreSQL and should work on Oracle.

However i'm getting strange errors when inserting records through a parametrized query.

My formatted query looks like this:

"INSERT INTO layer_mapping VALUES (@lm_id,@lm_layer_name,@lm_layer_file);"

Unlike Npgsql which documents how to use the parameters, i could not found how Oracle "prefers" them to be used. I could only find :1, :2, :3, for example.

I do not wanto use sequential parameters, i want to use them in a named way.

Is there a way to do it? Am i doing something wrong?

Thanks

Answer 1

You can use named parameters with ODP.NET like so:

using (var cx=new OracleConnection(connString)){
   using(var cmd=cx.CreateCommand()){
      cmd.CommandText="Select * from foo_table where bar=:bar";
      cmd.BindByName=true;
      cmd.Parameters.Add("bar",barValue);
      ///...
   }
}