string script =
@"if object_id('dept', 'U') is not null
drop table dept;
CREATE TABLE Dept(
DEPTNO int PRIMARY KEY NOT NULL,
DNAME varchar(14) NULL,
LOC varchar(13) NULL
);"+
"INSERT INTO DEPT VALUES (10,'ACCOUNTING','NEW YORK');"+
"INSERT INTO DEPT VALUES (20,'RESEARCH','DALLAS');"+
"INSERT INTO DEPT VALUES (30,'SALES','CHICAGO');"+
"INSERT INTO DEPT VALUES (40,'OPERATIONS','BOSTON');"+
"SELECT * FROM DEPT";
SqlConnection myConn = new SqlConnection(
"User Id=sa;Server=localhost;Initial Catalog=Test;");
SqlScript myScript = new SqlScript(script,myConn);
IDataReader myReader;
myConn.Open();
while (myScript.ExecuteNext(out myReader))
{
Console.WriteLine("Records affected " + myReader.RecordsAffected);
while (myReader.Read())
{
Console.WriteLine(myReader.GetString(0));
}
myReader.Close();
}
myConn.Close();