Posted by raymond_b_jimenez on 09/14/07 14:29

On 29 Ago, 22:38, Erland Sommarskog <esq...@sommarskog.se> wrote:

>
> SqlClient does not send this by default, if you use CommandBehaviour.KeyInfo
> it does.
>
For all the docs I've seen till now, KeyInfo really seems like the
most interesting option. A couple of remarks:
1-I use an ExecuteReader with no parameters, so no CommandBehavior is
being used.
2-I do not see any "SET FMTONLY OFF" being executed, despite some
people complaining about that on the net. If one sees
http://msdn2.microsoft.com/en-us/library/system.data.commandbehavior.aspx
it would also be appearing in my case.

I'm now looking into the SqlCommand and SQLConnection classes to see
if something can make the "SET NO_BROWSETABLE ON" disappear. Anyone
got a clue?

rj

[Back to original message]