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

Jim Lawrence accessd at shaw.ca
Wed Jun 10 13:10:29 CDT 2009


Hi Shamil:

I have never had an issue with ADO.Net technology... but it will be a while
before I can claim professional competence in the product but I believe it
is going the right way... that is browser based.

My only apprehension is not being able to deliver a web-based service
because a client or completely unknown customer is either using the 'wrong'
OS, browser to deliver/receive services or is simply not patch up enough.

I am starting to see a number of web sites that have been 'blocked' because
they are not using the right version of browser IE7 and not IE8 or FF or
Chrome etc... or do not have the appropriate technology installed on their
desktop.

I have been unable to get some of the Silver-light based code running on
some of my systems even though I have the latest version of Framework and
Silver installed. XP and Vista and even Window7 seem be fine but Server2003
and Server2008 are another matter... and of course Linux/Mac even running FF
are toast.

I have starting to see the marrying of browser and desktop and personally I
feel we should be going in the other direction. More loose binding.

I agree with you completely about the MS tools and most clients are using MS
desktops. In this area, the government and well as the military and local
university/colleges are Oracle/Java. My experiences with project bids have
been quite different. After spending a month developing proof of concept,
proving that MS SQL was a superior product, easier to deploy and at 50% of
the cost of Oracle... the bid was lost on only one point... it wasn't
standard.    

Maybe these tight times will encourage IT managers to take another look at
MS SQL.
 
Sorry for going on but some comments seem to need a response.

Jim
 
  
-----Original Message-----
From: dba-vb-bounces at databaseadvisors.com
[mailto:dba-vb-bounces at databaseadvisors.com] On Behalf Of Salakhetdinov
Shamil
Sent: Tuesday, June 09, 2009 1:43 PM
To: dba-VB
Subject: Re: [dba-VB] Problem while publishing ADO.NET Data Service...

Hi Jim,

I'm working for money here - the main purpose for me to learn new MS
technologies is to get a competetive advantage, not fun...

As far as I see ADO.NET Entity Framework and ADO.NET Data Services are
becoming a kind of "ODBC for 2010ies" - this is an emerging technology but
it's getting all the main database technology players embraced already:

http://msdn.microsoft.com/en-us/data/dd363565.aspx

And Silverlight is targeted not only for Windows but for Mac and Linux
also...

And I'm not going "to marry my customers to me" because of using MS
technologies - the fact is that there are a lot of competing providers in my
area of software development...

As for Oracle, PHP, Linux - I have never had opportunity to work using them
as it wasn't requested by my customers but a couple of times I have had
opportunity to directly compete with other companies who used Oracle for the
same customer - both times they were "beaten" by my and my colleagues
services, and our "forces" were usually several times less - one time it was
2 developers/consultants against a company having stuff of 100+
developers/consultants...

MS tools are becoming really mature these days, and if properly applied they
allow to "make wonders" even on moderate hardware...

> 4. The trend is towards 'portability' on cross-platform environments.
In my opinion, nowadays customers first of all need working software ASAP -
and MS development tools help to satisfy those needs/market demands. And I'm
not trying to embrace the whole software development market - I mean custom
software development - business applicationx for small-/middle-size
businesses - here MS tools fit very well IMO - just IMO...

Thank you.

--
Shamil


-----Original Message-----
From: "Jim Lawrence" <accessd at shaw.ca>
To: "'Salakhetdinov Shamil'" <mcp2004 at mail.ru>,"'Discussion concerning
Visual Basic and related programming issues.'" <dba-vb at databaseadvisors.com>
Date: Sun, 7 Jun 2009 09:54:42 -0700
Subject: RE: [dba-VB]	Problem while publishing ADO.NET Data Service...

