FluentData.IntegrationTests/Command/MultipleResultsetTests.cs

微信扫码关注公众号，代码整理好后第一时间通知你。

using FluentData._Helpers;
using Microsoft.VisualStudio.TestTools.UnitTesting;

namespace FluentData.Command
{
	[TestClass]
	public class MultipleResultsetTests
	{
		[TestMethod]
		public void Command_with_multiple_resultset()
		{
			using (var cmd = TestHelper.Context().MultiResultSql())
			{
				var category1 = cmd.Sql(@"select * from Category where CategoryId = 1;
						select * from Category where CategoryId = 2;").QuerySingle();

				Assert.AreEqual("Books", category1.Name);

				var category2 = cmd.QuerySingle();
				Assert.AreEqual("Movies", category2.Name);
			}
		}
	}
}