Sqldependency round robin

The System. Data. SqlClient. SqlDependency class provides a good function about sql2005. Although there are many restrictions on this feature, it is still very useful. Let's first look at a demo: In this example, we first create an SQL environment where some data is inserted, and then use the. net client to query the data.

The System. Data. SqlClient. SqlDependency class provides a good function about sql2005. Although there are many restrictions on this feature, it is still very useful. Let's first look at a demo: In this example, we first create an SQL environment where some data is inserted, and then use the. net client to query the data.

The System. Data. SqlClient. SqlDependency class provides us with a good function about sql2005. Although the Hong Kong server has many restrictions on this, it is still very useful.
Let's first look at a demo:
In this example, we first create an SQL environment where some data is inserted, and the record-free space is used.. net client query, Hong Kong space, and then change the database after the query results are returned, add some records, and view at the same time.. net client table.

1. Create an SQL test environment

SQL code

Use master dbTestgouse dbTest) enable_broker