I'm just wondering whether it's possible at all to execute multiple statements & multiple heterogeneous statements using the semicolon (";") separator. SSCE balks at it right now if I issue via ADO.NET command text similar to
the following (line separator is your typical \r\n):
insert into Foo (id, name) values (1, 'foo1');
insert into Bar (id, name) values (1, 'bar1');
update Goo g set g.name = 'Goo1', g.fooId = 1, g.barId = 1 where id = 1;
SQL Server Management Studio executes it just fine, which led me to believe that I could do it via ADO.NET.
Can someone who knows please clarify? What do I have to do in order to batch commands to ADO.NET?
View Complete Post