Dapper一個輕量級的ORM庫 - liunlls－IT工程師數位筆記本

文章出處

引用

　　可以直接通過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 Id=@Id; ", 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 =@Id; ", new { Id = 1 });
                Console.WriteLine("影響行數{0}", result);
            }
        }