Skip to main content

Microsoft Silverlight

Answered Question can i make a ria call that waits for a value to change in the database to return the new value?RSS Feed

(0)

Wigen
Wigen

Member

Member

3 points

16 Posts

can i make a ria call that waits for a value to change in the database to return the new value?

 

  I want to be able to monitor a table and wait for a value in a row to change, so i can bring back some values. How could i do this on the server side?

Ardman
Ardman

Contributor

Contributor

3434 points

946 Posts

Re: can i make a ria call that waits for a value to change in the database to return the new value?

 Try googling for Push services.  I'm not 100% sure if this is included as part of RIA services, but I know that you can push data from the Server to the client.

prujohn
prujohn

Contributor

Contributor

3579 points

704 Posts

Re: can i make a ria call that waits for a value to change in the database to return the new value?

Push is not included in RIAS.

Wigen
Wigen

Member

Member

3 points

16 Posts

Re: Re: can i make a ria call that waits for a value to change in the database to return the new value?

Could i somehow have a service in a loop until a value changes? or will this be murder on the cpu?

prujohn
prujohn

Contributor

Contributor

3579 points

704 Posts

Answered Question

Re: Re: can i make a ria call that waits for a value to change in the database to return the new value?

It depends on what your requirements are.  Do you need to know about the changes the split second they happen, or is it tolerable to poll for changes every 30 seconds?  If the latter, then setting up a polling timer should not be that much of an issue.  However, you need to always consider scalability issues, such as how many concurrent sessions do you expect to have (again this goes back to your app requirements) .

max_pau
max_pau

Member

Member

218 points

66 Posts

Re: can i make a ria call that waits for a value to change in the database to return the new value?

 Wigen, look at my article

it describes how you can monitore your database and get notifications about changes

Do not forget to click "Mark as Answer" on my post that helped you
  • Unanswered Question
  • Answered Question
  • Announcement
Microsoft Communities