<?xml version="1.0" encoding="UTF-8"?>
  <feed xmlns="http://www.w3.org/2005/Atom">
  <title type="html"><![CDATA[卿搏人生]]></title>
  <subtitle type="html"><![CDATA[有志者事竟成，破釜沉舟，百二秦关终属楚。 苦心人天不负，卧薪尝胆，千三越甲可吞吴。]]></subtitle>
  <id>http://www.yacosoft.com/</id>
  <link rel="alternate" type="text/html" href="http://www.yacosoft.com/" /> 
  <link rel="self" type="application/atom+xml" href="http://www.yacosoft.com/atom.asp" /> 
  <generator uri="http://www.pjhome.net/" version="2.8">PJBlog3</generator> 
  <updated>2010-02-14T11:45:46+08:00</updated>

  <entry>
	  <title type="html"><![CDATA[给朋友们拜年啦！]]></title>
	  <author>
		 <name>卿卿</name>
		 <uri>http://www.yacosoft.com/</uri>
		 <email>zyq_17@qq.com</email>
	  </author>
	  <category term="" scheme="http://www.yacosoft.com/default.asp?cateID=3" label="公告" /> 
	  <updated>2010-02-14T11:45:46+08:00</updated>
	  <published>2010-02-14T11:45:46+08:00</published>
		  <summary type="html"><![CDATA[<p>给大家拜年啦！祝福大家在虎年里身体健康，万事如意！</p>]]></summary>
	  <link rel="alternate" type="text/html" href="http://www.yacosoft.com/article.asp?id=40" /> 
	  <id>http://www.yacosoft.com/default.asp?id=40</id>
  </entry>	
		
  <entry>
	  <title type="html"><![CDATA[.Net FrameWork 3.5下面 sdkvars.bat 不存在解决方案]]></title>
	  <author>
		 <name>卿卿</name>
		 <uri>http://www.yacosoft.com/</uri>
		 <email>zyq_17@qq.com</email>
	  </author>
	  <category term="" scheme="http://www.yacosoft.com/default.asp?cateID=14" label="软件技术" /> 
	  <updated>2009-12-16T11:10:03+08:00</updated>
	  <published>2009-12-16T11:10:03+08:00</published>
		  <summary type="html"><![CDATA[.Net FrameWork 3.5下面找不到这个文件，2.0版本里面有。在3.5下可以手动建立这个文件。<br/><br/>1.确认这个目录存在<br/><br/>C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727<br/><br/>2.确认这个目录也存在<br/><br/>C:\Program Files\Microsoft SDKs\Windows\v6.0A<br/><br/>3.建立名为sdkvars.bat的文件，并把下列代码复制进去即可。<br/><br/>@Set NetPath=C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727 <br/>@Set NetSamplePath=C:\Program Files\Microsoft SDKs\Windows\v6.0A <br/>@Set Path=%NetPath%;%NetSamplePath%;%NetSamplePath%\Bin;%PATH% <br/>@Set LIB=%NetSamplePath%\Lib;%LIB% <br/>@Set INCLUDE=%NetSamplePath%\include;%INCLUDE%<br/>]]></summary>
	  <link rel="alternate" type="text/html" href="http://www.yacosoft.com/article.asp?id=39" /> 
	  <id>http://www.yacosoft.com/default.asp?id=39</id>
  </entry>	
		
  <entry>
	  <title type="html"><![CDATA[姜的二十种食疗功­]]></title>
	  <author>
		 <name>卿卿</name>
		 <uri>http://www.yacosoft.com/</uri>
		 <email>zyq_17@qq.com</email>
	  </author>
	  <category term="" scheme="http://www.yacosoft.com/default.asp?cateID=11" label="感悟人生" /> 
	  <updated>2009-12-04T19:06:53+08:00</updated>
	  <published>2009-12-04T19:06:53+08:00</published>
		  <summary type="html"><![CDATA[<p><font color="#717171" face="Arial" style="line-height: normal"><font color="#8b0000" style="line-height: 1.8em"><font face="黑体" style="line-height: 1.8em"><font size="3" style="line-height: 1.8em">　　研究证明，生姜含姜辣素、芳香醇、姜烯、水芳烯、茨烯、氨基酸、尼克酸、柠檬酸、抗坏血酸、蛋白质、脂肪、硫胺素、核黄素、胡萝卜素、粗纤维素及钙、铁、磷等，具有较高的营养价值。生姜具有特殊的辣味和香味，可调味添香，是生活中不可缺少的调配菜，可做腥味较强的鱼肉之调配菜，可生食、熟食，可腌渍、盐渍、醋渍，可加工成姜汁、姜粉、姜酒、姜干，可提炼制作香料的原料。&shy;</font></font></font></font></p>
<p><font color="#717171" face="Arial" style="line-height: normal"><font color="#8b0000" style="line-height: 1.8em"><font face="黑体" style="line-height: 1.8em"><font size="3" style="line-height: 1.8em">　　生姜甘辛而温，具有散寒发汗、温胃止吐、杀菌镇痛、抗炎之功效，还能舒张毛细血管，增强血液循环，兴奋肠胃，帮助消化。鲜姜可用于&ldquo;风寒邪热、伤寒头痛、鼻塞、咳逆止气、止呕、祛痰下气&rdquo;。干姜适于&ldquo;寒冷腹痛、中恶霍乱、胀满、风邪消毒、皮肤间结气、止唾血&rdquo;。民间在生活实践和医疗实践中，逐步摸索出许多用生姜治病的验方，而且具有良好疗效。&shy;</font></font></font></font></p>
<p><font color="#717171" face="Arial" style="line-height: normal"><font color="#8b0000" style="line-height: 1.8em"><font face="黑体" style="line-height: 1.8em"><font size="3" style="line-height: 1.8em">　　l、&nbsp;治呕吐不止：生姜汁一汤匙，蜂蜜2汤匙，加开水3汤匙调匀，煮沸后一次服下。&shy;</font></font></font></font></p>
<p><font color="#717171" face="Arial" style="line-height: normal"><font color="#8b0000" style="line-height: 1.8em"><font face="黑体" style="line-height: 1.8em"><font size="3" style="line-height: 1.8em">　　2、&nbsp;治风寒骨疼、关节疼：&shy;</font></font></font></font></p>
<p><font color="#717171" face="Arial" style="line-height: normal"><font color="#8b0000" style="line-height: 1.8em"><font face="黑体" style="line-height: 1.8em"><font size="3" style="line-height: 1.8em">　　①生姜、葱白各适量，捣烂炒热，用布包好熨敷患处，一日数次。&shy;</font></font></font></font></p>
<p><font color="#717171" face="Arial" style="line-height: normal"><font color="#8b0000" style="line-height: 1.8em"><font face="黑体" style="line-height: 1.8em"><font size="3" style="line-height: 1.8em">　　②生姜数片放患处，用艾条灸之。&shy;</font></font></font></font></p>
<p><font color="#717171" face="Arial" style="line-height: normal"><font color="#8b0000" style="line-height: 1.8em"><font face="黑体" style="line-height: 1.8em"><font size="3" style="line-height: 1.8em">　　3、&nbsp;治胃病发作：生姜、桂皮各12克，加水适量煎汤服下，一日2次。&shy;</font></font></font></font></p>
<p><font color="#717171" face="Arial" style="line-height: normal"><font color="#8b0000" style="line-height: 1.8em"><font face="黑体" style="line-height: 1.8em"><font size="3" style="line-height: 1.8em">　　4、&nbsp;治胃、十二指肠溃疡：生姜25克切碎，放在一个猪肚中，加水用文火炖烂，分数次食用。&shy;</font></font></font></font></p>
<p><font color="#717171" face="Arial" style="line-height: normal"><font color="#8b0000" style="line-height: 1.8em"><font face="黑体" style="line-height: 1.8em"><font size="3" style="line-height: 1.8em">　　5、&nbsp;治中暑昏厥：生姜、韭菜各适量，大蒜1头，共捣烂取汁灌服。&shy;</font></font></font></font></p>
<p><font color="#717171" face="Arial" style="line-height: normal"><font color="#8b0000" style="line-height: 1.8em"><font face="黑体" style="line-height: 1.8em"><font size="3" style="line-height: 1.8em">　　6、&nbsp;治急性菌痢：生姜25克，红糖50克，共捣成糊状，一日3次分服，连服数日。&shy;</font></font></font></font></p>
<p><font color="#717171" face="Arial" style="line-height: normal"><font color="#8b0000" style="line-height: 1.8em"><font face="黑体" style="line-height: 1.8em"><font size="3" style="line-height: 1.8em">　　7、&nbsp;治产后腹疼：生姜、当归各150克，羊肉1000克，加水适量炖汤，分次服下。&shy;</font></font></font></font></p>
<p><font color="#717171" face="Arial" style="line-height: normal"><font color="#8b0000" style="line-height: 1.8em"><font face="黑体" style="line-height: 1.8em"><font size="3" style="line-height: 1.8em">　　8、&nbsp;治跌打损伤、腰扭伤：生姜、芋头各半捣成泥状，加面粉适量调匀，贴敷患处，每日更换2次。&shy;</font></font></font></font></p>
<p><font color="#717171" face="Arial" style="line-height: normal"><font color="#8b0000" style="line-height: 1.8em"><font face="黑体" style="line-height: 1.8em"><font size="3" style="line-height: 1.8em">　　9、&nbsp;治急性肠胃炎：生姜5片，茶叶20克，大蒜1头，捣碎，煎水调红糖适量饮下，每日3次。&shy;</font></font></font></font></p>
<p><font color="#717171" face="Arial" style="line-height: normal"><font color="#8b0000" style="line-height: 1.8em"><font face="黑体" style="line-height: 1.8em"><font size="3" style="line-height: 1.8em">　　10、&nbsp;治寒痢：生姜4片，茶叶15克，煎浓加半汤匙食醋，趁热饮服，每日3次。&shy;</font></font></font></font></p>
<p><font color="#717171" face="Arial" style="line-height: normal"><font color="#8b0000" style="line-height: 1.8em"><font face="黑体" style="line-height: 1.8em"><font size="3" style="line-height: 1.8em">　　11、&nbsp;治热痢：生姜&nbsp;4片，茶叶15克，黄连6克，煎水晾凉饮服，每日3次。&shy;</font></font></font></font></p>
<p><font color="#717171" face="Arial" style="line-height: normal"><font color="#8b0000" style="line-height: 1.8em"><font face="黑体" style="line-height: 1.8em"><font size="3" style="line-height: 1.8em">　　12、&nbsp;治疟疾：生姜&nbsp;4片，茶叶15克，煎水调红糖适量，趁热饮下，每日2次。&shy;</font></font></font></font></p>
<p><font color="#717171" face="Arial" style="line-height: normal"><font color="#8b0000" style="line-height: 1.8em"><font face="黑体" style="line-height: 1.8em"><font size="3" style="line-height: 1.8em">　　13、&nbsp;治晕车晕船：生姜1片贴于肚脐，外贴1张伤湿止痛膏，有明显的缓解作用。&shy;</font></font></font></font></p>
<p><font color="#717171" face="Arial" style="line-height: normal"><font color="#8b0000" style="line-height: 1.8em"><font face="黑体" style="line-height: 1.8em"><font size="3" style="line-height: 1.8em">　　14、&nbsp;治冻疮、冻伤：生姜适量捣烂，泡在适量的白酒中，取汁液加温擦拭患处，每日3次。&shy;</font></font></font></font></p>
<p><font color="#717171" face="Arial" style="line-height: normal"><font color="#8b0000" style="line-height: 1.8em"><font face="黑体" style="line-height: 1.8em"><font size="3" style="line-height: 1.8em">　　15、&nbsp;治脚汗太多：生姜15克，枯矾15克，熬水洗泡脚，每日1次。&shy;</font></font></font></font></p>
<p><font color="#717171" face="Arial" style="line-height: normal"><font color="#8b0000" style="line-height: 1.8em"><font face="黑体" style="line-height: 1.8em"><font size="3" style="line-height: 1.8em">　　16、&nbsp;治伤风咳嗽、虚寒久咳：生姜5片，加适量核桃肉、红糖捣烂食之。&shy;</font></font></font></font></p>
<p><font color="#717171" face="Arial" style="line-height: normal"><font color="#8b0000" style="line-height: 1.8em"><font face="黑体" style="line-height: 1.8em"><font size="3" style="line-height: 1.8em">　　17、&nbsp;治红白痢疾：生姜、绿茶等份，加水适量煎浓饮之。&shy;</font></font></font></font></p>
<p><font color="#717171" face="Arial" style="line-height: normal"><font color="#8b0000" style="line-height: 1.8em"><font face="黑体" style="line-height: 1.8em"><font size="3" style="line-height: 1.8em">　　18、&nbsp;治妇女虚寒腹疼：生姜、红糖适量煎水服用。&shy;</font></font></font></font></p>
<p><font color="#717171" face="Arial" style="line-height: normal"><font color="#8b0000" style="line-height: 1.8em"><font face="黑体" style="line-height: 1.8em"><font size="3" style="line-height: 1.8em">　　19、&nbsp;发汗解表、温肺止咳：生姜10片，茶叶7克，煎水趁热饮服。&shy;</font></font></font></font></p>
<p><font color="#717171" face="Arial" style="line-height: normal"><font color="#8b0000" style="line-height: 1.8em"><font face="黑体" style="line-height: 1.8em"><font size="3" style="line-height: 1.8em">　　20、&nbsp;治风寒感冒：&shy;</font></font></font></font></p>
<p><font color="#717171" face="Arial" style="line-height: normal"><font color="#8b0000" style="line-height: 1.8em"><font face="黑体" style="line-height: 1.8em"><font size="3" style="line-height: 1.8em">　　①生姜数片，白萝卜250克，红糖适量，煎汤趁热饮下，出汗即解。&shy;</font></font></font></font></p>
<p><font color="#717171" face="Arial" style="line-height: normal"><font color="#8b0000" style="line-height: 1.8em"><font face="黑体" style="line-height: 1.8em"><font size="3" style="line-height: 1.8em">　　②生姜6克，葱白5根，红糖适量，煎汤热服，对感冒初起或症状轻有效。&shy;</font></font></font></font></p>
<p><font color="#717171" face="Arial" style="line-height: normal"><font color="#8b0000" style="line-height: 1.8em"><font face="黑体" style="line-height: 1.8em"><font size="3" style="line-height: 1.8em">　　③生姜90克，白萝卜60克，荸荠60克，捣烂取汁，分3次用开水冲服，每日一剂。&shy;</font></font></font></font></p>
<p><font color="#717171" face="Arial" style="line-height: normal"><font color="#8b0000" style="line-height: 1.8em"><font face="黑体" style="line-height: 1.8em"><font size="3" style="line-height: 1.8em">　　④生姜6克，葱白2恨，大枣4枚，煎汤服用，对症轻无汗、身困者有效。&shy;</font></font></font></font></p>
<p><font color="#717171" face="Arial" style="line-height: normal"><font color="#8b0000" style="line-height: 1.8em"><font face="黑体" style="line-height: 1.8em"><font size="3" style="line-height: 1.8em">　　⑤生姜5克，葱白1根，绿豆15克，萝卜30克，大枣&nbsp;4枚，煎水服用，每日3次，开水冲服，对感冒发烧、口渴而表未解者有效。&shy;</font></font></font></font></p>
<p><font color="#717171" face="Arial" style="line-height: normal"><font color="#8b0000" style="line-height: 1.8em"><font face="黑体" style="line-height: 1.8em"><font size="3" style="line-height: 1.8em">　　⑥生姜、葱白各30克，食盐6克，白酒一盅。将生姜、葱白、食盐共捣成泥状，加白酒调匀，涂擦前胸、后背、肘窝、手心、脚心，对&shy;</font></font></font></font></p>
<p><font color="#717171" face="Arial" style="line-height: normal"><font color="#8b0000" style="line-height: 1.8em"><font face="黑体" style="line-height: 1.8em"><font size="3" style="line-height: 1.8em">　　感冒身疼、关节酸疼、发热不降有效。&shy;</font></font></font></font></p>
<p><font color="#717171" face="Arial" style="line-height: normal"><font color="#8b0000" style="line-height: 1.8em"><font face="黑体" style="line-height: 1.8em"><font size="3" style="line-height: 1.8em">　　⑦老姜10克煨热，切开擦百会、大椎或由大椎向下擦至命门，以皮肤微红为度，可消除恶寒怕冷、全身酸疼。&shy;</font></font></font></font></p>
<p><font color="#717171" face="Arial" style="line-height: normal"><font color="#8b0000" style="line-height: 1.8em"><font face="黑体" style="line-height: 1.8em"><font size="3" style="line-height: 1.8em">　　生姜在细菌作用下可发酵腐烂，产生黄樟素物质，能诱发食道癌、肝癌，对人体健康有严重危害，故腐烂的生姜不能吃。</font></font></font></font></p>]]></summary>
	  <link rel="alternate" type="text/html" href="http://www.yacosoft.com/article.asp?id=38" /> 
	  <id>http://www.yacosoft.com/default.asp?id=38</id>
  </entry>	
		
  <entry>
	  <title type="html"><![CDATA[HTML符号、常规符号及其代码对照表]]></title>
	  <author>
		 <name>卿卿</name>
		 <uri>http://www.yacosoft.com/</uri>
		 <email>zyq_17@qq.com</email>
	  </author>
	  <category term="" scheme="http://www.yacosoft.com/default.asp?cateID=4" label="经典源码" /> 
	  <updated>2009-09-09T14:23:07+08:00</updated>
	  <published>2009-09-09T14:23:07+08:00</published>
		  <summary type="html"><![CDATA[<table border="0" cellspacing="0" cellpadding="0" width="98%" align="center" style="table-layout: fixed">
    <tbody>
        <tr>
            <td width="100%" align="center">&nbsp;</td>
        </tr>
        <tr>
            <td style="word-wrap: break-word"><font class="news"><center style="font-family: 黑体; color: red; font-size: 20px">
            <form name="font">
                符号、常规符号及其代码对照表
            </form>
            </center>
            <p>
            <table border="1" cellspacing="0" cellpadding="0" width="100%">
                <tbody>
                    <tr>
                        <td bgcolor="menu" valign="middle" bordercolor="menu" width="7%" align="center" style="font-family: fixedsys; color: red">代码</td>
                        <td id="F0" bgcolor="menu" valign="middle" width="11%" align="center" style="font-family: fixedsys; color: red">Webdings</td>
                        <td bgcolor="menu" valign="middle" bordercolor="menu" width="7%" align="center" style="font-family: fixedsys; color: red">常规</td>
                        <td bgcolor="menu" valign="middle" bordercolor="menu" width="7%" align="center" style="font-family: fixedsys; color: red">代码</td>
                        <td id="F1" bgcolor="menu" valign="middle" width="11%" align="center" style="font-family: fixedsys; color: red">Webdings</td>
                        <td bgcolor="menu" valign="middle" bordercolor="menu" width="7%" align="center" style="font-family: fixedsys; color: red">常规</td>
                        <td bgcolor="menu" valign="middle" bordercolor="menu" width="7%" align="center" style="font-family: fixedsys; color: red">代码</td>
                        <td id="F2" bgcolor="menu" valign="middle" width="11%" align="center" style="font-family: fixedsys; color: red">Webdings</td>
                        <td bgcolor="menu" valign="middle" bordercolor="menu" width="7%" align="center" style="font-family: fixedsys; color: red">常规</td>
                        <td bgcolor="menu" valign="middle" bordercolor="menu" width="7%" align="center" style="font-family: fixedsys; color: red">代码</td>
                        <td id="F3" bgcolor="menu" valign="middle" width="11%" align="center" style="font-family: fixedsys; color: red">Webdings</td>
                        <td bgcolor="menu" valign="middle" bordercolor="menu" width="7%" align="center" style="font-family: fixedsys; color: red">常规</td>
                    </tr>
                    <tr style="height: 30px">
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>32;</td>
                        <td id="f32" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">&nbsp;</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">&nbsp;</td>
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>33;</td>
                        <td id="f33" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">!</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">!</td>
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>34;</td>
                        <td id="f34" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">&quot;</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">&quot;</td>
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>35;</td>
                        <td id="f35" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">#</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">#</td>
                    </tr>
                    <tr style="height: 30px">
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>36;</td>
                        <td id="f36" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">$</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">$</td>
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>37;</td>
                        <td id="f37" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">%</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">%</td>
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>38;</td>
                        <td id="f38" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">&amp;</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">&amp;</td>
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>39;</td>
                        <td id="f39" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">'</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">'</td>
                    </tr>
                    <tr style="height: 30px">
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>40;</td>
                        <td id="f40" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">(</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">(</td>
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>41;</td>
                        <td id="f41" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">)</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">)</td>
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>42;</td>
                        <td id="f42" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">*</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">*</td>
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>43;</td>
                        <td id="f43" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">+</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">+</td>
                    </tr>
                    <tr style="height: 30px">
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>44;</td>
                        <td id="f44" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">,</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">,</td>
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>45;</td>
                        <td id="f45" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">-</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">-</td>
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>46;</td>
                        <td id="f46" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">.</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">.</td>
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>47;</td>
                        <td id="f47" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">/</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">/</td>
                    </tr>
                    <tr style="height: 30px">
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>48;</td>
                        <td id="f48" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">0</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">0</td>
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>49;</td>
                        <td id="f49" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">1</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">1</td>
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>50;</td>
                        <td id="f50" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">2</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">2</td>
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>51;</td>
                        <td id="f51" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">3</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">3</td>
                    </tr>
                    <tr style="height: 30px">
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>52;</td>
                        <td id="f52" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">4</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">4</td>
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>53;</td>
                        <td id="f53" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">5</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">5</td>
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>54;</td>
                        <td id="f54" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">6</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">6</td>
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>55;</td>
                        <td id="f55" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">7</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">7</td>
                    </tr>
                    <tr style="height: 30px">
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>56;</td>
                        <td id="f56" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">8</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">8</td>
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>57;</td>
                        <td id="f57" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">9</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">9</td>
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>58;</td>
                        <td id="f58" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">:</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">:</td>
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>59;</td>
                        <td id="f59" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">;</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">;</td>
                    </tr>
                    <tr style="height: 30px">
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>60;</td>
                        <td id="f60" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">&lt;</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">&lt;</td>
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>61;</td>
                        <td id="f61" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">=</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">=</td>
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>62;</td>
                        <td id="f62" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">&gt;</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">&gt;</td>
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>63;</td>
                        <td id="f63" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">?</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">?</td>
                    </tr>
                    <tr style="height: 30px">
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>64;</td>
                        <td id="f64" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">@</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">@</td>
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>65;</td>
                        <td id="f65" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">A</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">A</td>
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>66;</td>
                        <td id="f66" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">B</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">B</td>
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>67;</td>
                        <td id="f67" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">C</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">C</td>
                    </tr>
                    <tr style="height: 30px">
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>68;</td>
                        <td id="f68" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">D</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">D</td>
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>69;</td>
                        <td id="f69" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">E</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">E</td>
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>70;</td>
                        <td id="f70" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">F</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">F</td>
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>71;</td>
                        <td id="f71" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">G</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">G</td>
                    </tr>
                    <tr style="height: 30px">
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>72;</td>
                        <td id="f72" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">H</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">H</td>
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>73;</td>
                        <td id="f73" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">I</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">I</td>
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>74;</td>
                        <td id="f74" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">J</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">J</td>
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>75;</td>
                        <td id="f75" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">K</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">K</td>
                    </tr>
                    <tr style="height: 30px">
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>76;</td>
                        <td id="f76" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">L</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">L</td>
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>77;</td>
                        <td id="f77" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">M</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">M</td>
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>78;</td>
                        <td id="f78" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">N</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">N</td>
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>79;</td>
                        <td id="f79" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">O</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">O</td>
                    </tr>
                    <tr style="height: 30px">
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>80;</td>
                        <td id="f80" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">P</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">P</td>
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>81;</td>
                        <td id="f81" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">Q</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">Q</td>
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>82;</td>
                        <td id="f82" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">R</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">R</td>
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>83;</td>
                        <td id="f83" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">S</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">S</td>
                    </tr>
                    <tr style="height: 30px">
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>84;</td>
                        <td id="f84" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">T</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">T</td>
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>85;</td>
                        <td id="f85" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">U</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">U</td>
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>86;</td>
                        <td id="f86" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">V</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">V</td>
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>87;</td>
                        <td id="f87" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">W</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">W</td>
                    </tr>
                    <tr style="height: 30px">
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>88;</td>
                        <td id="f88" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">X</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">X</td>
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>89;</td>
                        <td id="f89" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">Y</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">Y</td>
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>90;</td>
                        <td id="f90" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">Z</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">Z</td>
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>91;</td>
                        <td id="f91" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">[</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">[</td>
                    </tr>
                    <tr style="height: 30px">
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>92;</td>
                        <td id="f92" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">\</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">\</td>
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>93;</td>
                        <td id="f93" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">]</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">]</td>
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>94;</td>
                        <td id="f94" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">^</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">^</td>
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>95;</td>
                        <td id="f95" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">_</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">_</td>
                    </tr>
                    <tr style="height: 30px">
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>96;</td>
                        <td id="f96" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">`</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">`</td>
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>97;</td>
                        <td id="f97" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">a</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">a</td>
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>98;</td>
                        <td id="f98" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">b</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">b</td>
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>99;</td>
                        <td id="f99" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">c</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">c</td>
                    </tr>
                    <tr style="height: 30px">
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>100;</td>
                        <td id="f100" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">d</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">d</td>
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>101;</td>
                        <td id="f101" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">e</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">e</td>
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>102;</td>
                        <td id="f102" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">f</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">f</td>
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>103;</td>
                        <td id="f103" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">g</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">g</td>
                    </tr>
                    <tr style="height: 30px">
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>104;</td>
                        <td id="f104" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">h</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">h</td>
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>105;</td>
                        <td id="f105" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">i</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">i</td>
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>106;</td>
                        <td id="f106" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">j</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">j</td>
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>107;</td>
                        <td id="f107" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">k</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">k</td>
                    </tr>
                    <tr style="height: 30px">
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>108;</td>
                        <td id="f108" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">l</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">l</td>
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>109;</td>
                        <td id="f109" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">m</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">m</td>
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>110;</td>
                        <td id="f110" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">n</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">n</td>
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>111;</td>
                        <td id="f111" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">o</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">o</td>
                    </tr>
                    <tr style="height: 30px">
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>112;</td>
                        <td id="f112" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">p</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">p</td>
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>113;</td>
                        <td id="f113" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">q</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">q</td>
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>114;</td>
                        <td id="f114" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">r</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">r</td>
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>115;</td>
                        <td id="f115" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">s</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">s</td>
                    </tr>
                    <tr style="height: 30px">
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>116;</td>
                        <td id="f116" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">t</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">t</td>
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>117;</td>
                        <td id="f117" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">u</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">u</td>
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>118;</td>
                        <td id="f118" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">v</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">v</td>
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>119;</td>
                        <td id="f119" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">w</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">w</td>
                    </tr>
                    <tr style="height: 30px">
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>120;</td>
                        <td id="f120" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">x</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">x</td>
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>121;</td>
                        <td id="f121" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">y</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">y</td>
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>122;</td>
                        <td id="f122" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">z</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">z</td>
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>123;</td>
                        <td id="f123" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">{</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">{</td>
                    </tr>
                    <tr style="height: 30px">
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>124;</td>
                        <td id="f124" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">|</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">|</td>
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>125;</td>
                        <td id="f125" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">}</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">}</td>
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>126;</td>
                        <td id="f126" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">~</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">~</td>
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>127;</td>
                        <td id="f127" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px"></td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px"></td>
                    </tr>
                    <tr style="height: 30px">
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>128;</td>
                        <td id="f128" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">&euro;</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">&euro;</td>
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>129;</td>
                        <td id="f129" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px"></td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px"></td>
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>130;</td>
                        <td id="f130" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">&sbquo;</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">&sbquo;</td>
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>131;</td>
                        <td id="f131" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">&fnof;</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">&fnof;</td>
                    </tr>
                    <tr style="height: 30px">
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>132;</td>
                        <td id="f132" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">&bdquo;</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">&bdquo;</td>
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>133;</td>
                        <td id="f133" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">&hellip;</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">&hellip;</td>
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>134;</td>
                        <td id="f134" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">&dagger;</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">&dagger;</td>
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>135;</td>
                        <td id="f135" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">&Dagger;</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">&Dagger;</td>
                    </tr>
                    <tr style="height: 30px">
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>136;</td>
                        <td id="f136" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">&circ;</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">&circ;</td>
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>137;</td>
                        <td id="f137" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">&permil;</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">&permil;</td>
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>138;</td>
                        <td id="f138" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">&Scaron;</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">&Scaron;</td>
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>139;</td>
                        <td id="f139" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">&lsaquo;</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">&lsaquo;</td>
                    </tr>
                    <tr style="height: 30px">
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>140;</td>
                        <td id="f140" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">&OElig;</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">&OElig;</td>
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>141;</td>
                        <td id="f141" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px"></td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px"></td>
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>142;</td>
                        <td id="f142" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">Ž</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">Ž</td>
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>143;</td>
                        <td id="f143" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px"></td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px"></td>
                    </tr>
                    <tr style="height: 30px">
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>144;</td>
                        <td id="f144" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px"></td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px"></td>
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>145;</td>
                        <td id="f145" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">&lsquo;</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">&lsquo;</td>
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>146;</td>
                        <td id="f146" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">&rsquo;</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">&rsquo;</td>
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>147;</td>
                        <td id="f147" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">&ldquo;</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">&ldquo;</td>
                    </tr>
                    <tr style="height: 30px">
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>148;</td>
                        <td id="f148" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">&rdquo;</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">&rdquo;</td>
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>149;</td>
                        <td id="f149" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">&bull;</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">&bull;</td>
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>150;</td>
                        <td id="f150" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">&ndash;</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">&ndash;</td>
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>151;</td>
                        <td id="f151" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">&mdash;</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">&mdash;</td>
                    </tr>
                    <tr style="height: 30px">
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>152;</td>
                        <td id="f152" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">&tilde;</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">&tilde;</td>
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>153;</td>
                        <td id="f153" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">&trade;</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">&trade;</td>
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>154;</td>
                        <td id="f154" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">&scaron;</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">&scaron;</td>
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>155;</td>
                        <td id="f155" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">&rsaquo;</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">&rsaquo;</td>
                    </tr>
                    <tr style="height: 30px">
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>156;</td>
                        <td id="f156" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">&oelig;</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">&oelig;</td>
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>157;</td>
                        <td id="f157" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px"></td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px"></td>
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>158;</td>
                        <td id="f158" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">ž</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">ž</td>
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>159;</td>
                        <td id="f159" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">&Yuml;</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">&Yuml;</td>
                    </tr>
                    <tr style="height: 30px">
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>160;</td>
                        <td id="f160" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">&nbsp;</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">&nbsp;</td>
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>161;</td>
                        <td id="f161" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">&iexcl;</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">&iexcl;</td>
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>162;</td>
                        <td id="f162" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">&cent;</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">&cent;</td>
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>163;</td>
                        <td id="f163" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">&pound;</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">&pound;</td>
                    </tr>
                    <tr style="height: 30px">
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>164;</td>
                        <td id="f164" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">&curren;</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">&curren;</td>
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>165;</td>
                        <td id="f165" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">&yen;</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">&yen;</td>
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>166;</td>
                        <td id="f166" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">&brvbar;</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">&brvbar;</td>
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>167;</td>
                        <td id="f167" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">&sect;</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">&sect;</td>
                    </tr>
                    <tr style="height: 30px">
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>168;</td>
                        <td id="f168" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">&uml;</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">&uml;</td>
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>169;</td>
                        <td id="f169" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">&copy;</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">&copy;</td>
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>170;</td>
                        <td id="f170" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">&ordf;</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">&ordf;</td>
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>171;</td>
                        <td id="f171" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">&laquo;</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">&laquo;</td>
                    </tr>
                    <tr style="height: 30px">
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>172;</td>
                        <td id="f172" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">&not;</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">&not;</td>
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>173;</td>
                        <td id="f173" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">&shy;</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">&shy;</td>
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>174;</td>
                        <td id="f174" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">&reg;</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">&reg;</td>
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>175;</td>
                        <td id="f175" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">&macr;</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">&macr;</td>
                    </tr>
                    <tr style="height: 30px">
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>176;</td>
                        <td id="f176" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">&deg;</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">&deg;</td>
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>177;</td>
                        <td id="f177" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">&plusmn;</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">&plusmn;</td>
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>178;</td>
                        <td id="f178" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">&sup2;</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">&sup2;</td>
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>179;</td>
                        <td id="f179" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">&sup3;</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">&sup3;</td>
                    </tr>
                    <tr style="height: 30px">
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>180;</td>
                        <td id="f180" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">&acute;</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">&acute;</td>
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>181;</td>
                        <td id="f181" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">&micro;</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">&micro;</td>
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>182;</td>
                        <td id="f182" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">&para;</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">&para;</td>
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>183;</td>
                        <td id="f183" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">&middot;</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">&middot;</td>
                    </tr>
                    <tr style="height: 30px">
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>184;</td>
                        <td id="f184" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">&cedil;</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">&cedil;</td>
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>185;</td>
                        <td id="f185" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">&sup1;</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">&sup1;</td>
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>186;</td>
                        <td id="f186" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">&ordm;</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">&ordm;</td>
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>187;</td>
                        <td id="f187" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">&raquo;</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">&raquo;</td>
                    </tr>
                    <tr style="height: 30px">
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>188;</td>
                        <td id="f188" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">&frac14;</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">&frac14;</td>
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>189;</td>
                        <td id="f189" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">&frac12;</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">&frac12;</td>
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>190;</td>
                        <td id="f190" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">&frac34;</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">&frac34;</td>
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>191;</td>
                        <td id="f191" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">&iquest;</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">&iquest;</td>
                    </tr>
                    <tr style="height: 30px">
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>192;</td>
                        <td id="f192" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">&Agrave;</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">&Agrave;</td>
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>193;</td>
                        <td id="f193" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">&Aacute;</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">&Aacute;</td>
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>194;</td>
                        <td id="f194" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">&Acirc;</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">&Acirc;</td>
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>195;</td>
                        <td id="f195" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">&Atilde;</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">&Atilde;</td>
                    </tr>
                    <tr style="height: 30px">
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>196;</td>
                        <td id="f196" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">&Auml;</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">&Auml;</td>
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>197;</td>
                        <td id="f197" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">&Aring;</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">&Aring;</td>
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>198;</td>
                        <td id="f198" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">&AElig;</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">&AElig;</td>
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>199;</td>
                        <td id="f199" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">&Ccedil;</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">&Ccedil;</td>
                    </tr>
                    <tr style="height: 30px">
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>200;</td>
                        <td id="f200" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">&Egrave;</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">&Egrave;</td>
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>201;</td>
                        <td id="f201" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">&Eacute;</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">&Eacute;</td>
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>202;</td>
                        <td id="f202" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">&Ecirc;</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">&Ecirc;</td>
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>203;</td>
                        <td id="f203" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">&Euml;</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">&Euml;</td>
                    </tr>
                    <tr style="height: 30px">
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>204;</td>
                        <td id="f204" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">&Igrave;</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">&Igrave;</td>
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>205;</td>
                        <td id="f205" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">&Iacute;</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">&Iacute;</td>
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>206;</td>
                        <td id="f206" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">&Icirc;</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">&Icirc;</td>
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>207;</td>
                        <td id="f207" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">&Iuml;</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">&Iuml;</td>
                    </tr>
                    <tr style="height: 30px">
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>208;</td>
                        <td id="f208" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">&ETH;</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">&ETH;</td>
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>209;</td>
                        <td id="f209" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">&Ntilde;</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">&Ntilde;</td>
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>210;</td>
                        <td id="f210" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">&Ograve;</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">&Ograve;</td>
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>211;</td>
                        <td id="f211" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">&Oacute;</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">&Oacute;</td>
                    </tr>
                    <tr style="height: 30px">
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>212;</td>
                        <td id="f212" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">&Ocirc;</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">&Ocirc;</td>
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>213;</td>
                        <td id="f213" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">&Otilde;</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">&Otilde;</td>
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>214;</td>
                        <td id="f214" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">&Ouml;</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">&Ouml;</td>
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>215;</td>
                        <td id="f215" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">&times;</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">&times;</td>
                    </tr>
                    <tr style="height: 30px">
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>216;</td>
                        <td id="f216" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">&Oslash;</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">&Oslash;</td>
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>217;</td>
                        <td id="f217" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">&Ugrave;</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">&Ugrave;</td>
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>218;</td>
                        <td id="f218" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">&Uacute;</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">&Uacute;</td>
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>219;</td>
                        <td id="f219" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">&Ucirc;</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">&Ucirc;</td>
                    </tr>
                    <tr style="height: 30px">
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>220;</td>
                        <td id="f220" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">&Uuml;</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">&Uuml;</td>
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>221;</td>
                        <td id="f221" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">&Yacute;</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">&Yacute;</td>
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>222;</td>
                        <td id="f222" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">&THORN;</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">&THORN;</td>
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>223;</td>
                        <td id="f223" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">&szlig;</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">&szlig;</td>
                    </tr>
                    <tr style="height: 30px">
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>224;</td>
                        <td id="f224" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">&agrave;</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">&agrave;</td>
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>225;</td>
                        <td id="f225" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">&aacute;</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">&aacute;</td>
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>226;</td>
                        <td id="f226" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">&acirc;</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">&acirc;</td>
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>227;</td>
                        <td id="f227" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">&atilde;</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">&atilde;</td>
                    </tr>
                    <tr style="height: 30px">
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>228;</td>
                        <td id="f228" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">&auml;</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">&auml;</td>
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>229;</td>
                        <td id="f229" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">&aring;</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">&aring;</td>
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>230;</td>
                        <td id="f230" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">&aelig;</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">&aelig;</td>
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>231;</td>
                        <td id="f231" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">&ccedil;</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">&ccedil;</td>
                    </tr>
                    <tr style="height: 30px">
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>232;</td>
                        <td id="f232" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">&egrave;</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">&egrave;</td>
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>233;</td>
                        <td id="f233" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">&eacute;</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">&eacute;</td>
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>234;</td>
                        <td id="f234" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">&ecirc;</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">&ecirc;</td>
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>235;</td>
                        <td id="f235" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">&euml;</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">&euml;</td>
                    </tr>
                    <tr style="height: 30px">
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>236;</td>
                        <td id="f236" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">&igrave;</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">&igrave;</td>
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>237;</td>
                        <td id="f237" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">&iacute;</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">&iacute;</td>
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>238;</td>
                        <td id="f238" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">&icirc;</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">&icirc;</td>
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>239;</td>
                        <td id="f239" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">&iuml;</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">&iuml;</td>
                    </tr>
                    <tr style="height: 30px">
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>240;</td>
                        <td id="f240" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">&eth;</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">&eth;</td>
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>241;</td>
                        <td id="f241" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">&ntilde;</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">&ntilde;</td>
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>242;</td>
                        <td id="f242" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">&ograve;</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">&ograve;</td>
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>243;</td>
                        <td id="f243" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">&oacute;</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">&oacute;</td>
                    </tr>
                    <tr style="height: 30px">
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>244;</td>
                        <td id="f244" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">&ocirc;</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">&ocirc;</td>
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>245;</td>
                        <td id="f245" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">&otilde;</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">&otilde;</td>
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>246;</td>
                        <td id="f246" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">&ouml;</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">&ouml;</td>
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>247;</td>
                        <td id="f247" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">&divide;</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">&divide;</td>
                    </tr>
                    <tr style="height: 30px">
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>248;</td>
                        <td id="f248" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">&oslash;</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">&oslash;</td>
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>249;</td>
                        <td id="f249" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">&ugrave;</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">&ugrave;</td>
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>250;</td>
                        <td id="f250" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">&uacute;</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">&uacute;</td>
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>251;</td>
                        <td id="f251" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">&ucirc;</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">&ucirc;</td>
                    </tr>
                    <tr style="height: 30px">
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>252;</td>
                        <td id="f252" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">&uuml;</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">&uuml;</td>
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>253;</td>
                        <td id="f253" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">&yacute;</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">&yacute;</td>
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>254;</td>
                        <td id="f254" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">&thorn;</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">&thorn;</td>
                        <td bgcolor="menu" valign="middle" width="7%" align="center" style="font-family: fixedsys; color: blue"><a>&amp;#</a>255;</td>
                        <td id="f255" valign="middle" width="11%" align="center" style="font-family: Webdings; color: #800080; font-size: 40px">&yuml;</td>
                        <td valign="middle" width="7%" align="center" style="font-family: Arial; color: #008080; font-size: 30px">&yuml;</td>
                    </tr>
                </tbody>
            </table>
            </p>
            <br />
            </font></td>
        </tr>
    </tbody>
</table>]]></summary>
	  <link rel="alternate" type="text/html" href="http://www.yacosoft.com/article.asp?id=37" /> 
	  <id>http://www.yacosoft.com/default.asp?id=37</id>
  </entry>	
		
  <entry>
	  <title type="html"><![CDATA[AutoVue 升级到 19.3.4 下载 ]]></title>
	  <author>
		 <name>卿卿</name>
		 <uri>http://www.yacosoft.com/</uri>
		 <email>zyq_17@qq.com</email>
	  </author>
	  <category term="" scheme="http://www.yacosoft.com/default.asp?cateID=7" label="编程工具" /> 
	  <updated>2009-08-17T09:31:53+08:00</updated>
	  <published>2009-08-17T09:31:53+08:00</published>
		  <summary type="html"><![CDATA[<div class="csc-header csc-header-n1">
<h2>AutoVue Testversion（先下载测试版本）</h2>
</div>
<!--  Header: [end] --><!--  Text: [begin] -->
<p class="bodytext">AutoVue&nbsp;<strong>19.3.1 Testversion:</strong> <a target="blank" href="http://dc.conexio-web.de/downloads/AutoVue/avde193.zip">avde193.zip</a> (114.078.611 B) 21.10.2008<br />
AutoVue Electro-Mechanical Professional Desktop Edition<br />
Windows 2000/XP/2003/Vista</p>
<p class="bodytext">&nbsp;</p>
<h2>AutoVue Update（安装升级程序）</h2>
<p class="bodytext"><strong>Apply this update on the Testversion, to try out the newest AutoVue Version.</strong></p>
<p class="bodytext">AutoVue <strong>19.3.4 Update:</strong> <a target="blank" href="http://dc.conexio-web.de/downloads/AutoVue/AutoVueUpdate1934.exe">AutoVueUpdate1934.exe</a> (27.715.538 B) 9.6.2009</p>]]></summary>
	  <link rel="alternate" type="text/html" href="http://www.yacosoft.com/article.asp?id=26" /> 
	  <id>http://www.yacosoft.com/default.asp?id=26</id>
  </entry>	
		
  <entry>
	  <title type="html"><![CDATA[ADO.NET Entity Framework 深入分析, Part 5]]></title>
	  <author>
		 <name>卿卿</name>
		 <uri>http://www.yacosoft.com/</uri>
		 <email>zyq_17@qq.com</email>
	  </author>
	  <category term="" scheme="http://www.yacosoft.com/default.asp?cateID=14" label="软件技术" /> 
	  <updated>2009-04-14T09:54:08+08:00</updated>
	  <published>2009-04-14T09:54:08+08:00</published>
		  <summary type="html"><![CDATA[<div>
<div>
<p>前面的Part 1-4的文章，介绍了Entity Data Model、Entity SQL、ObjectQuery、EntityCommand、LINQ to Entities等等及其代码演示。Part 4主要演示如何通过相关技术或Debug工具，如SQL Server Profiler、ToTraceString 方法、eSqlBlast 工具、LINQPad工具等等，来查看生成的T-SQL脚本。本篇文章Part 5 演示如何新增、更新和删除数据实体，并相应更新数据库。</p>
<p>ADO.NET Entity Framework 系列文章由EntLib.com 开源论坛、小组翻译、编写。欢迎交流、分享。</p>
</div>
<div>
<p>本系列文章前面部分链接：</p>
</div>
<div><a class="tab_content_a" target="_blank" href="http://www.yacosoft.com/article.asp?id=20">Entity Data Model (EDM) 深入分析, Part 1</a></div>
<div>&nbsp;</div>
<div><a class="tab_content_a" target="_blank" href="http://www.yacosoft.com/article.asp?id=21">Entity Data Model (EDM) 深入分析, Part 2</a></div>
<div>&nbsp;</div>
<div><a class="tab_content_a" target="_blank" href="http://www.yacosoft.com/article.asp?id=22">Entity Data Model (EDM) 深入分析, Part 3</a></div>
<div>&nbsp;</div>
<div><a class="tab_content_a" target="_blank" href="http://www.yacosoft.com/article.asp?id=23">ADO.NET Entity Framework 深入分析, Part 4</a></div>
<div>
<p><b>增加、更新和删除实体</b></p>
</div>
<div>
<p>将实体的更新操作应用到数据库很方便。对象服务（Object Services）将记录所有对实体对象的改变，并产生和执行相应的T-SQL语句，对数据库实施插入、更新和删除操作。</p>
</div>
<div>
<p>通过调用ObjectContext的SaveChanges() 方法，来实现对数据库的更新，这与LINQ to SQL 的DataContext的SubmitChanges() 方法比较相似。</p>
</div>
<div>
<p><b>更新或修改实体</b></p>
</div>
<div>NorthwindEntities context = new NorthwindEntities();</div>
<div>&nbsp;</div>
<div>Employee firstEmployee = context.Employees.First(e =&gt; e.EmployeeID == 1);</div>
<div>&nbsp;</div>
<div>if (firstEmployee != null)</div>
<div>{</div>
<div>&nbsp;firstEmployee.City = &quot;San Francisco&quot;;</div>
<div>&nbsp;firstEmployee.Notes = &quot;New notes for employee 1&quot;;</div>
<div>&nbsp;int affected = context.SaveChanges();</div>
<div>}</div>
<div>
<p>1) 检索一个Employee</p>
<p>LINQ to Entities 中，你可以使用扩展方法First()，因为SingleOrDefault() 方法将抛出NotSupportedException 异常（The 'Single' operator is not supported by LINQ to Entities. Consider using 'First' instead）。</p>
<p>2) 改变实体的一些属性</p>
<p>3) 调用ObjectContext 的SaveChanges() 方法，该方法将返回增加、修改或删除的实体对象的数量。</p>
</div>
<div>
<p><b>增加一个实体对象</b></p>
</div>
<div>Employee newEmployee = new Employee();</div>
<div>newEmployee.FirstName = &quot;Jan&quot;;</div>
<div>newEmployee.LastName = &quot;Jansen&quot;;</div>
<div>&nbsp;</div>
<div>context.AddToEmployees(newEmployee);</div>
<div>&nbsp;</div>
<div>context.SaveChanges();</div>
<div>
<p>1) 创建一个新的Employee 对象，并设置属性。</p>
<p>创建实体类之后，每一个生成的类都有一个静态的创建工厂方法。因此，你也可以使用CreateEmployee() 方法实例化一个Employee 对象和非空的属性。</p>
</div>
<div>
<p>如果细心一点，你将注意到EmployeeID 也是一个必须的字段。当然，这不是完全真实的，因为这是一个自增长的字段，由SQL Server 数据库来填充。在LINQ to SQL中，每一个属性成员有Auto Generated选项。Entity Framework 则没有这些，可能是因为它设计用来支持所有的数据库，可能一些数据库不支持AutoIncrement 数据类型，因此仅仅传递一个虚值。</p>
</div>
<div>Employee newEmployee = Employee.CreateEmployee(0, &quot;Jansen&quot;, &quot;Jan&quot;);</div>
<div>
<p>2) 调用ObjectContext对象的AddToEmployees() 方法。这与LINQ to SQL不一样，LINQ to SQL使用 Employees集合的InsertOnSubmit() 方法。在Entity Framework中，每一个EntityType自动生成指定的AddTo 方法。</p>
<p>你也可以使用对象上下文(Object Context) 的AddObject() 方法，第一个参数是Entity Set的名称，我个人喜好使用AddTo 方法。</p>
</div>
<div>context.AddObject(&quot;Employees&quot;, newEmployee);</div>
<div>
<p>3) 调用Object Context 的SaveChanges() 方法。</p>
</div>
<div>
<p><b>增加实体及其关联实体</b></p>
</div>
<div>Category newCategory = new Category();</div>
<div>newCategory.CategoryName = &quot;Software&quot;;</div>
<div>newCategory.Description = &quot;Software products&quot;;</div>
<div>&nbsp;</div>
<div>newCategory.Products.Add(new Product() { ProductName = &quot;Microsoft Visual Studio 2008&quot; });</div>
<div>newCategory.Products.Add(new Product() { ProductName = &quot;Microsoft Office 2007&quot; });</div>
<div>&nbsp;</div>
<div>context.AddToCategories(newCategory);</div>
<div>&nbsp;</div>
<div>context.SaveChanges();</div>
<div>&nbsp;</div>
<div>1) 创建一个新的Category 对象并设置属性。</div>
<div>2) 当你创建的实体通过Navigation 属性关联到另一个实体时，你可以调用集合Add() 方法。创建2个新的Product对象，并添加这2个对象到Category的Products集合。</div>
<div>3) 调用Object Context的AddToCategories() 方法。</div>
<div>4) 调用Object Context 的SaveChanges() 方法。</div>
<div>将执行如下3条T-SQL脚本：</div>
<div>exec sp_executesql N'insert [dbo].[Categories]([CategoryName], [Description], [Picture])</div>
<div>values (@0, @1, null)</div>
<div>select [CategoryID]</div>
<div>from [dbo].[Categories]</div>
<div>where @@ROWCOUNT &gt; 0 and [CategoryID] = scope_identity()',N'@0 nvarchar(8),@1 nvarchar(17)',@0=N'Software',@1=N'Software products'</div>
<div>&nbsp;</div>
<div>exec sp_executesql N'insert [dbo].[Products]([ProductName], [SupplierID], [CategoryID], [QuantityPerUnit], [UnitPrice],</div>
<div>&nbsp;[UnitsInStock], [UnitsOnOrder], [ReorderLevel], [Discontinued])</div>
<div>values (@0, null, @1, null, null, null, null, null, @2)</div>
<div>select [ProductID]</div>
<div>from [dbo].[Products]</div>
<div>where @@ROWCOUNT &gt; 0 and [ProductID] = scope_identity()',N'@0 nvarchar(28),@1 int,@2 bit',@0=N'Microsoft Visual Studio 2008',@1=12,@2=0</div>
<div>&nbsp;</div>
<div>exec sp_executesql N'insert [dbo].[Products]([ProductName], [SupplierID], [CategoryID], [QuantityPerUnit], [UnitPrice],</div>
<div>&nbsp;[UnitsInStock], [UnitsOnOrder], [ReorderLevel], [Discontinued])</div>
<div>values (@0, null, @1, null, null, null, null, null, @2)</div>
<div>select [ProductID]</div>
<div>from [dbo].[Products]</div>
<div>where @@ROWCOUNT &gt; 0 and [ProductID] = scope_identity()',N'@0 nvarchar(21),@1 int,@2 bit',@0=N'Microsoft Office 2007',@1=12,@2=0</div>
<div>
<p><b>删除一个实体对象</b></p>
</div>
<div>Category cat = context.Categories.First(c =&gt; c.CategoryName == &quot;Software&quot;);</div>
<div>context.DeleteObject(cat);</div>
<div>context.SaveChanges();</div>
<div>&nbsp;</div>
<div>1) 检索一个Category 对象。</div>
<div>2) 调用Object Context 的DeleteObject() 的方法，并传入Category 对象。编写一个重载的方法，仅需要一个EntityKey，这也是可行的。</div>
<div>3) 调用Object Context 的SaveChanges() 方法。</div>
<div>
<p>在默认的Northwind 数据库，上述示例将抛出一个异常：&quot;The Delete statement conflicted with the REFERENCE constraint &quot;FK_Products_Categories&quot;. The conflict occurred in database &quot;Northwind&quot;, table &quot;dbo.Products&quot;, column &quot;CategoryID&quot;. The statement has been terminated.&quot;</p>
<p>如果你想删除Software目录和它的产品，你需要修改SQL Server数据库中FK_Products_Categories 外键的Delete Rule，并设置为Cascade。</p>
<p><img alt="" src="http://www.uml.org.cn/net/images/EDM_Analysis5_1.gif" width="665" height="419" />&nbsp;</p>
</div>
</div>
<p>&nbsp;</p>]]></summary>
	  <link rel="alternate" type="text/html" href="http://www.yacosoft.com/article.asp?id=24" /> 
	  <id>http://www.yacosoft.com/default.asp?id=24</id>
  </entry>	
		
  <entry>
	  <title type="html"><![CDATA[ADO.NET Entity Framework 深入分析, Part 4]]></title>
	  <author>
		 <name>卿卿</name>
		 <uri>http://www.yacosoft.com/</uri>
		 <email>zyq_17@qq.com</email>
	  </author>
	  <category term="" scheme="http://www.yacosoft.com/default.asp?cateID=14" label="软件技术" /> 
	  <updated>2009-04-14T09:52:17+08:00</updated>
	  <published>2009-04-14T09:52:17+08:00</published>
		  <summary type="html"><![CDATA[<div>
<div>
<p>前面的Part 1-3的文章，介绍了Entity Data Model、Entity SQL、ObjectQuery、EntityCommand、LINQ to Entities等等及其代码演示。这篇文章主要演示如何通过相关技术或Debug工具，如SQL Server Profiler、ToTraceString 方法、eSqlBlast 工具、LINQPad工具等等，来查看生成的T-SQL脚本。</p>
</div>
<div>
<p>本系列文章前面部分链接：</p>
</div>
<div><a id="AggRecentPosts1_RecentPosts_ctl00_Hyperlink3" class="tab_content_a" target="_blank" href="http://www.yacosoft.com/article.asp?id=20">Entity Data Model (EDM) 深入分析, Part 1</a></div>
<div><br />
<a id="AggRecentPosts1_RecentPosts_ctl00_Hyperlink4" class="tab_content_a" target="_blank" href="http://www.yacosoft.com/article.asp?id=21">Entity Data Model (EDM) 深入分析, Part 2</a></div>
<div>&nbsp;</div>
<div><a class="tab_content_a" title="Title of this entry." target="_blank" href="http://www.yacosoft.com/article.asp?id=22">Entity Data Model (EDM) 深入分析, Part 3</a></div>
<div>
<p>Entity Data Model 是一个概念模型，所有Entity SQL和LINQ to Entities 查询将最终转化为T-SQL的脚本，从数据库中查询数据。这里演示了几种方法来查看生成的T-SQL，有助于Debug或分析问题。</p>
<p><b>1. 使用SQL Server Profiler 工具</b></p>
<p>与LINQ to SQL比较而言，ObjectContext 类没有提供Log属性或者通用的log机制，因此，无法在Visual Studio 中跟踪所有的T-SQL语句。</p>
</div>
<div>
<p>如果你想查看所有执行的T-SQL语句，你需要使用SQL Server的Profiler 工具，关于具体如何使用SQL Server Profiler工具，请参考如下文章：</p>
</div>
<div><b>SQL Profiler: Features, functions and setup in SQL Server 2005</b></div>
<div><a class="content_a" href="http://blog.entlib.com/EntLib/archive/2008/10/27/sql-profiler-features-functions-and-setup-in-sql-server-2005.aspx" target="_blank">http://blog.entlib.com/EntLib/archive/2008/10/27/sql-profiler-features-functions-and-setup-in-sql-server-2005.aspx</a></div>
<div>
<p><b>2. ToTraceString 方法</b></p>
<p>另外一种方法去查看生成的T-SQL语句的方法，包括 EntityCommand和ObjectQuery类都有一个ToTraceString() 方法。在一些情况下，可以用来查看内部到底生成什么SQL脚本，而不必一定要使用SQL Server Profiler 工具。需要注意的是：ToTraceString() 方法实际上没有执行查询操作，仅仅是转化查询为SQL脚本。</p>
<p>通过增加一个断点，你可以轻松查看SQL脚本，需要记住的是：事先需要打开数据库连接，否则会抛出InvalidOperationException 异常（Execution of the command requires an open and available connection. The connection&rsquo;s current state is closed.）</p>
</div>
<div>
<p><b>（1）Entity SQL : EntityCommand.ToTraceString() 示例脚本</b></p>
</div>
<div align="left"><span style="font-size: 9pt">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <span style="color: blue">public</span> <span style="color: #2b91af">IList</span>&lt;<span style="color: #2b91af">Category</span>&gt; GetParentCategory()</span></div>
<div align="left"><span style="font-size: 9pt">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; {</span></div>
<div align="left"><span style="font-size: 9pt">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <span style="color: #2b91af">IList</span>&lt;<span style="color: #2b91af">Category</span>&gt; result = <span style="color: blue">null</span>;</span></div>
<div align="left"><span style="font-size: 9pt">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <span style="color: #2b91af">EntityDataReader</span> rdr;</span></div>
<div align="left"><span style="font-size: 9pt">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <span style="color: #2b91af">EntityCommand</span> cmd;</span></div>
<div align="left"><span style="font-size: 9pt">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <span style="color: blue">string</span> esqlQuery;</span></div>
<div align="left">&nbsp;</div>
<div align="left"><span style="font-size: 9pt">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <span style="color: blue">using</span> (<span style="color: #2b91af">EntityConnection</span> conn = <span style="color: blue">new</span> <span style="color: #2b91af">EntityConnection</span>(<span style="color: #a31515">&quot;name=AdventureWorksLTEntities&quot;</span>))</span></div>
<div align="left"><span style="font-size: 9pt">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; {</span></div>
<div align="left"><span style="font-size: 9pt">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; conn.Open();</span></div>
<div align="left"><span style="font-size: 9pt">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; esqlQuery = <span style="color: #a31515">@&quot;Select VALUE c from AdventureWorksLTEntities.Category AS c </span></span></div>
<div align="left"><span style="color: #a31515; font-size: 9pt">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Where c.ParentCategory is null &quot;</span><span style="font-size: 9pt">;</span></div>
<div align="left"><span style="font-size: 9pt">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; result = <span style="color: blue">new</span> <span style="color: #2b91af">List</span>&lt;<span style="color: #2b91af">Category</span>&gt;();</span></div>
<div align="left">&nbsp;</div>
<div align="left"><span style="font-size: 9pt">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; cmd = conn.CreateCommand();</span></div>
<div align="left"><span style="font-size: 9pt">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; cmd.CommandText = esqlQuery;</span></div>
<div align="left">&nbsp;</div>
<div align="left"><b><span style="font-size: 9pt">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <span style="color: #2b91af">Console</span>.WriteLine(cmd.CommandText);</span></b></div>
<div align="left"><b><span style="font-size: 9pt">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;<span style="color: #2b91af">Console</span>.WriteLine(cmd.ToTraceString());</span></b></div>
<div align="left">&nbsp;</div>
<div align="left"><span style="font-size: 9pt">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; rdr = cmd.ExecuteReader(<span style="color: #2b91af">CommandBehavior</span>.SequentialAccess);</span></div>
<div align="left">&nbsp;</div>
<div align="left"><span style="font-size: 9pt">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <span style="color: blue">while</span> (rdr.Read())</span></div>
<div align="left"><span style="font-size: 9pt">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; {</span></div>
<div align="left"><span style="font-size: 9pt">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; result.Add(<span style="color: blue">this</span>.productGateway.MaterializeCategory(rdr));</span></div>
<div align="left"><span style="font-size: 9pt">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; }</span></div>
<div align="left">&nbsp;</div>
<div align="left"><span style="font-size: 9pt">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; conn.Close();</span></div>
<div align="left"><span style="font-size: 9pt">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; }</span></div>
<div align="left">&nbsp;</div>
<div align="left"><span style="font-size: 9pt">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <span style="color: blue">return</span> result;</span></div>
<div><span style="font-size: 9pt">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; }</span></div>
<div>
<p>示例界面如下：</p>
<p><img alt="" src="http://www.uml.org.cn/net/images/EDM_Analysis4_1.gif" width="719" height="514" /></p>
</div>
<div>
<p><b>（2）Entity SQL : ObjectQuery.ToTraceString() 示例脚本如下：</b></p>
</div>
<div>NorthwindEntities context = new NorthwindEntities();</div>
<div>&nbsp;</div>
<div>var sql = &quot;Select VALUE emp FROM NorthwindEntities.Employees AS emp &quot; +</div>
<div>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &quot;Where emp.Country = @country&quot;;</div>
<div><b>var query = context.CreateQuery&lt;Employee&gt;(sql);</b></div>
<div>query.Parameters.Add(new ObjectParameter(&quot;country&quot;, &quot;USA&quot;));</div>
<div>&nbsp;</div>
<div>if (context.Connection.State != ConnectionState.Open)</div>
<div>&nbsp;context.Connection.Open();</div>
<div>&nbsp;</div>
<div><b>Console.WriteLine(query.ToTraceString());</b></div>
<div>
<p><b>（3）LINQ to Entities : (query as ObjectQuery).ToTraceString() 示例脚本</b></p>
</div>
<div>
<p>需要使用类型转换，将LINQ to Entities (IQueryable) 查询转化为ObjectQuery，这样就可以调用ToTraceString() 方法了。</p>
</div>
<div>NorthwindEntities context = new NorthwindEntities();</div>
<div>&nbsp;</div>
<div>string country = &quot;USA&quot;;</div>
<div>var query = from e in context.Employees</div>
<div>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; where e.Country == country</div>
<div>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; select e;</div>
<div>&nbsp;</div>
<div>if (context.Connection.State != ConnectionState.Open)</div>
<div>&nbsp;context.Connection.Open();</div>
<div><b>Console.WriteLine((query as ObjectQuery&lt;Employee&gt;).ToTraceString());</b></div>
<div>
<p>也可以通过反射（Reflection）和Invoke() 方法，得到相同的结果：</p>
</div>
<div>Console.WriteLine(query.GetType().GetMethod(&quot;ToTraceString&quot;).Invoke(query, null));</div>
<div>
<p><b>3. 使用eSqlBlast 工具</b></p>
<p>微软也提供了一个免费的工具来帮助学习Entity SQL。</p>
</div>
<div>
<p>eSqlBlast 的下载地址（含有源代码，需要自己编译一下）及其相关介绍（eSqlBlast for VS 2008 SP1）：</p>
</div>
<div><a href="http://code.msdn.microsoft.com/esql/Release/ProjectReleases.aspx?ReleaseId=991"><font color="#800080">http://code.msdn.microsoft.com/esql/Release/ProjectReleases.aspx?ReleaseId=991</font></a></div>
<div>
<p>如果懒得编译，可以直接在本文章底部点击下载链接，下载已经编译好的可执行文件。</p>
</div>
<div>
<p>运行界面如下：</p>
<p><img alt="" src="http://www.uml.org.cn/net/images/EDM_Analysis4_2.gif" width="724" height="547" /></p>
</div>
<div>
<p>Connection 页面用来指定3个元数据文件（CSDL/SSDL/MSL）和数据库连接字符串。数据库连接字符串可以直接从App.config 复制过来。点击Connect 按钮进行连接。</p>
<p>Model 页面用来显示所有的EntitySets和EntityTypes。</p>
<p><img alt="" src="http://www.uml.org.cn/net/images/EDM_Analysis4_3.gif" width="724" height="547" /></p>
</div>
<div>
<p>Query 页面可以输入 Entity SQL脚本，你会注意到eSqlBlast 支持智能提示（IntelliSense），酷吧！！！目前，Visual Studio 2008 sp1 尚不支持Entity SQL 的职能提示呢。</p>
<p><img alt="" src="http://www.uml.org.cn/net/images/EDM_Analysis4_4.gif" width="724" height="547" /></p>
</div>
<div>
<p>点击Execute 执行按钮，执行结果将以HTML的格式显示在Results 页面，如下图所示。包括4个部分：Enttiy Command (也就是CommandText 属性值)、Store Command（生成的T-SQL脚本，也就是ToTraceString() 方法产生的脚本）、Record Count（结果集的记录数）、Data（实际记录结果）。</p>
<p><img alt="" src="http://www.uml.org.cn/net/images/EDM_Analysis4_5.gif" width="724" height="547" /></p>
</div>
<div>
<p><b>4. 使用免费LINQPad 工具</b></p>
</div>
<div>
<p>LINQPad 是一个优秀的LINQ 表达式测试工具，原本设计用来执行LINQ to Objects 和LINQ to SQL查询，但是也可以用来执行LINQ to Entities 查询。</p>
<p>如下图所示，执行LINQ to SQL查询，并调用扩展方法Dump() 输出结果。</p>
<p><img alt="" src="http://www.uml.org.cn/net/images/EDM_Analysis4_6.gif" width="699" height="489" /></p>
</div>
<div style="text-indent: -21pt; margin: 0cm 0cm 0pt 21pt">&nbsp; LINQPad 免费工具可以到如下地址下载：</div>
<div><a href="http://www.linqpad.net/"><font color="#800080">http://www.linqpad.net/</font></a></div>
<p class="enclosure"><img id="viewpost_ascx_imgEnclosure" src="http://www.uml.org.cn/net/images/download.gif" style="border-right-width: 0px; border-top-width: 0px; border-bottom-width: 0px; border-left-width: 0px" alt="" />&nbsp;<span id="viewpost_ascx_Enclosure" displaysize="True">点击下载 <a class="tab_content_a" title="示例程序 AdventureWorks_EntityFrameworkDemo_v2" href="http://www.uml.org.cn/net/AdventureWorks_EntityFrameworkDemo_v2.zip" target="_blank">示例程序 AdventureWorks_EntityFrameworkDemo_v2</a> (356 KB)</span></p>
</div>]]></summary>
	  <link rel="alternate" type="text/html" href="http://www.yacosoft.com/article.asp?id=23" /> 
	  <id>http://www.yacosoft.com/default.asp?id=23</id>
  </entry>	
		
  <entry>
	  <title type="html"><![CDATA[Entity Data Model (EDM) 深入分析, Part 3]]></title>
	  <author>
		 <name>卿卿</name>
		 <uri>http://www.yacosoft.com/</uri>
		 <email>zyq_17@qq.com</email>
	  </author>
	  <category term="" scheme="http://www.yacosoft.com/default.asp?cateID=14" label="软件技术" /> 
	  <updated>2009-04-14T09:48:59+08:00</updated>
	  <published>2009-04-14T09:48:59+08:00</published>
		  <summary type="html"><![CDATA[<div>
<div>
<p><b>EntityClient</b></p>
<p>实体框架（Entity Framework）在ADO.NET 3.5 提供程序的基础上引入新的 ADO.NET 提供程序 EntityClient。Entity&shy;Client 看上去与之前使用的 ADO.NET 提供程序非常类似，它将提供第一个抽象，可允许开发人员使用标准的 Connection、Command 和 DataReader 对象依照 EDM 执行查询。它还会将映射域模型所需的客户端视图引擎（根据 EDM 定义的）添加到底层关系数据库架构。必要时，EntityClient 可借助 ESQL 查询字符串让开发人员以行和列的形式处理实体，而不必生成类来表示概念架构。</p>
<p>本系列文章上一篇：<br />
<a target="_blank" href="http://www.yacosoft.com/article.asp?id=20">Entity Data Model (EDM) 深入分析, Part 1</a></p>
<p><br />
<a target="_blank" href="http://www.yacosoft.com/article.asp?id=21">Entity Data Model (EDM) 深入分析, Part 2</a></p>
</div>
<div>
<p><b>1. EntityCommand 查询返回实体类型</b></p>
<p>Entity SQL也可以通过EntityClient 来执行，尽管代码比较啰嗦，但是在某些情况下，也是优点。</p>
<p>1) 首先创建EntityConnection，重用Northwind data context 的连接字符串，并打开连接。</p>
<p>2) 创建 EntityCommand 对象，并传入Entity SQL语句和数据库连接对象。</p>
<p>3) 创建DbDataReader对象，并循环读取返回的结果集。</p>
</div>
<div>NorthwindEntities context = new NorthwindEntities();</div>
<div>&nbsp;</div>
<div>EntityConnection conn = new EntityConnection(context.Connection.ConnectionString);</div>
<div>conn.Open();</div>
<div>&nbsp;</div>
<div>var sql = &quot;Select VALUE emp FROM NorthwindEntities.Employees AS emp&quot;;</div>
<div>EntityCommand cmd = new EntityCommand(sql, conn);</div>
<div>&nbsp;</div>
<div>DbDataReader reader = cmd.ExecuteReader(CommandBehavior.SequentialAccess);</div>
<div>while (reader.Read())</div>
<div>{</div>
<div>&nbsp;Console.WriteLine(&quot;{0} {1} {2} {3}&quot;, reader[&quot;EmployeeID&quot;], reader[&quot;LastName&quot;],</div>
<div>&nbsp;&nbsp;&nbsp; reader[&quot;FirstName&quot;], reader[&quot;Country&quot;]);</div>
<div>}</div>
<div>
<p>当时使用SequentialAccess的DbDataReader时，需要小心访问数据，务必有序的读取。</p>
</div>
<div>
<p>如你改变成员的顺序，将抛出InvalidOperationException 异常 - &quot;Attempt to read from column ordinal '0' is not valid. With CommandBehavior.SequentialAccess, you may only read from column ordinal '2' or greater.&quot;</p>
</div>
<div>&nbsp;</div>
<div>Console.WriteLine(&quot;{0} {1} {2} {3}&quot;, reader[&quot;LastName&quot;], reader[&quot;EmployeeID&quot;],</div>
<div>&nbsp;reader[&quot;FirstName&quot;], reader[&quot;Country&quot;]);</div>
<div>
<p><b>2. EntityCommand 查询返回匿名类型</b></p>
</div>
<div>
<p>采用相同的技术可以实现返回匿名类型。</p>
</div>
<div>EntityConnection conn = new EntityConnection(context.Connection.ConnectionString);</div>
<div>conn.Open();</div>
<div>&nbsp;</div>
<div>var sql = &quot;Select emp.LastName, emp.FirstName &quot; +</div>
<div>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &quot;FROM NorthwindEntities.Employees AS emp&quot;;</div>
<div>EntityCommand cmd = new EntityCommand(sql, conn);</div>
<div>&nbsp;</div>
<div>DbDataReader reader = cmd.ExecuteReader(CommandBehavior.SequentialAccess);</div>
<div>while (reader.Read())</div>
<div>{</div>
<div>&nbsp;Console.WriteLine(&quot;{0} {1}&quot;, reader[&quot;LastName&quot;], reader[&quot;FirstName&quot;]);</div>
<div>}</div>
<div>
<p><b>3. EntityCommand 带参数查询</b></p>
</div>
<div>
<p>EntityCommand 带参数也比较容易，在Entity SQL字符串中参数名称以@作为前缀，接着创建EntityParameter对象，并增加到EntityCommand 的Parameters集合内。</p>
</div>
<div>EntityConnection conn = new EntityConnection(context.Connection.ConnectionString);</div>
<div>conn.Open();</div>
<div>&nbsp;</div>
<div>var sql = &quot;Select VALUE emp FROM NorthwindEntities.Employees AS emp &quot; +</div>
<div>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &quot;Where emp.Country = @country&quot;;</div>
<div>EntityCommand cmd = new EntityCommand(sql, conn);</div>
<div>&nbsp;</div>
<div>EntityParameter param = new EntityParameter(&quot;country&quot;, DbType.String);</div>
<div>&nbsp;</div>
<div>param.Value = &quot;USA&quot;;</div>
<div>cmd.Parameters.Add(param);</div>
<div>&nbsp;</div>
<div>DbDataReader reader = cmd.ExecuteReader(CommandBehavior.SequentialAccess);</div>
<div>while (reader.Read())</div>
<div>{</div>
<div>&nbsp;Console.WriteLine(&quot;{0} {1} {2} {3}&quot;, reader[&quot;EmployeeID&quot;], reader[&quot;LastName&quot;],</div>
<div>&nbsp;&nbsp;&nbsp; reader[&quot;FirstName&quot;], reader[&quot;Country&quot;]);</div>
<div>}</div>
<div>&nbsp;</div>
<div>
<p><b>LINQ to Entities</b></p>
<p>LINQ是在.NET v3.5 引入的新技术。相对于前面的Entity SQL而言，我更偏爱LINQ to entities。LINQ查询虽然有一些局限，但是LINQ更容易、更自然，此外，还支持强类型，因此智能提示能帮助编写LINQ查询脚本。</p>
</div>
<div>&nbsp;LINQ to Entities 与LINQ to Objects和LINQ to SQL 基本一样，因此下面简单演示2个基本的LINQ to Entities的查询。</div>
<div>
<p><b>1. LINQ 带参数查询</b></p>
</div>
<div>NorthwindEntities context = new NorthwindEntities();</div>
<div>&nbsp;</div>
<div>string country = &quot;USA&quot;;</div>
<div>var query = from e in context.Employees</div>
<div>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; where e.Country == country</div>
<div>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; select e;</div>
<div>&nbsp;</div>
<div>foreach (var emp in query)</div>
<div>&nbsp;Console.WriteLine(&quot;{0} {1} {2} {3}&quot;, emp.EmployeeID, emp.FirstName, emp.LastName, emp.Country);</div>
<div>
<p><b>2. LINQ 查询返回匿名类型</b></p>
</div>
<div>NorthwindEntities context = new NorthwindEntities();</div>
<div>&nbsp;</div>
<div>var query = from e in context.Employees</div>
<div>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; select new { e.LastName, e.FirstName };</div>
<div>&nbsp;</div>
<div>foreach (var emp in query)</div>
<div>&nbsp;Console.WriteLine(&quot;{0} {1}&quot;, emp.LastName, emp.FirstName);</div>
<div>
<p>这篇文章对Entity Data Model 和Entity Framework 提供了各种查询技术进行了简单的介绍，希望对你有帮助。下一篇文章将介绍更高级的 Entity SQL 查询技术、查看SQL 语句、eager loading、变更跟踪、并发&hellip; 等等。</p>
</div>
</div>
<p>&nbsp;</p>]]></summary>
	  <link rel="alternate" type="text/html" href="http://www.yacosoft.com/article.asp?id=22" /> 
	  <id>http://www.yacosoft.com/default.asp?id=22</id>
  </entry>	
		
  <entry>
	  <title type="html"><![CDATA[Entity Data Model (EDM) 深入分析, Part 2]]></title>
	  <author>
		 <name>卿卿</name>
		 <uri>http://www.yacosoft.com/</uri>
		 <email>zyq_17@qq.com</email>
	  </author>
	  <category term="" scheme="http://www.yacosoft.com/default.asp?cateID=14" label="软件技术" /> 
	  <updated>2009-04-14T09:47:07+08:00</updated>
	  <published>2009-04-14T09:47:07+08:00</published>
		  <summary type="html"><![CDATA[<div>
<div>
<p>实体 SQL (Entity SQL)，它是一种新的 SQL 语言，其中加入了之前的 SQL 语言并不支持的基于概念的查询功能。ESQL 扩展现有 SQL 语言的方式与 EDM 扩展数据库中所使用的关系模型的方式十分类似。此外，ESQL 未绑定到任何特定于后台数据库的语法，因此可一次性编写查询（和/或应用程序），无论针对的是哪个后台数据库都无影响。</p>
<p>Entity SQL 是基于文本的、面向集合的、延后绑定的查询语言，也受到了T-SQL的影响。可以使用Entity SQL 创建对EDM的查询，Entity SQL 既可以通过Object Services components来执行，也可以通过Entity Client components 来执行。Entity SQL 设计的非常灵活，因此也变得有些复杂。本篇文章侧重于不同的查询技术，仅仅使用简单的查询，不包含复杂的条件、关联和聚合公式。</p>
<p>本系列文章上一篇：</p>
<p><a id="AggRecentPosts1_RecentPosts_ctl00_Hyperlink2" class="tab_content_a" target="_blank" href="http://www.yacosoft.com/article.asp?id=20">Entity Data Model (EDM) 深入分析, Part 1</a></p>
</div>
<div>
<p><b>1. 使用ObjectQuery&lt;T&gt; 查询返回实体类型（Entity Type）集合</b></p>
<p>下面演示如何执行Entity SQL 查询，返回实体类型的实例集合。</p>
<p>1) 首先创建Northwind ObjectContext 实例。</p>
<p>2) Entity SQL语句本身是字符串表达式，在大多数情况下，由Select-FROM 查询语句组成。在Select语句中使用VALUE关键字来表示返回的实体是一条数据行。</p>
<p>3) 使用Object Services components 执行查询。调用ObjectContext 的工厂方法CreateQuery&lt;T&gt;()，创建一个ObjectQuery 对象，该对象表示对存储数据源的查询，查询表达式为Entity SQL 语句。</p>
<p>4) Entity Framework实体框架采用延迟装载（Deferred loading）。因此只有在显式需要数据时，才真正执行SQL语句。在这种情况下，在ForEach第一次迭代时，才执行查询语句。</p>
</div>
<div>&nbsp;</div>
<div>NorthwindEntities context = new NorthwindEntities();</div>
<div>&nbsp;</div>
<div>var sql = &quot;Select VALUE emp FROM NorthwindEntities.Employees AS emp&quot;;</div>
<div>var query = context.CreateQuery&lt;Employee&gt;(sql);</div>
<div>&nbsp;</div>
<div>foreach (var emp in query)</div>
<div>&nbsp;Console.WriteLine(&quot;{0} {1} {2} {3}&quot;, emp.EmployeeID, emp.FirstName, emp.LastName, emp.Country);</div>
<div>&nbsp;</div>
<div>
<p>除了使用工厂方法CreateQuery&lt;T&gt;外，也可以直接创建ObjectQuery对象实例，并传入Object Context 参数，示例代码如下：</p>
</div>
<div>NorthwindEntities context = new NorthwindEntities();</div>
<div>&nbsp;</div>
<div>var sql = &quot;NorthwindEntities.Employees&quot;;</div>
<div>ObjectQuery&lt;Employee&gt; query = new ObjectQuery&lt;Employee&gt;(sql, context);</div>
<div>&nbsp;</div>
<div>foreach (var emp in query)</div>
<div>&nbsp;Console.WriteLine(&quot;{0} {1} {2} {3}&quot;, emp.EmployeeID, emp.FirstName, emp.LastName, emp.Country);</div>
<div>
<p>下面增加一个Where条件：</p>
</div>
<div>var sql = &quot;Select VALUE emp FROM NorthwindEntities.Employees AS emp &quot; +</div>
<div>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &quot;Where emp.Country = 'USA'&quot;;</div>
<div>var query = context.CreateQuery&lt;Employee&gt;(sql);</div>
<div>
<p><b>2. 带参数的ObjectQuery&lt;T&gt;查询</b></p>
</div>
<div>
<p>参数变量是在Entity SQL外定义的，在查询语句中需要以@符合作为前缀定义变量名。参数定义为ObjectParameter 对象，然后增加到ObjectQuery 实例中。</p>
</div>
<div>
<p>下面增加一个Country 变量：</p>
</div>
<div>var sql = &quot;Select VALUE emp FROM NorthwindEntities.Employees AS emp &quot; +</div>
<div>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &quot;Where emp.Country = @country&quot;;</div>
<div>var query = context.CreateQuery&lt;Employee&gt;(sql);</div>
<div>query.Parameters.Add(new ObjectParameter(&quot;country&quot;, &quot;USA&quot;));</div>
<div>&nbsp;</div>
<div>同样以ObjectQuery 示例对象实现这一功能：</div>
<div>var sql = &quot;Select VALUE emp FROM NorthwindEntities.Employees AS emp &quot; +</div>
<div>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &quot;Where emp.Country = @country&quot;;</div>
<div>ObjectQuery&lt;Employee&gt; query = new ObjectQuery&lt;Employee&gt;(sql, context);</div>
<div>query.Parameters.Add(new ObjectParameter(&quot;country&quot;, &quot;USA&quot;));</div>
<div>&nbsp;</div>
<div>ObjectParameter对象也可以直接传入CreateQuery&lt;T&gt;方法：</div>
<div>var sql = &quot;Select VALUE emp FROM NorthwindEntities.Employees AS emp &quot; +</div>
<div>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &quot;Where emp.Country = @country&quot;;</div>
<div>var query = context.CreateQuery&lt;Employee&gt;(sql, new ObjectParameter(&quot;country&quot;, &quot;USA&quot;));</div>
<div>&nbsp;</div>
<div>
<p>第三种方法的是使用Where 扩展方法，使用关键字it 指向当前的查询语句：</p>
</div>
<div>var sql = &quot;Select VALUE emp FROM NorthwindEntities.Employees AS emp&quot;;</div>
<div>var query = context.CreateQuery&lt;Employee&gt;(sql)</div>
<div>&nbsp;.Where(&quot;it.Country = @country&quot;, new ObjectParameter(&quot;country&quot;, &quot;USA&quot;));</div>
<div>
<p><b>3. ObjectQuery&lt;T&gt; 查询返回基本类型(Primitive Type)</b></p>
<p>除了返回实体类型外，也可以返回基本类型集合，因此需要确保Select语句仅仅返回1个值，同时也需要在CreateQuery方法中指定需要返回的基本类型。</p>
</div>
<div>var sql = &quot;Select VALUE emp.EmployeeID FROM NorthwindEntities.Employees AS emp &quot; +</div>
<div>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &quot;Where emp.Country = @country&quot;;</div>
<div>var query = context.CreateQuery&lt;int&gt;(sql, new ObjectParameter(&quot;Country&quot;, &quot;USA&quot;));</div>
<div>&nbsp;</div>
<div>foreach (var id in query)</div>
<div>&nbsp;Console.WriteLine(&quot;{0}&quot;, id.ToString());</div>
<div>
<p>另一示例脚本：</p>
</div>
<div>var sql = &quot;Select VALUE emp.Country FROM NorthwindEntities.Employees AS emp &quot; +</div>
<div>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &quot;Where emp.EmployeeID = @id&quot;;</div>
<div>var query = context.CreateQuery&lt;string&gt;(sql, new ObjectParameter(&quot;id&quot;, 1));</div>
<div>&nbsp;</div>
<div>Console.WriteLine(query.First());</div>
<div>
<p>除了使用 Entity SQL外，你也能使用查询构造（Query Builder）方法实现相同的效果。Entity SQL 提供了SelectValue 方法，可以提过隐式的行构造器，仅仅返回指定的列。</p>
</div>
<div>string country = context.Employees.SelectValue&lt;string&gt;(&quot;it.Country&quot;, new ObjectParameter(&quot;id&quot;, 1)).First();</div>
<div>&nbsp;</div>
<div>Console.WriteLine(country);</div>
<div>
<p><b>4. ObjectQuery&lt;T&gt; 查询返回匿名类型</b></p>
</div>
<div>
<p>也有可能需要调整数据，并使用ObjectQuery&lt;T&gt;查询返回匿名类型。在CreateQuery 方法中，改变Select语句并使用DbDataRecord 类，DbDataReader类在.NET 1.0引入，它提供了对任何枚举类型的数据绑定支持。</p>
</div>
<div>var sql = &quot;Select emp.LastName, emp.FirstName &quot; +</div>
<div>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &quot;FROM NorthwindEntities.Employees AS emp &quot;;</div>
<div>var query = context.CreateQuery&lt;DbDataRecord&gt;(sql);</div>
<div>&nbsp;</div>
<div>foreach (var emp in query)</div>
<div>&nbsp;Console.WriteLine(&quot;{0} {1}&quot;, emp[0], emp[1]);</div>
<div>
<p>另一示例代码：</p>
</div>
<div>var sql = &quot;Select emp.LastName AS FamilyName, emp.FirstName &quot; +</div>
<div>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &quot;FROM NorthwindEntities.Employees AS emp &quot;;</div>
<div>var query = context.CreateQuery&lt;DbDataRecord&gt;(sql);</div>
<div>&nbsp;</div>
<div>foreach (var emp in query)</div>
<div>&nbsp;Console.WriteLine(&quot;{0} {1}&quot;, emp[&quot;FamilyName&quot;], emp[&quot;FirstName&quot;]);</div>
</div>]]></summary>
	  <link rel="alternate" type="text/html" href="http://www.yacosoft.com/article.asp?id=21" /> 
	  <id>http://www.yacosoft.com/default.asp?id=21</id>
  </entry>	
		
  <entry>
	  <title type="html"><![CDATA[Entity Data Model (EDM) 深入分析, Part 1]]></title>
	  <author>
		 <name>卿卿</name>
		 <uri>http://www.yacosoft.com/</uri>
		 <email>zyq_17@qq.com</email>
	  </author>
	  <category term="" scheme="http://www.yacosoft.com/default.asp?cateID=14" label="软件技术" /> 
	  <updated>2009-04-14T09:45:04+08:00</updated>
	  <published>2009-04-14T09:45:04+08:00</published>
		  <summary type="html"><![CDATA[<div>
<div>
<p>Entity Data Model是.NET Framework v3.5 SP1引入的新功能，比Linq To SQL更加强大的ORM，让开发人员只需要着眼于领域对象模型的开发，而不需要考虑它们是如何与关系数据库交互。本系列文章逐步深入介绍如下内容：EDMX Schema 文件、Model Browser、映射关系、产生的实体类（Generated entity classes）、文档（Documentation）等等。</p>
</div>
<div>
<p><b>1. EDMX Schema 文件</b></p>
</div>
<div>
<p>可以将EDMX作为XML文件打开，你会发现该文件包含3个主要部分。</p>
</div>
<div>Conceptual Models (CSDL)</div>
<div>Storage Models (SSDL)</div>
<div>Mapping (MSL)</div>
<div>
<p>一般情况下，你没有必要手动修改EDMX -XML文件。可视化的EDM 设计器、Mapping Details窗口和Model Browser 窗口包含有上述3个部分，并非常友好地显示整个Entity Data Model模型。</p>
<p>当你编译项目时，MSBuild 将从EDMX文件提取CSDL/SSDL/MSL内容，并放置3个独立的XML文件到项目的输出目录。</p>
</div>
<div>
<p><b>2. Model Browser 窗口</b></p>
</div>
<div>
<p>Model Browser窗口以可视的树形图显示概念模型和存储模型。</p>
<p><img alt="" src="http://www.uml.org.cn/net/images/EDM_Analysis_1.gif" width="314" /></p>
</div>
<div>
<p><b>3. Mapping details 窗口</b></p>
<p>EDM设计器也提供了一个不错的Mapping Details 窗口，包含2个视图。</p>
</div>
<div>
<p>Map Entity to Tables / View</p>
</div>
<p>这一视图显示了数据库中所有字段和相应实体中的属性，可以用来查看和编辑EDM的映射关系。</p>
<p><img alt="" src="http://www.uml.org.cn/net/images/EDM_Analysis_2.gif" width="688" height="338" /></p>
<div>
<p>Map Entity to Functions</p>
<p>这一视图用来选择一个特定的存储过程来插入、更新或删除Entity实例。</p>
<p><img alt="" src="http://www.uml.org.cn/net/images/EDM_Analysis_3.gif" width="684" height="160" /><br />
&nbsp;</p>
</div>
<div>
<p><b>4. 生成的实体类（Generated Entity Classes）</b></p>
<p>除了上述的XML Schema文件外，EDM向导也生成了实体类。下一步仔细分析.Designer.cs文件中的实体类，并和LINQ to SQL中的类进行比较。</p>
</div>
<div>
<p><b>1) 比较 LINQ to SQL class 和 EDM EntityObject class</b></p>
</div>
<div>// LINQ to SQL</div>
<div>[Table(Name=&quot;dbo.Employees&quot;)]</div>
<div>public partial class Employee : INotifyPropertyChanging, INotifyPropertyChanged</div>
<div>&nbsp;</div>
<div>EDM类则是以不同的attributes，并且总是继承EntityObject或ComplexObject 类。EntityObject 类提供了变更跟踪和关系管理。</div>
<div>// Entity Data Model</div>
<div>[global::System.Data.Objects.DataClasses.EdmEntityTypeAttribute(NamespaceName=&quot;NorthwindModel&quot;, Name=&quot;Employee&quot;)]</div>
<div>[global::System.Runtime.Serialization.DataContractAttribute()]</div>
<div>[global::System.Serializable()]</div>
<div>public partial class Employee : global::System.Data.Objects.DataClasses.EntityObject</div>
<div>
<p><b>2) 比较LINQ to SQL entity constructor 和 EDM Create method</b></p>
</div>
<div>// LINQ to SQL</div>
<div>public Employee()</div>
<div>{</div>
<div>&nbsp;this._Employees = new EntitySet&lt;Employee&gt;(new Action&lt;Employee&gt;(this.attach_Employees), new Action&lt;Employee&gt;(this.detach_Employees));</div>
<div>&nbsp;this._EmployeeTerritories = new EntitySet&lt;EmployeeTerritory&gt;(new Action&lt;EmployeeTerritory&gt;(this.attach_EmployeeTerritories),</div>
<div>&nbsp;&nbsp;&nbsp; new Action&lt;EmployeeTerritory&gt;(this.detach_EmployeeTerritories));</div>
<div>&nbsp;this._Orders = new EntitySet&lt;Order&gt;(new Action&lt;Order&gt;(this.attach_Orders), new Action&lt;Order&gt;(this.detach_Orders));</div>
<div>&nbsp;this._Employee1 = default(EntityRef&lt;Employee&gt;);</div>
<div>&nbsp;OnCreated();</div>
<div>}</div>
<div>&nbsp;</div>
<div>EDM没有生成上述LINQ to SQL的构造函数，而是创建了一个特定的Create方法，并提供了所有必需属性（not nullable）的输入参数。</div>
<div>// Entity Data Model</div>
<div>public static Employee CreateEmployee(int employeeID, string lastName, string firstName)</div>
<div>{</div>
<div>&nbsp;&nbsp;&nbsp; Employee employee = new Employee();</div>
<div>&nbsp;&nbsp;&nbsp; employee.EmployeeID = employeeID;</div>
<div>&nbsp;&nbsp;&nbsp; employee.LastName = lastName;</div>
<div>&nbsp;&nbsp;&nbsp; employee.FirstName = firstName;</div>
<div>&nbsp;&nbsp;&nbsp; return employee;</div>
<div>}</div>
<div>
<p><b>3) 比较LINQ to SQL 和 EDM : 实体属性（entity property）</b></p>
</div>
<div>// LINQ to SQL</div>
<div>[Column(Storage=&quot;_EmployeeID&quot;, AutoSync=AutoSync.OnInsert, DbType=&quot;Int NOT NULL IDENTITY&quot;, IsPrimaryKey=true, IsDbGenerated=true)]</div>
<div>public int EmployeeID</div>
<div>{</div>
<div>&nbsp;get</div>
<div>&nbsp;{</div>
<div>&nbsp;&nbsp;&nbsp; return this._EmployeeID;</div>
<div>&nbsp;}</div>
<div>&nbsp;set</div>
<div>&nbsp;{</div>
<div>&nbsp;&nbsp;&nbsp;if ((this._EmployeeID != value))</div>
<div>&nbsp;&nbsp;&nbsp; {</div>
<div>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; this.OnEmployeeIDChanging(value);</div>
<div>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; this.SendPropertyChanging();</div>
<div>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; this._EmployeeID = value;</div>
<div>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; this.SendPropertyChanged(&quot;EmployeeID&quot;);</div>
<div>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; this.OnEmployeeIDChanged();</div>
<div>&nbsp;&nbsp;&nbsp; }</div>
<div>&nbsp;}</div>
<div>}</div>
<div>
<p>尽管EDM公有属性（public property）的attribute是不同的，但get和set 基本是一样的。</p>
</div>
<div>// Entity Data Model</div>
<div>[global::System.Data.Objects.DataClasses.EdmScalarPropertyAttribute(EntityKeyProperty=true, IsNullable=false)]</div>
<div>[global::System.Runtime.Serialization.DataMemberAttribute()]</div>
<div>public int EmployeeID</div>
<div>{</div>
<div>&nbsp;&nbsp;&nbsp; get</div>
<div>&nbsp;&nbsp;&nbsp; {</div>
<div>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; return this._EmployeeID;</div>
<div>&nbsp;&nbsp;&nbsp; }</div>
<div>&nbsp;&nbsp;&nbsp; set</div>
<div>&nbsp;&nbsp;&nbsp; {</div>
<div>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; this.OnEmployeeIDChanging(value);</div>
<div>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; this.ReportPropertyChanging(&quot;EmployeeID&quot;);</div>
<div>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; this._EmployeeID = global::System.Data.Objects.DataClasses.StructuralObject.SetValidValue(value);</div>
<div>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; this.ReportPropertyChanged(&quot;EmployeeID&quot;);</div>
<div>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; this.OnEmployeeIDChanged();</div>
<div>&nbsp;&nbsp;&nbsp; }</div>
<div>}</div>
<div>
<p><b>4) 比较LINQ to SQL Table 和 EDM ObjectQuery</b></p>
</div>
<div>// LINQ to SQL</div>
<div>public System.Data.Linq.Table&lt;Employee&gt; Employees</div>
<div>{</div>
<div>&nbsp;get</div>
<div>&nbsp;{</div>
<div>&nbsp;&nbsp;&nbsp; return this.GetTable&lt;Employee&gt;();</div>
<div>&nbsp;}</div>
<div>}</div>
<div>
<p>在LINQ to SQL中，调用GetTable 方法，返回实体集合。在EDM中，通过Object Services compoment 执行Entity SQL 查询，返回EntityType的计划EntitySet。</p>
</div>
<div>// Entity Data Model</div>
<div>[global::System.ComponentModel.BrowsableAttribute(false)]</div>
<div>public global::System.Data.Objects.ObjectQuery&lt;Employee&gt; Employees</div>
<div>{</div>
<div>&nbsp;&nbsp;&nbsp; get</div>
<div>&nbsp;&nbsp;&nbsp; {</div>
<div>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; if ((this._Employees == null))</div>
<div>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; {</div>
<div>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; this._Employees = base.CreateQuery&lt;Employee&gt;(&quot;[Employees]&quot;);</div>
<div>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; }</div>
<div>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; return this._Employees;</div>
<div>&nbsp;&nbsp;&nbsp; }</div>
<div>}</div>
<div>private global::System.Data.Objects.ObjectQuery&lt;Employee&gt; _Employees;</div>
<div>
<p><b>5) 比较LINQ to SQL DataContext &nbsp;和 EDM ObjectContext</b></p>
</div>
<div>// LINQ to SQL</div>
<div>[System.Data.Linq.Mapping.DatabaseAttribute(Name=&quot;Northwind&quot;)]</div>
<div>public partial class NorthwindDataContext : System.Data.Linq.DataContext</div>
<div>&nbsp;</div>
<div>EDM有一个类似于LINQ to SQL DataContext 的ObjectContext类，ObjectContext 类是负责与EDM 中实体类型交互的基本类。ObjectContext用来创建数据库连接、检索数据、持久化对象、以及对数据库的插入、更新和删除操作。</div>
<div>&nbsp;</div>
<div>// Entity Data Model</div>
<div>public partial class NorthwindEntities : global::System.Data.Objects.ObjectContext</div>
<div>&nbsp;</div>
<div>ObjectContext的连接字符串指向元数据（CSDL/SSDL/MSL 文件）和数据源（数据库连接字符串）。</div>
<div>connectionString=&quot;metadata=.\NorthwindModel.csdl|.\NorthwindModel.ssdl|.\NorthwindModel.msl;</div>
<div>&nbsp;provider=System.Data.SqlClient;&nbsp;provider connection string=&amp;quot;</div>
<div>&nbsp;Data Source=SQLEXPRESS; Initial Catalog=Northwind; Integrated Security=True; MultipleActiveResultSets=True&amp;quot;&quot;</div>
<div>
<p><b>5. Documentation 属性</b></p>
</div>
<div>
<p>EDM中的实体类型（EntityTypes）、关联和属性有一个Documentation属性，对LINQ to SQL而言，这是一个新的属性。</p>
</div>
<p><img alt="" src="http://www.uml.org.cn/net/images/EDM_Analysis_4.png" width="238" height="148" /><br />
<br />
　 Documentation属性将更新生成的partial实体类的XML注释，可以用来生成代码文档的帮助文件。</p>
<div>/// &lt;summary&gt;</div>
<div>/// Employee entity which corresponds with the Northwind.Employees table</div>
<div>/// &lt;/summary&gt;</div>
<div>/// &lt;KeyProperties&gt;</div>
<div>/// EmployeeID</div>
<div>/// &lt;/KeyProperties&gt;</div>
<div>[global::System.Data.Objects.DataClasses.EdmEntityTypeAttribute(NamespaceName=&quot;NorthwindModel&quot;, Name=&quot;Employee&quot;)]</div>
<div>[global::System.Runtime.Serialization.DataContractAttribute()]</div>
<div>[global::System.Serializable()]</div>
<div>public partial class Employee : global::System.Data.Objects.DataClasses.EntityObject</div>
</div>]]></summary>
	  <link rel="alternate" type="text/html" href="http://www.yacosoft.com/article.asp?id=20" /> 
	  <id>http://www.yacosoft.com/default.asp?id=20</id>
  </entry>	
		
</feed>
