C#基础系列：实现自己的ORM（MiniORM的测试代码）

看到有同学反馈，说MiniORM代码有Bug，也不知道怎么用，所以今天我就写了些测试代码。希望能够给点帮助。
同时也发现了两Bug，一并罗列出：
1、MiniORM.PubFuncs.GetObjectType()函数：

1. publicstaticTypeGetObjectType(stringassemblyname,stringnamespacename,stringclassname)
2. {
3. TypeobjType=(Type)_HashObjectType[assemblyname+namespacename+classname];
5. if(objType==null)
6. {
7. objectobj=_HashObjectType[assemblyname+namespacename+classname];
9. obj=Assembly.Load(assemblyname).CreateInstance(namespacename+"."+classname);
11. _HashObjectType[assemblyname+namespacename+classname]=obj.GetType();
13. //需要增加这句
14. objType=(Type)_HashObjectType[assemblyname+namespacename+classname];
15. }
17. returnobjType;
18. }

2、MiniORM.OrmWriter.CheckValidate()函数：

1. publicvoidCheckValidate(objectModelObject)
2. {
3. PropertyInfo[]infos=ModelObject.GetType().GetProperties();
4. object[]CustomerAttributes=null;
5. object[]CustomerAttributes1=null;
7. //SELECTIDFROMTableNameWHERE@A=''OR@B=''
8. stringstrSQL="SELECTIDFROM{0}WHERE{1}";
9. stringstrTablename=PubFuncs.GetTableName(ModelObject);
10. stringstrWOA="";
11. stringstrWHERE="";
12. stringstrFieldMessage="";
14. foreach(PropertyInfoinfoininfos)
15. {
16. CustomerAttributes=info.GetCustomAttributes(typeof(MiniORMAttribute.DataFieldNotDoubleAttribute),false);
17. CustomerAttributes1=info.GetCustomAttributes(typeof(MiniORMAttribute.DataFieldAttribute),false);
19. if(CustomerAttributes!=null&&CustomerAttributes1!=null)
20. {
21. for(inti=0;i<CustomerAttributes.Length;i++)
22. {
23. strWHERE+=strWOA+((MiniORMAttribute.DataFieldAttribute)CustomerAttributes1[0]).FieldName+"='"+info.GetValue(ModelObject,null)+"'";
24. strFieldMessage+=((MiniORMAttribute.DataFieldAttribute)CustomerAttributes1[0]).FieldName;
25. strWOA="OR";
26. }
27. }
28. }
30. //这里需要做strWHERE不为空的判断
31. if(strWHERE.Trim()!="")
32. {
33. strSQL=string.Format(strSQL,newstring[]{strTablename,strWHERE});
35. using(SqlConnectionconn=newSqlConnection(PubFuncs.ConnectionStr))
36. {
37. conn.Open();
38. SqlCommandcmd=newSqlCommand();
39. cmd.Connection=conn;
40. cmd.CommandType=CommandType.Text;
41. cmd.CommandText=strSQL;
43. using(SqlDataReaderrdr=cmd.ExecuteReader())
44. {
45. if(rdr.Read())
46. {
47. thrownewException("下列字段值不能重复："+strFieldMessage);
48. }
49. }
50. }
51. }
52. }

测试代码如下：
首先是类关系图：

数据库表：

Person表：

Hand表：

Head表：

测试代码如下：

下面是类代码：

