[dba-VB] Problem while publishing ADO.NET Data Service...

Salakhetdinov Shamil mcp2004 at mail.ru
Fri Jun 5 05:59:21 CDT 2009


Hello Mark,

Thank you for your proposal. Yes, it would be useful to test using your servers in the case my hosting site would not be able to "keep the pressure" of coming data requests, and in the scenarious when several servers would need to communicate - something like distributed workflow (using WF).

BTW, my sample site works OK now:

Here is a "query" to retrieve Shippers. 

http://shamils-4.hosting.parking.ru/NorthwindNetDataService/NWNetDS.svc/Shipper

and this one for Categories

http://shamils-4.hosting.parking.ru/NorthwindNetDataService/NWNetDS.svc/Category

Note: those queries return ATOM feed therefore ATOM feed interpretation should be switched off in your browser.

Such queries can be used to do all the data manipulation including CRUD operations AFAIU. I haven't yet checked/read how to make such quieries secure but I assume that this feature is implemented already, and I need just to switch it on. The returned data can be of different structure ATOM feed, JSON etc. - and they can be consumed by many types of clients including AJAX (KavaScript) etc.

In other words once you get ADO.NET data Service published (no any programming was needed in my simple sample case) you can immediatley start developing custom applications/clients.

As for performance - it should be good enough I expect - at least for business areas and the applications we develop. AFAIU ADO.NET Data Services internals can be fine tuned for special case to increase response time.

We can test performance - we can write test clients and run them on our PCs querying the above sample service or the one you can install on your server - to compare response time from public ASP.NET hosting site I use or dedicated servers you have - I plan to publish this sample service on our CodePlex Northwind project area...

Is ADO.NET Data Services the future? - that's is the question to MS - I do not have a Crystal Ball :)

For sure it's very useful and promising technology. 

Thank you.

--
Shamil


-----Original Message-----
From: Mark Breen <marklbreen at gmail.com>
To: Salakhetdinov Shamil <mcp2004 at mail.ru>, "Discussion concerning Visual Basic and related programming issues." <dba-vb at databaseadvisors.com>
Date: Fri, 5 Jun 2009 09:10:10 +0100
Subject: Re: [dba-VB] Problem while publishing ADO.NET Data Service...

> Hello Shamil,
> as you know, I have two servers here in Ireland, would you like to do your
> diagnosis / development of future development work on one of my servers ?
>  If so, that would be no problem.
> 
> I am trying to keep up and read some of the link you posted int he last few
> days regarding  ADO.NET Data Service.
> 
> I am not clear yet about differences between Webservices and  ADO.NET Data
> Service , but I expect if I spend some time to google and read, I can become
> clear.
> 
> However, I  have one question, do you think that this archetectire is
> without doubt the way we will all connect to our data sources in the future?
>  How about performance, will it perform as good as current connections such
> as ado and odbc over SQL Server Port?
> 
> thanks
> 
> Mark
> 
> 
> 
> 2009/6/5 Salakhetdinov Shamil <mcp2004 at mail.ru>
> 
> >
> > Hi All,
> >
> > Just wanted to ask one more question on subject issue: I do not understand
> > why IIS should be restarted to have one of its Web Site's getting a new
> > setting activated? I mean why it's not enough to stop and start this web
> > site/web application? What am I missing?
> >
> > You can see by goodling how many developers got confused by this
> > "simple"(?) issue - and even stackoverflow doesn't have a clear answer, or
> > am I missing it?
> >
> > Thank you.
> >
> > --
> > Shamil
> >
> > -----Original Message-----
> > From: Salakhetdinov Shamil <mcp2004 at mail.ru>
> > To: "Discussion concerning Visual Basic and related programming issues."<
> > dba-vb at databaseadvisors.com>
> > Date: Fri, 05 Jun 2009 02:48:38 +0400
> > Subject: Re: [dba-VB]
> > Problem while publishing ADO.NET Data Service...
> >
> > > Hi All,
> > >
> > > I have got found one solution for the subject issue:
> > >
> > > Hosted ADO.NET Data Services & Silverlight
> > >
> > http://dvanderboom.wordpress.com/2009/01/07/hosted-adonet-data-services-silverlight/
> > >
> > > But it doesn't look satisfactory for general case, and it doesn't work
> > yet for my site (waiting for ISP support with IIS server restart - maybe
> > that helps as web site restarting doesn't work) - I have got stuck here:
> > >
> > > http://shamils-4.hosting.parking.ru/NorthwindNetDataService/NWNetDS.svc
> > >
> > > with a message:
> > > <<<
> > > IIS specified authentication schemes 'Basic, Anonymous', but the binding
> > only supports specification of exactly one authentication scheme. Valid
> > authentication schemes are Digest, Negotiate, NTLM, Basic, or Anonymous.
> > Change the IIS settings so that only a single authentication scheme is used.
> > > >>>
> > >
> > > and as you can see SOAP and WCF sample services do work OK here:
> > >
> > >
> > http://shamils-4.hosting.parking.ru/NorthwindNetDataService/SOAPService.asmx
> > >
> > >
> > http://shamils-4.hosting.parking.ru/NorthwindNetDataService/WCFService.svc
> > >
> > > If you know general solution for subject issue that woudl be very
> > helpful.
> > >
> > > Thank you.
> > >
> > > --
> > > Shamil
> > >
> > > -----Original Message-----
> > > From: Salakhetdinov Shamil <mcp2004 at mail.ru>
> > > To: "Discussion concerning Visual Basic and related programming issues."<
> > dba-vb at databaseadvisors.com>
> > > Date: Thu, 04 Jun 2009 23:06:18 +0400
> > > Subject: Re: [dba-VB]
> > > Problem while publishing ADO.NET Data Service...
> > >
> > > > Hi All,
> > > >
> > > > I have changed location of NorthwindNety Data Service to:
> > > >
> > > >
> > http://shamils-4.hosting.parking.ru/NorthwindNetDataService/NWNetDS.svc
> > > >
> > > > still no solution for
> > > >
> > > > This collection already contains an address with scheme http.  There
> > can be at most one address per scheme in this collection.
> > > > Parameter name: item
> > > >
> > > > :(
> > > >
> > > > --
> > > > Shamil
> > > >
> > > ><<< aaa >>>
> > > _______________________________________________
> > > dba-VB mailing list
> > > dba-VB at databaseadvisors.com
> > > http://databaseadvisors.com/mailman/listinfo/dba-vb
> > > http://www.databaseadvisors.com
> > >
> >
> > _______________________________________________
> > dba-VB mailing list
> > dba-VB at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/dba-vb
> > http://www.databaseadvisors.com
> >
> >
> 
> 




More information about the dba-VB mailing list