Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
HomeAnnouncementsFree MagazinesWhite PapersSubmit Content
Discussion GroupsASP.NETWindows FormsLanguages.NET FrameworkVisual Studio.NET
Articles.NET FrameworkASP.NETToolsWindows Forms
.NET DirectoryOpen Source ProjectsUser GroupsWeb Resources
Related Topics
Visual Basic 6SQL ServerMS AccessOther DB ProductsMS Server ProductsMore Topics ...

.NET Forum / .NET Framework / ADO.NET / April 2006

Tip: Looking for answers? Try searching our database.

SqlDependency - Options and Timeout

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Gidion - 16 Apr 2006 18:43 GMT
Hi,

I'm using SqlDependency quite a lot and really love it, but there are
two things I just can't seem to find anywhere on MSDN or elsewhere.

1. One of the SqlDependency constructors, allows you to pass a "string
options", which sounds great. But IntelliSense on this item is useless
and just points to SqlNotificationInfo.Options which says nothing.
I would be interested in knowing what to pass into that string and
which format it has to have.

2. The reason I'm trying to find that out, is the time-out. I've read
here
(http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnvs05/html/que
rynotification.asp
)
that I am informed if my dependency time-out. (Either using the server
default or the value I passed to the constructor.) But it's not
happening. I tested using the server default and a value of 10s. I just
waited to see what happened and never got a notification. If I then
changed the data (with the app still running) the app didn't get
notified, because the dependency had already timed-out. Is this a bug
or am doing something wrong?

I really would appreciate any answers or suggestions!
Thanks,
Alex
Mary Chipman [MSFT] - 23 Apr 2006 00:49 GMT
The options enumerations are described here:
http://msdn2.microsoft.com/en-us/library/system.data.sqlclient.sqlnotificationin
fo.aspx


If this doesn't help, let me know. Things have changed significantly
since the article you refer to was written.

--Mary

>Hi,
>
[quoted text clipped - 21 lines]
>Thanks,
>Alex

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...

Oracle MagazineNetwork ComputingComputer WorldBio-IT WorldeWeekInformation WeekInfosecurity
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.