[C#/SQLITE/.NET5] DynamicParameters 클래스 사용하기

TestProject.zip

0.00MB

▶ Program.cs

using System;
using System.Collections.Generic;
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 Student WHERE NAME LIKE @NAME || '%'";

            using(SQLiteConnection connection = new SQLiteConnection(connectionString))
            {
                DynamicParameters parameters = new DynamicParameters();

                parameters.Add("NAME", "김");

                IEnumerable<dynamic> resultEnumerable = connection.Query(sql, parameters);

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

        #endregion
    }
}