[C#/COMMON/SQLITE/.NET5] SqlMapper 클래스 : QueryMultiple 확장 메소드를 사용해 복수 SELECT문 실행하기

■ SqlMapper 클래스의 QueryMultiple 확장 메소드를 사용해 복수 SELECT문을 실행하는 방법을 보여준다.

▶ Program.cs


using System;
using System.Data.SQLite;

using Dapper;

namespace TestProject
{
    /// <summary>
    /// 프로그램
    /// </summary>
    class Program
    {
        //////////////////////////////////////////////////////////////////////////////////////////////////// Method
        ////////////////////////////////////////////////////////////////////////////////////////// Static
        //////////////////////////////////////////////////////////////////////////////// Private

        #region 프로그램 시작하기 - Main()

        /// <summary>
        /// 프로그램 시작하기
        /// </summary>
        private static void Main()
        {
            string connectionString = $"Data Source={"test.db"};";

            string sql = @"
SELECT * FROM School;
SELECT * FROM Student;
";

            using(SQLiteConnection connection = new SQLiteConnection(connectionString))
            {
                using(var reader = connection.QueryMultiple(sql))
                {
                    var resultEnumerable1 = reader.Read<dynamic>();
                    var resultEnumerable2 = reader.Read<dynamic>();

                    foreach(dynamic result in resultEnumerable1)
                    {
                        Console.WriteLine($"{result.ID}, {result.NAME}");
                    }

                    Console.WriteLine();

                    foreach(dynamic result in resultEnumerable2)
                    {
                        Console.WriteLine($"{result.ID}, {result.NAME}, {result.HEIGHT}");
                    }
                }
            }
        }

        #endregion
    }
}

using System;

using System.Data.SQLite;

using Dapper;

namespace TestProject

{

/// <summary>

/// 프로그램

/// </summary>

class Program

{

//////////////////////////////////////////////////////////////////////////////////////////////////// Method

////////////////////////////////////////////////////////////////////////////////////////// Static

//////////////////////////////////////////////////////////////////////////////// Private

#region 프로그램 시작하기 - Main()

/// <summary>

/// 프로그램 시작하기

/// </summary>

private static void Main()

{

string connectionString = $"Data Source={"test.db"};";

string sql = @"

SELECT * FROM School;

SELECT * FROM Student;

using(SQLiteConnection connection = new SQLiteConnection(connectionString))

{

using(var reader = connection.QueryMultiple(sql))

{

var resultEnumerable1 = reader.Read<dynamic>();

var resultEnumerable2 = reader.Read<dynamic>();

foreach(dynamic result in resultEnumerable1)

{

Console.WriteLine($"{result.ID}, {result.NAME}");

}

Console.WriteLine();

foreach(dynamic result in resultEnumerable2)

{

Console.WriteLine($"{result.ID}, {result.NAME}, {result.HEIGHT}");

}

#endregion

}

TestProject.zip