Notify client with updated Records-Asp.net
<p>I want to create app in asp.net ( may be signalR or web API)
<br/>
Here is a case
<br/>
1) 3rd party or external application update xml file ( around 1000 entries) on each 15 minutes on Server
<br/>
2) XML contains ProdID,Qty,ShippingDate
<br/>
3) with ProdID, name and description of product is retrieved from database.
<br/>
4) On UI, Readonly view need to display for all records from XML in tabular format.
<br/>
5) when any records change on server side ( XML is overwritten on 15 minutes),change color for products which Qty or ShippingDate is updated also send new value of qty and shippingdate
6) in rare case, records may be deleted in xml ( product is removed in new version of xml)
<br/>
<br/>
I m thinking on following design
<br/></p>

<ul>
<li>
Cache XML in asp.net app and update cache on change of that xml
</li><li>use linq to convert xml to collection of class
</li><li>store previous collectioin and current collection when cache is cleared
</li><li>compare collection and identify which records are changed
</li><li>prepare collection of changed records which can be retried with public method on server.
</li><li>Send notification to client that records on server updated.
on client, on notification make call to server to get data.
</li></ul>

<p><br/>
let me know how/which is faster way to compare collection of xml to identify which records are changed.
<br/>
method to get xml data from server to client is done by web API
<br/>
how web API and Signal R can be in same app. I new to SignalR</p>

<p>any input will be great on this approach </p>