• 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
..
Helpers Loading commit data...
Providers Loading commit data...
SharedTypes Loading commit data...
App.config Loading commit data...
AsyncTests.cs Loading commit data...
ConstructorTests.cs Loading commit data...
Dapper.Tests.csproj Loading commit data...
DataReaderTests.cs Loading commit data...
DecimalTests.cs Loading commit data...
EnumTests.cs Loading commit data...
LiteralTests.cs Loading commit data...
MiscTests.cs Loading commit data...
MultiMapTests.cs Loading commit data...
NullTests.cs Loading commit data...
ParameterTests.cs Loading commit data...
ProcedureTests.cs Loading commit data...
ProviderTests.cs Loading commit data...
QueryMultipleTests.cs Loading commit data...
SqlBuilderTests.cs Loading commit data...
TestBase.cs Loading commit data...
TransactionTests.cs Loading commit data...
TupleTests.cs Loading commit data...
TypeHandlerTests.cs Loading commit data...
XmlTests.cs Loading commit data...