csharp: mappings using Dapper-Extensions+Dapper.net.
时间:2022-03-12 15:22
sql:
CREATE TABLE [PotoUsers] ( [UserID] INT IDENTITY(1,1) PRIMARY KEY, [UserName] NVARCHAR(50), [FirstName] NVARCHAR(50), [LastName] NVARCHAR(50), [MiddleName] NVARCHAR(50), [EmailID] NVARCHAR(50), [Adddate] datetime ) GO
/// <summary> /// 20180212 /// 涂聚文 /// </summary> //[Table("PotoUsers")] public class PotoUsers { /// <summary> /// /// </summary> //[Key] public int UserID { get; set; } /// <summary> /// /// </summary> public string UserName { get; set; } /// <summary> /// /// </summary> public string FirstName { get; set; } /// <summary> /// /// </summary> public string LastName { get; set; } /// <summary> /// /// </summary> public string MiddleName { get; set; } /// <summary> /// /// </summary> public string EmailID { get; set; } /// <summary> /// /// </summary> public DateTime Adddate { get; set; } }
/// <summary> /// 涂聚文 /// 20180212 /// </summary> public static class Mappings { public static void Initialize() { DapperExtensions.DapperExtensions.DefaultMapper = typeof(PluralizedAutoClassMapper<>); DapperExtensions.DapperExtensions.SetMappingAssemblies(new[] { typeof(Mappings).Assembly }); } /// <summary> /// /// </summary> public class PotoUsersMapper : ClassMapper<PotoUsers> { /// <summary> /// /// </summary> public PotoUsersMapper() { Table("PotoUsers"); //DuPotoUsers Map(Ducel => Ducel.UserID).Column("UserID").Key(KeyType.Identity); //主键类型 Map(Ducel => Ducel.UserName).Column("UserName"); Map(Ducel => Ducel.FirstName).Column("FirstName"); Map(Ducel => Ducel.LastName).Column("LastName"); Map(Ducel => Ducel.MiddleName).Column("MiddleName"); Map(Ducel => Ducel.EmailID).Column("EmailID"); Map(Ducel => Ducel.Adddate).Column("Adddate"); AutoMap(); } } }
string connStr = System.Configuration.ConfigurationManager.ConnectionStrings["conDuString"].ToString(); /// <summary> /// /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { try { using (SqlConnection cn = new SqlConnection(connStr)) { //1获取值 //cn.Open(); //int UserID = 1; //PotoUsers potoUsers = cn.Get<PotoUsers>(UserID); //cn.Close(); //Response.Write(person.UserName); //2插入值 //cn.Open(); //PotoUsers potoUsers = new PotoUsers { UserName = "geovindu", MiddleName = "", EmailID = "geovindu@163.com", FirstName = "Foo", LastName = "Bar", Adddate = DateTime.Now }; //int id = cn.Insert(person); //cn.Close(); //3 修改 //cn.Open(); //int UserID = 1; //PotoUsers potoUsers = cn.Get<PotoUsers>(UserID); //potoUsers.UserName = "涂聚文"; //potoUsers.LastName = "du"; //potoUsers.FirstName = "geovin"; //cn.Update(potoUsers); //cn.Close(); //4.删除 //cn.Open(); //int UserID = 1; //PotoUsers potoUsers = cn.Get<PotoUsers>(UserID); //cn.Delete(potoUsers); //cn.Close(); //5. cn.Open(); var predicate = Predicates.Field<PotoUsers>(f => f.UserID, Operator.Like, true); IEnumerable<PotoUsers> list = cn.GetList<PotoUsers>(predicate); cn.Close(); Response.Write(list.ToList<PotoUsers>().Count.ToString()); } } catch (SqlException ex) { Response.Write(ex.Message.ToString()); } } }
https://github.com/zzzprojects/Dapper-Plus
https://github.com/tmsmith/Dapper-Extensions
https://github.com/ericdc1/Dapper.SimpleCRUD
相关推荐
- Android系统编程入门系列之界面Activity交互响应
- 新型横向移动工具原理分析、代码分析、优缺点以及检测方案
- uni-app滚动视图容器(scroll-view)之监听上拉事件
- uniapp h5,app两端复制文本
- Android系统编程入门系列之界面Activity响应丝滑的传统动画
- 【Azure 应用服务】App Service 配置 Application Settings 访问Storage Account得到 could not be resolved: '*.file.core.windows.net'的报错。没有解析成对应中国区 Storage Account地址 *.file.core.chinacloudapi.cn
- 诺基亚短信生成!太好玩了
- iOS 跳转App Store进行评分
- 开发一个即时通讯App
- 关闭苹果IOS app自动更新
电脑软件
本类排行
- 1关闭苹果IOS app自动更新
- 2iOS 跳转App Store进行评分
- 3诺基亚短信生成!太好玩了
- 4Android系统编程入门系列之界面Activity响应丝滑的传统动画
- 5uniapp h5,app两端复制文本
- 6uni-app滚动视图容器(scroll-view)之监听上拉事件
- 7新型横向移动工具原理分析、代码分析、优缺点以及检测方案
- 8Android系统编程入门系列之界面Activity交互响应
- 9开发一个即时通讯App
- 10【Azure 应用服务】App Service 配置 Application Settings 访问Storage Account得到 could not be resolved: '*.file.core.windows.net'的报错。没有解析成对应中国区 Storage Account地址 *.file.core.chinacloudapi.cn