Passing data to a client on a specific page based on updating a SQL Server column or row

I want to achieve something specific using ASP.NET and SQL Server. Let, for example, I have several pages, each of which has its own identification (i.e. id = 1, id = 5). Also, suppose for each of these id I have a row in the database:

In short, I want to achieve: Push database changes directly for specific clients on certain pages when using web sockets (permanent connection).

eg:

Line 1:

id = 1

name = myname1

Line 2:

id = 2

name = myname2

, , , , , , , .

: 1 'name1' 'name2', - 5, , , id = 5, .

, , - , , - .

, , / (.. memcache), , id, datetime lst. , , , [5, 05/11/2012 12:03:45], , , , . datetime , / , .

, .

, :

  • [ ASP.NET 4.5]

  • , , , , id = 1, id = 2 .. , , - , . : {1: 2346,6767,87878, 2: 876,8765,3455}. 1 2 - (.. id = 1, id = 2), , ASP.net 4.5

  • id = 5 "count" , "1" "2".

  • ( X) . ( ) [ CLR]

  • , X ()

  • , , true false, , .

:

1] ASP.NET 4.5

4] CLR , , .

ASP.NET 4.5.

+3
1

Sql Server Service Broker .

Service Broker sql. , 2 .

, -. T-SQL . - , varbinary (max). xml, varchar (100), .

- . transact-sql . , - . , .

, ( - asp.net):

  • .
  • , : " = 3)
  • RECEIVE,
  • UPDATE = 3
  • Page = 3
  • -.

CLR, .

+1
source

All Articles