CODEWITHSUNDEEP
asp.net-mvc-4model-view-controllerasp.net-mvc-5
Hoàng Đỗ Huy
Hoàng Đỗ Huy

Reputation: 79

How to know which field in Data base changed?

I am developing a Travel Operator Management System that manage all the services and tours of a company. And i need to know which fields changed when a user update their database. For ex: I have a table name service with columns: Service name Date Start Date End Itinerary

An user update a service that change the Date Start from 05/25/2015 to 05/27/2015 so i need to tracking this, i must notification for user who work on this rows that this service has changed Date Start from 05/25/2015 to 05/27/2015. How can i do with ASP MVC 4 or 5?

Upvotes: 0

Views: 36

Answers (1)

Kaushik Thanki
Kaushik Thanki

Reputation: 3548

You can use sql notification for this, Also you can use some backgroud service that continue look in queue table and the queue gets data form on update trigger of sql.

Upvotes: 1

Related Questions