.net - Which approach should i opt for? -


in scenario have extract data sql server , migrate sharepoint , record entered database have run console application executes migration process , client gave me strict requirement wants data migrated right away entered in database .

there 2 possible ways , think task can done by

1 scheduling console application run after every 1 minute

2 database pooling (i have heard thing ,can guys me out references articles , other material on internet relevant approach )

so guys think , approach should opt ?

.net has has sql notification
more efficient polling

using sqlnotificationrequest subscribe query notifications

and sure console app correct approach?
consider s service.

also consider siss joe recommended.


Comments

Popular posts from this blog

Why does Ruby on Rails generate add a blank line to the end of a file? -

keyboard - Smiles and long press feature in Android -

node.js - Bad Request - node js ajax post -