Datagrid does not update changed data

Question

Is there a way to get the datagrid to listen on the database and automatically update the data if the database data is changed? I am using a SQL Server database.

I would like to use Linq-2-SQL if possible

Answer 1

Because @Slaggg asked: there are fairly simple ways to do this, but they will almost certainly include a lot of coding, this will significantly affect performance, and my strong suspicion is that it will be more than it costs.

However, for a typical n-tier application at a very high level, you will need:

(1) . , - (, WCF CLR), SqlDependency. , .

(2) , . , WCF, , Net.TCP HttpPollingDuplex ( Silverlight). , , . , , , , , . MS WCF , .

(3) / / , , - . , : , , .

: , , . , , .

, .

Answer 2

, :

• ( Silverlight, , , )
• ChildWindow Silverlight
• , , Silverlight.