首页 > 代码库 > C#_自定义简单ORM(二)代码下载
C#_自定义简单ORM(二)代码下载
测试实体:
[TableAttribute("TEST_STUDENT")] public class Student : MyBaseClass { /// <summary> /// /// </summary> [ColumnAttribute("GUID", DbType.AnsiString, IsPK = true)] public string Guid { get; set; } [ColumnAttribute("Name", DbType.AnsiString)] public string Name { get; set; } [ColumnAttribute("Age", DbType.Int32)] public Int32? Age { get; set; } [ColumnAttribute("Height", DbType.Decimal)] public Decimal? Height { get; set; } [ColumnAttribute("Birthday", DbType.DateTime)] public DateTime? Birthday { get; set; } }
测试代码:
private void SelectTest(ISqlHelper helper) { MyDbHelper fh = new MyDbHelper(helper); List<Student> lst = null; Student stu = new Student(); stu.SetHelper(helper); stu.Name = "chyun"; lst = fh.Select<Student>(stu); lst = stu.Select<Student>(); stu = new Student(); stu.SetHelper(helper); stu.Age = 26; lst = fh.Select<Student>(stu); lst = stu.Select<Student>(); stu = new Student(); stu.SetHelper(helper); stu.Age = 26; stu.Height = 1.78M; lst = fh.Select<Student>(stu); lst = stu.Select<Student>(); stu = new Student(); stu.SetHelper(helper); stu.Height = 1.78M; lst = fh.Select<Student>(stu); lst = stu.Select<Student>(); } private void InsertTest(ISqlHelper helper) { Student stu = new Student(); stu.SetHelper(helper); stu.Guid = "E47F2C60EF00488B9F48747FACC41EC5"; stu.Name = "chyun"; stu.Age = 26; stu.Height = 1.78M; stu.Birthday = DateTime.Parse("1988-06-07 10:30:00"); stu.Insert(); stu = new Student(); stu.SetHelper(helper); stu.Guid = Guid.NewGuid().ToString(); stu.Name = "chyun"; //stu.Age = 26; stu.Height = 1.78M; stu.Birthday = DateTime.Parse("1988-06-07 10:31:00"); stu.Insert(); stu = new Student(); stu.SetHelper(helper); stu.Guid = Guid.NewGuid().ToString(); stu.Name = "chyun"; stu.Age = 27; stu.Height = 1.781M; stu.Birthday = DateTime.Parse("1988-06-07 10:32:00"); stu.Insert(); } private void UpdateTest(ISqlHelper helper) { Student stu = new Student(); stu.SetHelper(helper); stu.Guid = "E47F2C60EF00488B9F48747FACC41EC5"; stu.Name = "chyun"; stu.Age = 16; stu.Height = 1.785M; stu.Birthday = DateTime.Parse("1988-06-07 10:30:30"); stu.UpdateByPk(); } private void DeleteTest(ISqlHelper helper) { Student stu = new Student(); stu.SetHelper(helper); stu.Guid = "E47F2C60EF00488B9F48747FACC41EC5"; stu.Name = "chyun"; stu.Age = 16; stu.Height = 1.785M; stu.Birthday = DateTime.Parse("1988-06-07 10:30:30"); stu.DeleteByPk(); }
欢迎指正 点击下载代码
QQ:519409748
C#_自定义简单ORM(二)代码下载
声明:以上内容来自用户投稿及互联网公开渠道收集整理发布,本网站不拥有所有权,未作人工编辑处理,也不承担相关法律责任,若内容有误或涉及侵权可进行投诉: 投诉/举报 工作人员会在5个工作日内联系你,一经查实,本站将立刻删除涉嫌侵权内容。