public void TestMultiResultSetsInStatement() { string sql = "select 1 select 2"; var site = Current.DB.Sites.First(); var user = User.CreateUser("Fred", "*****@*****.**", "xyzdsa"); var results = QueryRunner.ExecuteNonCached(new ParsedQuery(sql, null), site, user, null); Assert.AreEqual(2, results.ResultSets.Count()); }
public void TestBatchingBatch() { string sql = "print 1 \nGO\nprint 2"; var site = Current.DB.Sites.First(); var user = User.CreateUser("Fred", "*****@*****.**", "xyzdsa"); var results = QueryRunner.ExecuteNonCached(new ParsedQuery(sql, null), site, user, null); Assert.AreEqual(0, results.ResultSets.Count()); Assert.AreEqual("1\r\n2\r\n", results.Messages); }