Search code examples
c#asp.netxmlsql-server-2008linq-to-entities

Create xml file by using sql trigger or LINQ to Entity

I want to trace the database when user is insert update or delete any record.I noe I can trace database by create sql trigger. I actually want to store those record changes in xml file, then sql trigger will save xml file to database

Is it possible to make it?Or using other way? For eg : LINQ to Entity

Solution

  • Maybe you should search for this first. You can use FOR XML or xp_cmdshell. This link is like you wanna do.

    Thanks.