My Great World

在使用dotnet自带的mail类发送邮件的时候，因为默认的smtp端口是25，如果更改了smtp的端口号，则需加上
MailMessage msg ＝ new MailMessage();
msg.Fields.Add("http://schemas.microsoft.com/cdo/configuration/smtpserverport", "端口号"）

出现的问题：
NHibernate.MappingException : The dialect was not set. Set the property hibernate.dialect.
  ----> NHibernate.HibernateException : The dialect was not set. Set the property hibernate.dialect.
问题解决：
将web.config更名为***.dll.config （***为你要测试的项目名称），并把该文件放在bin里

SQL语句
1.select * from (tablename) for xml auto
如NorthWind中的Course表
结果：
 "<Course courseid=""1"" coursename=""English""/><Course courseid=""2"" coursename=""Chinese""/><Course courseid=""3"" coursename=""Franch""/><Course courseid=""4"" coursename=""Math""/><Course courseid=""5"" coursename=""Science""/>"
2.select * from (tablename) for xml auto,elements
结果：
<Course><courseid>1</courseid><coursename>English</coursename></Course>
<Course><courseid>2</courseid><coursename>Chinese</coursename></Course>
<Course><courseid>3</courseid><coursename>Franch</coursename></Course>
<Course><courseid>4</courseid><coursename>Math</coursename></Course>
<Course><courseid>5</courseid><coursename>Science</coursename></Course>