Subtext.Scripting.SqlScriptRunner.SetNoCountOff C# (CSharp) Method

SqlScriptRunner Class Documentation Show file Open project: ayende/Subtext

SetNoCountOff() private static method

Temporarily set NOCOUNT OFF on the connection. We must do this b/c the SqlScriptRunner depends on all CRUD statements returning the number of effected rows to determine if an error occured. This isn't a perfect solution, but it's what we've got.

private static SetNoCountOff ( SqlTransaction transaction ) : void
transaction	System.Data.SqlClient.SqlTransaction
return	void

        private static void SetNoCountOff(SqlTransaction transaction)
        {
            Script noCount = new Script("SET NOCOUNT OFF");
            noCount.Execute(transaction);
        }

SqlScriptRunner

Execute

IsCrudScript

ReadStream

SetNoCountOff

SqlScriptRunner

UnpackEmbeddedScript