1. [DataObjectAttribute("Person","ID","")]
2. publicclassPerson
3. {
4. privateint_ID;
5. privatestring_Name;
6. privateint_Age;
7. privatestring_Sex;
8. privateHead_Head;
9. privateHand_LeftHand;
10. privateHand_RightHand;
12. [DataFieldAttribute("ID",true)]
13. publicintID
14. {
15. get{return_ID;}
16. set{_ID=value;}
17. }
19. [SubDataObjectAttribute(SubDataObjectFieldType.Object,"MiniORM","MiniORM","Head")]
20. publicHeadHead
21. {
22. get{return_Head;}
23. set{_Head=value;}
24. }
26. [SubDataObjectAttribute(SubDataObjectFieldType.Object,"MiniORM","MiniORM","Hand")]
27. publicHandLeftHand
28. {
29. get{return_LeftHand;}
30. set{_LeftHand=value;}
31. }
33. [SubDataObjectAttribute(SubDataObjectFieldType.Object,"MiniORM","MiniORM","Hand")]
34. publicHandRightHand
35. {
36. get{return_RightHand;}
37. set{_RightHand=value;}
38. }
40. [DataFieldAttribute("name","NvarChar")]
41. publicstringName
42. {
43. get{returnthis._Name;}
44. set{this._Name=value;}
45. }
47. [DataFieldAttribute("age","int")]
48. publicintAge
49. {
50. get{returnthis._Age;}
51. set{this._Age=value;}
52. }
54. [DataFieldAttribute("sex","NvarChar")]
55. publicstringSex
56. {
57. get{returnthis._Sex;}
58. set{this._Sex=value;}
59. }
61. publicHandHand
62. {
63. get
64. {
65. thrownewSystem.NotImplementedException();
66. }
67. set
68. {
69. }
70. }
72. publicHeadHead1
73. {
74. get
75. {
76. thrownewSystem.NotImplementedException();
77. }
78. set
79. {
80. }
81. }
82. }
84. [DataObjectAttribute("Hand","ID","PersonID")]
85. publicclassHand
86. {
87. privateint_ID;
88. privateint_PersonID;
89. privatestring_Name;
91. [DataFieldAttribute("ID",true)]
92. publicintID
93. {
94. get{returnthis._ID;}
95. set{this._ID=value;}
96. }
98. [DataFieldAttribute("PersonID")]
99. publicintPersonID
100. {
101. get{returnthis._PersonID;}
102. set{this._PersonID=value;}
103. }
105. [DataFieldAttribute("name","NvarChar")]
106. publicstringName
107. {
108. get{return_Name;}
109. set{_Name=value;}
110. }
111. }
113. [DataObjectAttribute("Head","ID","PersonID")]
114. publicclassHead
115. {
116. privateint_ID;
117. privateint_PersonID;
118. privatestring_Name;
120. [DataFieldAttribute("ID",true)]
121. publicintID
122. {
123. get{returnthis._ID;}
124. set{this._ID=value;}
125. }
127. [DataFieldAttribute("PersonID")]
128. publicintPersonID
129. {
130. get{returnthis._PersonID;}
131. set{this._PersonID=value;}
132. }
134. [DataFieldAttribute("name","NvarChar")]
135. publicstringName
136. {
137. get{return_Name;}
138. set{_Name=value;}
139. }
140. }

下面是测试代码：

1. [STAThread]
2. staticvoidMain()
3. {
4. //插入测试
5. WriteTest();
7. //读取测试
8. ReadTest();
9. }
11. privatestaticvoidWriteTest()
12. {
13. Personperson=newPerson();
14. person.Name="snoopy";
15. person.Age=5;
16. person.Sex="male";
18. Handlefthand=newHand();
19. lefthand.Name="左手";
21. Handrighthand=newHand();
22. righthand.Name="右手";
24. Headhead=newHead();
25. head.Name="大笨脑袋";
27. person.LeftHand=lefthand;
28. person.RightHand=righthand;
29. person.Head=head;
31. MiniORM.OrmWriterwrite=newOrmWriter();
32. write.Write(person);
33. }
35. privatestaticvoidReadTest()
36. {
37. MiniORM.OrmReaderreader=newOrmReader();
38. Personperson=(Person)reader.Read(newPerson(),1);
41. Console.WriteLine("person.Name:"+person.Name);
42. Console.WriteLine("person.Age:"+person.Age);
43. Console.WriteLine("person.Sex:"+person.Sex);
44. Console.WriteLine("LeftHand.Name:"+person.LeftHand.Name);
45. Console.WriteLine("RightHand.Name:"+person.RightHand.Name);
46. Console.WriteLine("Head.Name:"+person.Head.Name);
48. Console.Read();
49. }

ReadTest的测试结果如：

好了，各位，你可以使用这个调试代码来试试了。。。

相关文章：

C#基础系列：实现自己的ORM（ORM的基础概念）

C#基础系列：实现自己的ORM（反射以及Attribute在ORM中的应用）

C#基础系列：实现自己的ORM（构造我自己的ORM）

源代码下载