CODEWITHSUNDEEP
c#sql-serverwpfwcf
JD Roberson
JD Roberson

Reputation: 599

Real Time Data with WCF

I have a mssql server that holds realtime data for calls in a call center. To limit queries to the server I have created a WCF service to query that DB.

Using either winforms or wpf in C# I would like to show this data in as near realtime as I can.

I am currently binding a GridView to an ObservableCollection and populating the collection with the WCF service.

This works, but it has a 10+ second lag between updates, not matter how fast I request them.

How can I get "live" data from this mssql server using wcf?

Upvotes: 0

Views: 760

Answers (1)

KiwiPiet
KiwiPiet

Reputation: 1334

It sounds like you are using polling (i.e. some sort of timer or loop that constantly queries the database) to get your data. That way you will struggle to get real-time updates.

Have you investigated getting the data as a stream from the call centre?

Another approach could be to look at something like Service Broker to notify you about new updates.

Upvotes: 1

Related Questions