How to use prepared statements with Enterprise Library?

Question

Is there a way to tell Enterprise Library to use prepared statements? If so, how?

By prepared statements, do you mean parameterized sql statements? — Bryant, Oct 10 '08 at 21:43

score 2 · Accepted Answer · answered Oct 19 '08 at 21:11

The short answer is to use DbCommand.Prepare();

The long answer is that it is completely irrelevant, and results in a noop, when calling stored procedures.

Also, it should only really be used when the code is about to make several calls (as in a loop) with the same query.

score 0 · Answer 2 · answered Oct 13 '08 at 12:15

0

You should be able to obtain the sqlConnection / Command being executed -> can't you set the relevant setting here before executing ??

Hope I've got the right end of the stick...

answered Oct 13 '08 at 12:15

penderi

2 Answers2