发布于

c# dapper mysql like

const string sql = "SELECT * from user_profile WHERE FirstName LIKE @name;";
var result = connection.Query<Profile>(sql, new {name = "%"+name+"%"});

发布于

appsettings.json Copy to Output Directory

在vscode中遇到问题，读取不到配置文件，发现appsettings.json并未复制到编译的目录中，所以，在project.csproj中添加一下代码

<ItemGroup>
    <Content Include="appsettings.json">
      <CopyToOutputDirectory>Always</CopyToOutputDirectory>
      <CopyToPublishDirectory>PreserveNewest</CopyToPublishDirectory>
    </Content>
  </ItemGroup>

重新编译后可以复制此文件到目标目录。