sqlkatapatch.cs

[HttpPatch]
public async Task Patch([FromODataUri] int key, Delta<vw_Song> delta)
{
    var changedProps = delta.GetChangedPropertyNames();
    var instance = delta.GetInstance();
    var updateDict = new Dictionary<string, object>();

    if (changedProps.Contains("Status"))
    {
        updateDict.Add("Status", instance.Status);
    }

    var q = new SqlKata.Query("Country_Songs")
        .Where("SongId", key)
        .AsUpdate(updateDict);

    var result = _compiler.Compile(q);

    await _db.Database.ExecuteSqlRawAsync(result.Sql, result.Bindings);
}