Dapper一個輕量級的ORM庫

標籤：

 　　相關閱讀

http://stackexchange.github.io/dapper-dot-net/

https://github.com/StackExchange/dapper-dot-net

https://msdn.microsoft.com/zh-cn/magazine/mt703432.aspx

引用

　　可以直接通過Nuget下載，需要源碼的話可以通過git去下載，上面已經給出連結

　　

基本操作

　　簡單的定義了一張mssql資料表

　　

        private static List<Student> Read()        {            using (var connect = new SqlConnection(connectionString))            {                connect.Open();                var query = connect.Query<Student>("SELECT TOP 1000 [Id],[Name],[Grade] FROM [TESTDB].[dbo].[Student];");                return query.ToList();            }        }        private static void Add()        {            using (var connect = new SqlConnection(connectionString))            {                connect.Open();                var result = connect.Execute("INSERT INTO [dbo].[Student]([Id],[Name],[Grade])VALUES(@Id,@Name,@Grade);", new[] {                    new { Id=2,Name="李四",Grade=1},                    new { Id=3,Name="王五",Grade=1},                    new { Id=4,Name="趙六",Grade=1}                });                Console.WriteLine("影響行數{0}", result);            }        }        private static void Update()        {            using (var connect = new SqlConnection(connectionString))            {                connect.Open();                var result = connect.Execute("UPDATE [dbo].[Student]  SET [Grade] = @Grade WHERE [email protected]; ", new { Id = 2, Grade = 2 });                Console.WriteLine("影響行數{0}", result);            }        }        private static void Delete()        {            using (var connect = new SqlConnection(connectionString))            {                connect.Open();                var result = connect.Execute("DELETE FROM [dbo].[Student] WHERE Id [email protected]; ", new { Id = 1 });                Console.WriteLine("影響行數{0}", result);            }        }

Dapper一個輕量級的ORM庫