I have within my Sql Server 2008 database a trigger which will run on insert and update to populate a calendar table with dates calculated from the date info in the first table. (i.e. start date, end date, repeating sequence information).
I am using ASP.Net MVC using Linq to Sql to access the Database. My first view is collecting the data to populate the input information, and then I am looking to redirect to a second "results" view which will include the calculated dates.
How do I ensure that the triggered update has completed prior to accessing the database to populate my "results" view?
Is there a better way?