Connected Dataset

Hi guys, is there a way to declare a connected dataset for MS SQL Server that gets continuous updates? only familiar with the one with Oracle, hoping there is something similar for MSSQL.

 Thanks

a DataSet is disconnected by design. It is meant to retrieve a subset of a database/data source and cache that in CLR memory space. If you want somethings that "listens" for changes in SQL Server, you may wanna use the SqlDependencyCache to reload data when the database data changes.

hi, thanks for that. Does this create problems for a large table with high data insert since it mention it reloads the cache. for example, something with more than 30,000 rows and 30 new rows a second?