Re: Oracle and Dotnet

You are not using bind variables and over parsing. Each time you build that string it is a unique statement that needs validating and compiling.

You should have something like

string SQL = "insert into test values (?)";

and bind the placeholder. Sorry I am not a C# programmer so I don't have the syntax, but there should be ODP.NET code examples on http://otn.oracle.com

-- 
MJB