ODP.NET and parameters?

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

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); ///... } }.

Thank you Josh! What about for a insert? I do not need to qualify the columns names, do i?

The real pain here is that BindByName. Npgsql does not need or require that variable to be set! – George Mar 2 '10 at 20:04 For inserts you can use "INSERT INTO table_name values(:foo,:bar)" or "INSERT INTO table_name(foo,bar) values(:foo,:bar)" I prefer the last way in case the table structure changes in the future.

– Josh Bush Mar 2 '10 at 20:06 Thanks :D Darn that BindByName! :P – George Mar 2 '10 at 20:07.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.