总结
自定义ORMapping，主要完成两个功能，第一：SQL语句的生成和执行；第二：DataTable转换为相应的集合，本片博客和之前的那篇博客只是简单的完成了这个功能，具体的代码大家可以在这里下载。
自定义ORMapping―动态生成SQL语句(四)
2", CompareOperationConst.EqualTo, LogicOperatorConst.None); }); //List
sonList = father1.ListSon; User user = new User() {UserName="青山111",UserSex="男111", Addr="地址", Content="内容" }; #region Table转换为实体 //DataTable dt = new DataTable("T_Users"); //dt.Columns.Add(new DataColumn("Id", typeof(string))); //dt.Columns.Add(new DataColumn("Name", typeof(string))); //dt.Columns.Add(new DataColumn("Sex", typeof(string))); ////1、创建行 //DataRow dr = dt.NewRow(); ////2、赋值行 //dr["Id"] = "10040242041"; //dr["Name"] = "青山"; //dr["Sex"] = "青山"; //dt.Rows.Add(dr); //List
userList = ORMapping.ToList
(dt); #endregion #region insert语句 int insertCount = DataManager
.Add(user); #endregion #region delete删除 int intDelete1 = DataManager
.Delete(user); int intDelete2 = DataManager
.Delete(user, p => { p.Append("Id", "1", CompareOperationConst.EqualTo, LogicOperatorConst.And); p.Append("Name", "qingshan", CompareOperationConst.Like, LogicOperatorConst.Or); p.Append("Sex", "男", CompareOperationConst.Like, LogicOperatorConst.None); }); #endregion #region select语句 List
userList1 = DataManager
.Load(); List
userList2 = DataManager
.Load(p => { p.Append("Id", "2", CompareOperationConst.EqualTo, LogicOperatorConst.And); p.Append("Name", "女", CompareOperationConst.Like, LogicOperatorConst.None); }); #endregion #region update语句 int intUpdateCount1 = DataManager
.Update(user); int intUpdateCount2 = DataManager
.Update(user, p => { p.Append("Id", "1", CompareOperationConst.EqualTo, LogicOperatorConst.And); p.Append("Name", "qingshan", CompareOperationConst.Like, LogicOperatorConst.Or); p.Append("Sex", "男", CompareOperationConst.Like, LogicOperatorConst.None); }); #endregion Console.ReadKey(); }