jeudi 5 février 2015

Web API or what to save a file in server's filesystem


We have a SQL Server 2012 Enterprise edition and an ASP.NET Web Api 2.2 web service. The web API is the public interface for the database.


We need to end a production order doing:



  1. Changing a value in Production orders table.

  2. Generate a XML with all data related to this Production order.

  3. Save that XML file into server's file system.


I have thought to do it with a POST to Web API, but I don't know if I have to do the three previous steps ( Changing value, generating XML and saving it) in a Stored Procedure or maybe in the Web Api Controller.


Maybe, if I do it the Api controller, it will take a long time and the client will get a tiemout.


What is your opinion? What do you think?


By the way, is this the right place to ask this kind of questions?





Aucun commentaire:

Enregistrer un commentaire