Click here to Skip to main content
15,904,156 members
Home / Discussions / C#
   

C#

 
AnswerRe: How to use IWin32Window Pin
Eddy Vluggen1-Apr-13 0:03
professionalEddy Vluggen1-Apr-13 0:03 
GeneralRe: How to use IWin32Window Pin
mhd almidani1-Apr-13 5:09
mhd almidani1-Apr-13 5:09 
GeneralRe: How to use IWin32Window Pin
Alan N1-Apr-13 5:24
Alan N1-Apr-13 5:24 
GeneralRe: How to use IWin32Window Pin
mhd almidani1-Apr-13 20:35
mhd almidani1-Apr-13 20:35 
GeneralRe: How to use IWin32Window Pin
Eddy Vluggen1-Apr-13 11:34
professionalEddy Vluggen1-Apr-13 11:34 
AnswerRe: How to use IWin32Window Pin
Richard MacCutchan1-Apr-13 0:03
mveRichard MacCutchan1-Apr-13 0:03 
QuestionCustom TabControl: Designer adds TabPages in wrong order! Pin
Revolty31-Mar-13 9:33
Revolty31-Mar-13 9:33 
AnswerRe: Custom TabControl: Designer adds TabPages in wrong order! Pin
Revolty7-Apr-13 5:18
Revolty7-Apr-13 5:18 
Questionكيف البحث عن ملفات محرر التسجيل Pin
reemaziz31-Mar-13 6:13
reemaziz31-Mar-13 6:13 
AnswerRe: كيف البحث عن ملفات محرر التسجيل Pin
Kenneth Haugland31-Mar-13 6:49
mvaKenneth Haugland31-Mar-13 6:49 
AnswerRe: كيف البحث عن ملفات محرر التسجيل Pin
Richard MacCutchan31-Mar-13 8:02
mveRichard MacCutchan31-Mar-13 8:02 
Questioninsatling mssql server 2008r2 Pin
Ashbinsapkota31-Mar-13 5:39
Ashbinsapkota31-Mar-13 5:39 
AnswerRe: insatling mssql server 2008r2 Pin
Pete O'Hanlon31-Mar-13 5:52
mvePete O'Hanlon31-Mar-13 5:52 
AnswerRe: insatling mssql server 2008r2 Pin
Abhinav S31-Mar-13 22:40
Abhinav S31-Mar-13 22:40 
QuestionSqlDependency. Can't realize. Pin
Jeka Developer31-Mar-13 0:05
Jeka Developer31-Mar-13 0:05 
AnswerRe: SqlDependency. Can't realize. Pin
Eddy Vluggen31-Mar-13 0:31
professionalEddy Vluggen31-Mar-13 0:31 
GeneralRe: SqlDependency. Can't realize. Pin
Jeka Developer1-Apr-13 2:43
Jeka Developer1-Apr-13 2:43 
AnswerRe: SqlDependency. Can't realize. Pin
Eddy Vluggen1-Apr-13 2:55
professionalEddy Vluggen1-Apr-13 2:55 
GeneralRe: SqlDependency. Can't realize. Pin
Jeka Developer1-Apr-13 4:57
Jeka Developer1-Apr-13 4:57 
GeneralRe: SqlDependency. Can't realize. Pin
Eddy Vluggen1-Apr-13 11:41
professionalEddy Vluggen1-Apr-13 11:41 
GeneralRe: SqlDependency. Can't realize. Pin
Jeka Developer2-Apr-13 10:24
Jeka Developer2-Apr-13 10:24 
GeneralRe: SqlDependency. Can't realize. Pin
Eddy Vluggen3-Apr-13 6:52
professionalEddy Vluggen3-Apr-13 6:52 
Jeka Developer wrote:
I already done that=)

Color me surprised. Lots of companies attempt to build a framework that "automagically" updates the screen if "something" in the database changes. Most of them fail.

If it's an administration-package, then it's simply the wrong design. If you're building a visualization, then it might be the start of a working prototype. Either way, you can expect a whole lot of work before this works well enough to release it to >1000 customers.

Jeka Developer wrote:
I have 3 WCF services, that are subscribed with SqlDependency, but each service have its own clients(hundreds, thousands...). So Sql Server have only 3 clients(wcf services) but changes occurs very often=)

Three dependencies, does that mean monitoring three tables?

From your previous post, I gather that there's a lot of records in each table. It'd be costing a lot of resources if every client had to fetch the changes; hence the suggestion to create another server-app that holds those changes in memory. That way the client retrieves his/her dataset once (regardless of how/where you cache it) and gets the changes on that set from the new server-app.

Important note; you can't abuse the SqlDependency to monitor all tables and expect it to update thousands of clients. It's not an "OnChange" event on the record-level, nor will anything similar be implemented anytime soon.
Bastard Programmer from Hell Suspicious | :suss:
If you can't read my code, try converting it here[^]

AnswerRe: SqlDependency. Can't realize. Pin
jschell1-Apr-13 8:12
jschell1-Apr-13 8:12 
GeneralRe: SqlDependency. Can't realize. Pin
Jeka Developer2-Apr-13 10:26
Jeka Developer2-Apr-13 10:26 
QuestionSNMP Pin
Sahar.H30-Mar-13 22:05
Sahar.H30-Mar-13 22:05 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.