Dapper QueryMultiple 多结果集 遍历

得出这段代码的探索过程相当纠结。

代码如下：

class Program    {        //创建连接对象        protected static SqlConnection GetConnection()        {            var connection = new SqlConnection("Data Source=.;Initial Catalog=TestDB;Integrated Security=True");            connection.Open();            return connection;        }        static void Main(string[] args)        {            //测试输出多个结果集            var sql = @"INSERT INTO [dbo].[Student] ([Name]) VALUES ('A1'); select @@IDENTITY as A;                        INSERT INTO [dbo].[Student] ([Name]) VALUES ('B1'); select @@IDENTITY as A;                        INSERT INTO [dbo].[Student] ([Name]) VALUES ('C1'); select @@IDENTITY as A";            //初始化数据库连接            using (SqlConnection connection = GetConnection())            {                                List<int> ilist = new List<int>();                //执行查询，获取结果集集合                var multi = connection.QueryMultiple(sql);                //遍历结果集                while(!multi.IsConsumed)                {                    //读取当前结果集                    var result = multi.Read().ToList()[0].A;                    if (result != null)                    {                        ilist.Add(Convert.ToInt32(result));                    }                }                //for(int i = 0;i<3;i++)                //{                //    var result = multi.Read().ToList()[0].A;                //    if (result != null)                //    {                //        ilist.Add(Convert.ToInt32(result));                //    }                //}                foreach (var item in ilist)                {                    Console.WriteLine(item.ToString());                }            }            Console.ReadLine();        }    }

高清截图如下：