Ciao Ale, i've create a service using SqlModelMapper and here is the code:



//service

using System;

namespace StartWebApi3.Services.SqlModelMapper

{

public interface IMMASAInterventiWebInkService

{

int UpdateInk(string img, string id);

String GetConnection();

}

}



//Impl (service)

using System;

using SnapObjects.Data;

namespace StartWebApi3.Services.SqlModelMapper.Impl

{

public class MMASAInterventiWebInkService : IMMASAInterventiWebInkService

{

private readonly DataContextBaseSqlModelMapperAsa _dataContext;

public MMASAInterventiWebInkService(DataContextBaseSqlModelMapperAsa dataContext)

{

_dataContext = dataContext;

}



public int UpdateInk(string img, string id)

{

byte[] decodedByteArray = Convert.FromBase64String(img);

var sqlbuilder = new SqlUpdateBuilder();

sqlbuilder.Update("interventi").SetValue("firma_cliente", decodedByteArray).Where("id_interventi", id);



// Converts to raw SQL for the database corresponding to the data context.

string sql = sqlbuilder.ToSqlString(_dataContext);

Console.WriteLine(sql);

int row = _dataContext.SqlExecutor.Execute(sql);

return 1;

}



public String GetConnection()

{

// Current DataContext's ConnectionString

return _dataContext.CurrentConnection.ConnectionString;

}

}

}



//Controller

using StartWebApi3.Services.SqlModelMapper;

using Microsoft.AspNetCore.Mvc;

using System;

using Microsoft.AspNetCore.Authorization;



namespace StartWebApi3.Controllers.SqlModelMapper

{

[Route("api/[controller]/[action]")]

[ApiController]

public class MMASAInterventiWebInkController : ControllerBase

{

private IMMASAInterventiWebInkService _service;



public MMASAInterventiWebInkController(IMMASAInterventiWebInkService service)

{

_service = service;

}



[HttpPost]

[Authorize]

public int UpdateInk([FromBody]string img, [FromHeader]string id_interventi)

{

string id = Request.Headers["id_interventi"];

return _service.UpdateInk(img, id);

}



[HttpGet]

public String GetConnection()

{

// Current DataContext's ConnectionString

return _service.GetConnection();

}

}

}



Hope that helps!

Hi Simone





Thank you very much, I immediately start working around your example, very very useful.

Thanks again

Ale