Dapper QueryMultiple 多结果集遍历

曾经终败给现在 2022-09-21 05:37 173阅读 0赞

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

代码如下：

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();
            }
        }

高清截图如下：

![Center][]

[Center]: /images/20220721/2fe0531a97a14e788d6bb3a32499beed.png