Sorry this might be a very simple question,
I can't find anywhere give me a sure answer,
and I'm very new to the database management system,
so please give me a short guide.
Does SQL Server support consistency transaction on XML? (I'm using ASP.NET Web API)
In my use case, the entity Project has an attribute TaskTree,
which saves the concrete task structure of the Project.
The datatype of TaskTree is XML. (umm, I'm also wondering how I pass a xml within JSON response...)
So the main problem is:
For short:
Any of the modification request to the TaskTree need a long time to modify XML file.
If there are many people request to modify the TaskTree at the same time,
Can all the input/output to the XML file be consistent in SQL SERVER?
Thanks.