BookService.cs

    public int Update(BookModel bookModel)
    {
         using (IDbConnection db = new SqlConnection(Configuration.GetConnectionString("SampleDB"))
        {
            string sqlQuery ="UPDATE Book SET Title = @Title, " +
            "Author  = @Author" + "WHERE Id = @Id";
            int rowsAffected = db.Execute(sqlQuery, author);
            return rowsAffected;
        }
    }