Dapper – 似 SqlDataReader / iBatis – Performance 比 Entity Framework 較快

Dapper – 似 SqlDataReader / iBatis – Performance 比 Entity Framework 較快

 
   using System;
   using System.Collections.Generic;
   using System.Data.SqlClient;
   using Dapper;
 
   namespace DapperTest
   {
      class Program
      {
         static void Main(string[] args)
         {
            string cnStr = "… …";
 
            using (var cn = new SqlConnection(cnStr))
            {
               var list = cn.Query("SELECT [CTRY_ID], [CTRY_CODE], [CTRY_NAME] FROM [cerm].[CTRY]");
 
               foreach (var item in list)
               {
                  Console.WriteLine("{0}. {1} ( {2} )", item.CTRY_ID, item.CTRY_NAME, item.CTRY_CODE);
               }
 
               Console.ReadLine();
            }
         }
      }
 
      public class CTRY
      {
         public long CTRY_ID { get; set; }
         public string CTRY_CODE { get; set; }
         public string CTRY_NAME { get; set; }
      }
   }
 

Reference From Here.