EF的Linq查询对中文的支持

如:Linq的where查询条件中有中文查询不到,则需要更改web.confgi配置文件中与数据库的连接

添加:Charset=utf8

 <appSettings>

    <add key="TEST" value="Server=localhost;Database =test;UID=test;PWD=test;Charset=utf8 " />

  </appSettings>

添加:Character Set=utf8

<connectionStrings>
<add name="test" connectionString="metadata=res://*/AO.AOModel.csdl|res://*/AO.AOModel.ssdl|res://*/AO.AOModel.msl;provider=MySql.Data.MySqlClient;provider connection string=&quot;server=localhost;password=test;user id=test;database=test;Character Set=utf8;persistsecurityinfo=True&quot;" providerName="System.Data.EntityClient" />
</connectionStrings>

则查询中文正常

 

posted @ 2020-08-31 11:33  拼命撸码的徐哥  阅读(258)  评论(0编辑  收藏  举报