Hello David,

My suggestion for you is to visit http://msdn.microsoft.com/webservices/. There are tons of materials, including security, best
practices, architecture and design. I believe it could help you much in understanding and implementing your web service.

Thanks.

Best regards,
yhhuang
VS.NET, Visual C++
Microsoft

This posting is provided "AS IS" with no warranties, and confers no rights.
Got .Net?  http://www.gotdotnet.com
--------------------
!From: "David Waz..." <dlw@pickpro.com>
!Newsgroups: microsoft.public.dotnet.framework.aspnet
!Subject: WEB SERVICES book - opinion
!Lines: 9
!X-Priority: 3
!X-MSMail-Priority: Normal
!X-Newsreader: Microsoft Outlook Express 6.00.3790.0
!X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
!Message-ID: <TSDPa.176$dV1.95715443@newssvr11.news.prodigy.com>
!NNTP-Posting-Host: 65.23.4.76
!X-Complaints-To: abuse@prodigy.net
!X-Trace: newssvr11.news.prodigy.com 1057950259 ST000 65.23.4.76 (Fri, 11 Jul 2003 15:04:19 EDT)
!NNTP-Posting-Date: Fri, 11 Jul 2003 15:04:19 EDT
!Organization: SBC http://yahoo.sbc.com
!X-UserInfo1: FKPGG\[GTZRACP\Y@ZIZOFXBWR\HPCTL@XT^OBPLAH[\BQUBLNTC@AWZWDXZXQ[K
\FFSKCVM@F_N_DOBWVWG__LG@VVOIPLIGX\\BU_B@\P\PFX\B[APHTWAHDCKJF^NHD[YJAZMCY_CWG[SX\Y]
^KC\HSZRWSWKGAY_PC[BQ[BXAS\F\\@DMTLFZFUE@\VL
!Date: Fri, 11 Jul 2003 19:04:19 GMT
!Path: cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!newsfeed00.sul.t-online.de!t-online.de!newsfeed.icl.net!
newsfeed.fjserv.net!nntp.theplanet.net!inewsm1.nntp.theplanet.net!peer1.news.newnet.co.uk!peer1.news.newnet.co.uk!
cox.net!news-xfer.cox.net!in.100proofnews.com!in.100proofnews.com!prodigy.com!newsmst01.news.prodigy.com!
prodigy.com!postmaster.news.prodigy.com!newssvr11.news.prodigy.com.POSTED!not-for-mail
!Xref: cpmsftngxa06.phx.gbl microsoft.public.dotnet.framework.aspnet:158637
!X-Tomcat-NG: microsoft.public.dotnet.framework.aspnet
!
!I'm looking for a very good book on Web Serices
!NOT beginners stuff -
!Security
!State maintenance
!Implementation
!Best practices
!etc...
!
!
!

Hey Guys,

I have been struggling with this for few days. when i use

SqlCacheDependency sqlDependency=new
SqlCacheDependency("test","dbo.USStates");

where test is the name of connectionstring and dbo.USStates is the table
name everything works fine.

but when i use

using (SqlConnection conn=new SqlConnection(connectionString))

{

SqlCommand command = new SqlCommand("[dbo].[USStatesGet]", conn);

command.CommandType = CommandType.StoredProcedure;

SqlCacheDependency sqlDependency = new SqlCacheDependency(command);

}

HttpRuntime.Cache.Insert(cacheName, ds, sqlDependency,
Cache.NoAbsoluteExpiration,Cache.NoSlidingExpiration);

then the cache is not being invalidated when the values are changed in the
table

the following is the stored procedure i am using

set ANSI_NULLS ON

set QUOTED_IDENTIFIER ON

GO

ALTER PROCEDURE [dbo].[USStatesGet]

-- Add the parameters for the stored procedure here

AS

BEGIN

--SET NOCOUNT OFF;

SELECT [stateid]

,[statename]

FROM [dbo].[USStates]

END

Thanks in Advance

Param