当前位置:新注册送38元体验金 > 新注册送38元体验金编程 > Dapper一个轻量级的ORM库,dapperorm

Dapper一个轻量级的ORM库,dapperorm

文章作者:新注册送38元体验金编程 上传时间:2019-08-22

Dapper一个轻量级的ORM库,dapperorm

   相关阅读

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去下载,上面已经给出链接

  图片 1

基本操作

  简单的定义了一张mssql数据表

  图片 2

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

相关阅读 ...

本文由新注册送38元体验金发布于新注册送38元体验金编程,转载请注明出处:Dapper一个轻量级的ORM库,dapperorm

关键词: