Are Oracle stored procedures faster than in line SQL for a Microsoft.NET application?

While I am tempted to answer "no" or "I don't think so", the only real way to know the answer to this question is to go and measure it yourself . Use a profiler like JetBrains dotTrace, and TOAD's own profiler, to find out.

It should be. When you send inline SQL to database, the engine must parse it and execute. Stored procedures are being parsed (and compiled) at creation time.

So at least you are gaining parsing time.

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.