• Wei's avatar
    SqlBuilder Support Update Set (#1404) · 5c87dc97
    Wei authored
    I add update `Set` method and unit test.
    
    e.g: 
    ```C#
    var sb = new SqlBuilder()
           .Set("vip = @vip", new { vip })
           .Set("updatetime = @updatetime", new { updatetime })
           .Where("id = @id", new { id })
    ;
    var template = sb.AddTemplate("update #Users /**set**/ /**where**/");
    connection.Execute(template.RawSql, template.Parameters);
    ```
    
    RawSql will generate : 
    ```
    update #Users Set vip = @vip , updatetime = @updatetime\n WHERE id = @id\n
    ```
    
    using Dapper Execute in sqlserver it'll reqeust by below sql command
    ```
    exec sp_executesql N'update #Users Set vip = @vip , updatetime = @updatetime
     WHERE id = @id
    ',N'@vip bit,@updatetime datetime,@id int',@vip=1,@updatetime='2020-01-01 00:00:00',@id=1
    ```
    Co-authored-by: 's avatarNick Craver <nrcraver@gmail.com>
    Co-authored-by: 's avatarNick Craver <craver@stackoverflow.com>
    5c87dc97
Name
Last commit
Last update
Dapper Loading commit data...
Dapper.Contrib Loading commit data...
Dapper.EntityFramework Loading commit data...
Dapper.EntityFramework.StrongName Loading commit data...
Dapper.ProviderTools Loading commit data...
Dapper.Rainbow Loading commit data...
Dapper.SqlBuilder Loading commit data...
Dapper.StrongName Loading commit data...
Dapper.Tests Loading commit data...
Dapper.Tests.Contrib Loading commit data...
Dapper.Tests.Performance Loading commit data...
docs Loading commit data...
.editorconfig Loading commit data...
.gitattributes Loading commit data...
.gitignore Loading commit data...
Dapper.sln Loading commit data...
Dapper.sln.DotSettings Loading commit data...
Dapper.snk Loading commit data...
Directory.Build.props Loading commit data...
Directory.Build.targets Loading commit data...
License.txt Loading commit data...
Readme.md Loading commit data...
appveyor.yml Loading commit data...
build.cmd Loading commit data...
build.ps1 Loading commit data...
build.sh Loading commit data...
game Loading commit data...
global.json Loading commit data...
nuget.config Loading commit data...
version.json Loading commit data...