VB/C#.Net 实体代码生成工具 EntitysCodeGenerate【ECG】4.3
目 录
1 引言 ..........................................................................................................................................
3
2 内容 ..........................................................................................................................................
4
2.1 ORM框架的实现：VB/C#.Net实体代码生成工具(EntitysCodeGenerate).............4
2.2 在开发中的实际应用 ..................................................................................................5
2.2.1 单个实体对象的数据库操作 ..........................................................................6
1、获取一个实体对象信息.................................................................................6
2、插入一个实体对象信息.................................................................................6
3、更新一个实体对象信息.................................................................................6
4、保存一个实体对象信息.................................................................................6
5、删除一个实体对象信息.................................................................................7
6、取得实体映射表数值字段的最大值+1.........................................................7
2.2.2 多个实体对象的数据库操作 ..........................................................................7
1、实体集对象的使用.........................................................................................7
2、结合事务处理 ................................................................................................7
2.2.3 数据查询及通用DML操作 ................................................................................9
1、 常用实体对象查询.....................................................................................9
2、 ORM结构化查询 ..........................................................................................9
(1)、Select查询 ......................................................................................10
(2)、From连
接查询 ..................................................................................10
(3)、Where语句的Condition条件...........................................................11
(4)、Order By排序功能 ..........................................................................11
(5)、Group By分组条件
及排序 ..............................................................12
(6)、结合事
务处理的功能.......................................................................14
3、De
lete删除 ..................................................................................................15
4、Up
date更新 ..................................................................................................15
5、In
sert插入 ..................................................................................................16
2.2.4 DbCore+SQL/存储过程 ..................................................................................17
1、DbCore+SQL ..................................................................................................17
2、DbCore+存储过程.........................................................................................19
2.2.5 Extend辅助扩展功能 ....................................................................................20
1、TableHelp辅助扩展.....................................................................................20
2、CommonHelp常用方法扩展...........................................................................22
2.2.6 ORM的分析及与Xml的交互 ............................................................................22
1、ORM的分析 ....................................................................................................22
2、与XML的交互 ................................................................................................22
3 结束语 ....................................................................................................................................
23
4 相关下载地址 ........................................................................................................................24
lxchutao@163.com http://blog.csdn.net/chutao
2
