SqlCommand and multiple SQL statements

9 Jul 2006 11:11 PM

Arne_Vajhøj

Is the capability of System.Data.SqlClient.SqlCommand to
execute more than one SQL statement (two SQL statements
in CommandText separated by semicolon and just one
Execute call) a supported feature that we can expect
to continue to work in the future ?

Arne

10 Jul 2006 3:00 AM

Sahil Malik [MVP C#]

In SqlClient - probably yes. (I say probably because I'm not an MSFT
employee, but I haven't heard anything contrarian).

- Sahil Malik
http://www.winsmarts.com
http://blah.winsmarts.com

"Arne Vajhøj" <a***@vajhoej.dk> wrote in message

news:y2gsg.57561$fG3.24218@dukeread09...
Show quote

> Is the capability of System.Data.SqlClient.SqlCommand to
> execute more than one SQL statement (two SQL statements
> in CommandText separated by semicolon and just one
> Execute call) a supported feature that we can expect
> to continue to work in the future ?
>
> Arne

10 Jul 2006 1:32 PM

Mary Chipman [MSFT]

SqlClient maps to SQL Server functionality, so as long as SQL Server
continues to support multiple commands, SqlClient will :-)

--Mary

On Sun, 09 Jul 2006 19:11:33 -0400, Arne Vajhøj <a***@vajhoej.dk>
wrote:

Show quote

>Is the capability of System.Data.SqlClient.SqlCommand to
>execute more than one SQL statement (two SQL statements
>in CommandText separated by semicolon and just one
>Execute call) a supported feature that we can expect
>to continue to work in the future ?
>
>Arne