> Hi Shamil:
> 
> I have been watching this thread for a bit and was wondering, if
proceeding
> along this direction is in fact tying the designers and users to a very
> proprietary desktop and set of BE services?
> 
> Just to get much of the apps running requires the very latest patches and
> specific downloads, products that are not integrated into the default
> Windows OS. Only the most carefully managed office location would be able
to
> even run this technology. 
> 
> From my point of view the following is the reality:
> 1. On most sites I am just the contractor and not as the head IT guy.
> 2. Clients want to hire me not marry me.
> 3. Many sites using 'mixed' desktops (Windows/Mac/Linux).
> 4. The trend is towards 'portability' on cross-platform environments.
> 
> On the other hand, this is all great fun technology and I have been very
> much enjoying this thread.
> 
> Jim
> 
> -----Original Message-----
> From: dba-vb-bounces at databaseadvisors.com
> [mailto:dba-vb-bounces at databaseadvisors.com] On Behalf Of Salakhetdinov
> Shamil
> Sent: Friday, June 05, 2009 3:53 PM
> To: Discussion concerning Visual Basic and related programming issues.
> Subject: Re: [dba-VB] Problem while publishing ADO.NET Data Service...
> 
> Hi All,
> 
> I have found a good sample to consume ADO.NET Data Services using
> SIlverLight 2.0 - here it's:
> 
> Using Silverlight 2 With ADO.NET Data Services
> 
> http://msdn.microsoft.com/en-us/magazine/dd569758.aspx
> 
> I will try to make something like that live tomorrow - time to sleep here.
> 
> 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: Sat, 06 Jun 2009 02:27:22 +0400
> Subject: Re: [dba-VB]
> Problem while publishing ADO.NET Data Service...
> 
> > Hi All,
> > 
> > I have got my SilverLight sample working:
> > 
> > http://shamils-4.hosting.parking.ru/sl/NWNetSilverlight.aspx
> > 
> > it uses hardcoded Shipper sample table's data.
> > 
> > Then I tried to "feed" my Silverlight sample form by using the following
> ADO.NET Data Service:
> > 
> > http://shamils-4.hosting.parking.ru/NorthwindNetDataService/NWNetDS.svc
> > 
> > with code like that (which works well in C# console app):
> > 
> > using System;
> > using System.Collections.Generic;
> > 
> > using System.Data.Services.Client;
> > using System.ComponentModel;  
> > 
> > namespace ResearchAndDevelopment.Console
> > {
> >     public class Shippers
> >     {
> >         public class Shipper
> >         {
> >             public int ID { get; set; }
> >             public string Name { get; set; }
> >             public string Phone { get; set; }
> >             public byte[] RowTimeStamp { get; set; }
> >         }
> > 
> >         private static Uri dataServiceURI =
> >              new
>
Uri(@"http://shamils-4.hosting.parking.ru/NorthwindNetDataService/NWNetDS.sv
> c");
> >         public static void ListShippers()
> >         {
> >             DataServiceContext ctx =
> >                 new DataServiceContext(dataServiceURI);
> >             IEnumerable<Shipper> shippers = ctx.Execute<Shipper>(
> >                   new Uri("Shipper?$orderby=ID", UriKind.Relative));
> >             foreach (Shipper s in shippers)
> >             {
> >                 System.Console.WriteLine("{0}. {1}", s.ID, s.Name);
> >             }
> >         }
> >     }
> > }
> > 
> > But I have found that SilverLight 2.0 doesn't support ADO.NET Data
> Services "out-of-the-box" as straightforward as the above sample code.
This
> sample code doesn't even compile for SilverLight projects because those
> projects can't be used with .NET Framework 3.5. 
> > 
> > Therefore I'm currently stuck in feeding my SilverLight 2.0 sample with
> ADO.NET Data Services (.NET 3.5 SP1) ATOM feed. 
> > 
> > Do you have any samples' references explaining how to get ADO.NET Data
> Services Data into SilverLight 2.0 - the most straightforward way?
> > 
> > Thank you.
> > 
> > --
> > Shamil
> > 
> > 
> > 
> > -----Original Message-----
> > From: Salakhetdinov Shamil <mcp2004 at mail.ru>
> > To: Mark Breen <marklbreen at gmail.com>
> > Date: Fri, 05 Jun 2009 15:26:41 +0400
> > Subject: Re: [dba-VB]
> > Problem while publishing ADO.NET Data Service...
> > 
> > > Hi Mark,
> > > 
> > > I'd add/outline additionally to my previous answer on your posting
that
> ADO.NET Data Services can be used in heavily distributed workflow
> scenarious, with support of distributed transactions etc.etc. Workflows
are
> designed and programmed for such applications using Windows Workflow
> Foundation (WF). "Not data" services are developed using Windows
> Communication Foundation (WCF) (and ADO.NET data services are also driven
by
> WCF services AFAIU)...
> > > 
> > > --
> > > 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-silv
> erlight/
> > > > > >
> > > > > > 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
> > > > >
> > > > >
> > > > 
> > > > 
> > > 
> > > _______________________________________________
> > > 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
> > 
> 
> _______________________________________________
> 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