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