Zeri.Dapper.Extensions 1.0.0

简单的Dapper封装

开始使用

定一个一个实体类 Student.cs，内容如下

    [Table("TestDb.dbo.Student")]
    public class Student
    {
        [Key]
        public int StudentId { get; set; }
        public string StudentName { get; set; } = string.Empty;
        public string StudentNumber { get; set; } = string.Empty;
        public DateTime CreateTime { get; set; }
        public DateTime? UpdateTime { get; set; }
    }

其中Table属性用于指定dbName，如果不指定，默认会使用class Name，[Key]是用于指定主键字段，目前只支持单一主键，联合主键不支持，如果不指定，会默认找Id

使用方式 ： Insert

var m = new Student { StudentName = "张三", CreateTime = DateTime.Now, UpdateTime = DateTime.Now, StudentNumber = "001" };
using var conn = new SqlConnection(connStr);
conn.Insert(m);

Get

        public void GetAll()
        {
            using var conn = new SqlConnection(connStr);
            var stu = conn.GetAll<Student>(id);
        }

        public void GetById()
        {
            using var conn = new SqlConnection(connStr);
            var stu = conn.GetById<Student>(id);
        }

        public void GetByIds()
        {
            using var conn = new SqlConnection(connStr);
            var list = conn.GetByIds<Student>(new[] { id1, id2 });
            conn.GetByIds<Student>(list);
        }

        public void GetByPage()
        {
            using var conn = new SqlConnection(connStr);
            DynamicParameters parameters = new DynamicParameters();
            parameters.Add("@name", "%张%");
            this.InsertListTest(false);
            var list = conn.GetPageByOffset<Student>(0, 10, out int total, "where StudentName like @name", parameters, "*", "order by StudentId Desc");
        }

Delete

        public void Delete()
        {
            using var conn = new SqlConnection(connStr);
            var stus = conn.GetAll<Student>();
            var count = conn.Delete(stus);
        }

Update

        public void Update()
        {
            using var conn = new SqlConnection(connStr);
            var s = new Student {Id=1, StudentName = "class1", StudentNumber = "123", CreateTime = DateTime.Now };
            var result = conn.Update(s);
        }

        // 只update指定字段
        public void Update()
        {
            using var conn = new SqlConnection(connStr);
            var s = new Student {Id=1, StudentName = "class1", StudentNumber = "123", CreateTime = DateTime.Now };
            var result = conn.UpdateByColumn(s, t => new { t.StudentName, t.UpdateTime });
        }