Hello guys !
i've a scenario in asp net mvc with entity framework where when user enter a record i save it in one field in XML form after converting whole object into XML.
now i'm not able to update it. like when user updates the record i want previous XML to be there and new updated XML come into that column following the previous XML in that column
like
this is when user submits a new record the XML is saved like this
<?xml version="1.0" encoding="utf-16"?>
<UserRightsXml xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<Id_Num>0</Id_Num>
<RecordId>45</RecordId>
<User_Reg_02_Id_Num>17</User_Reg_02_Id_Num>
<Cr_Id>30</Cr_Id>
<Cr_Date>2017-07-23T16:32:23.0543196+05:00</Cr_Date>
<Up_Id xsi:nil="true" />
<Up_Date xsi:nil="true" />
</UserRightsXml>
now when user updates this record i want data to be saved like this
<?xml version="1.0" encoding="utf-16"?>
<UserRightsXml xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<Id_Num>0</Id_Num>
<RecordId>45</RecordId>
<User_Reg_02_Id_Num>17</User_Reg_02_Id_Num>
<Cr_Id>30</Cr_Id>
<Cr_Date>2017-07-23T16:32:23.0543196+05:00</Cr_Date>
<Up_Id xsi:nil="true" />
<Up_Date xsi:nil="true" />
<Id_Num>0</Id_Num>
<RecordId>45</RecordId>
<User_Reg_02_Id_Num>18</User_Reg_02_Id_Num>
<Cr_Id>30</Cr_Id>
<Cr_Date>2017-07-23T16:32:23.0543196+05:00</Cr_Date>
<Up_Id xsi:nil="true" />
<Up_Date xsi:nil="true" />
</UserRightsXml>
and so on whenever record gets updated