Re: Data Access...

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Unbelievable!!! Excellent post. That is exactly what I was looking for.

Looks like that person has it only in beta and only handles SELECT's. Maybe
M$ can buy this product and put it in the next VS.NET. Thanks for the
info...

"Sylvain Lafontaine" <sylvain aei ca (fill the blanks, no spam please)>
wrote in message news:Orvh4oHbFHA.1600@xxxxxxxxxxxxxxxxxxxxxxx
> Well, someone else has tought about it:
> http://www.queryadataset.com/
>
> --
> Sylvain Lafontaine, ing.
> MVP - Technologies Virtual-PC
> E-mail: http://cerbermail.com/?QugbLEWINF
>
>
> "Ty Salistean" <tsaliste@xxxxxxxxx> wrote in message
> news:%23u6nJaFbFHA.2876@xxxxxxxxxxxxxxxxxxxxxxx
> > Why can't M$ allow .NET developers to run ANSI standard SQL queries on
> > ADO.NET datatables/datasets (SELECT, INSERT, UPDATE, DELETE)?
> >
> > This will allow other developers to learn ANSI syntax and be able to
> > utilize
> > SQL Server without much learning curve. I bet there are people out
there
> > that have programmed in .NET but have NEVER written a SQL SELECT
> > statement.
> > That is scary!!
> >
> > The ability to requery data on the client is an essential tool for every
> > developer, unless you never save your data. They do give you dataviews,
> > but
> > you cannot do a DISTINCT listing on those. They only give you the
ability
> > to order data (SET ORDER TO), filter data (SET FILTER TO), and some
> > others...
> >
> > HEY M$ - WE NEED TO MANIPULATE DATA ON OTHER PLACES BEYOND STORED
> > PROCEDURES!!!!!!! THAT IS KEY TO OUR JOB!!!!!
> >
> >
>
>


.

Relevant Pages

  • Data Access...
    ... Why can't M$ allow .NET developers to run ANSI standard SQL queries on ... This will allow other developers to learn ANSI syntax and be able to utilize ... SQL Server without much learning curve. ...
    (microsoft.public.dotnet.framework)
  • Re: Files created when we run Embedded SQL
    ... That option ensures there is no ability for reuse of cursors in the job for that program. ... No matter what, when the service is actively processing, the lock is held; i.e. the conflict exists even w/out pseudo-closed, so the ability to both stop the service and prevent new requests is an effective requirement to avoid the conflict alluded to as origin for wanting to close the files.? ... It would be better to be able to provide the ability to ask the service to either close down the activation group or remove the lock ... QASQRESL is the /routine resolution/ file which is opened and tracked in static storage for the job; i.e. once open, it remains open for the performance benefit, for future function and procedure name resolution activity for SQL processing. ...
    (comp.sys.ibm.as400.misc)
  • Re: crash on virtual dimensions
    ... SQL authentication doesn't work for SQL Server to anywhere. ... It is basically a way for access developers to start writing all of their ...
    (microsoft.public.sqlserver.olap)
  • Re: Opinions on 3rd party code generators?
    ... The high level documentation appears to suggest they're ... How had is it to write Select InvoiceID, ... They claim you don't need to know SQL to use their tools. ... developers don't understand SQL. ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Profiler Security
    ... > development point of view alot of companies need to give ... > want to assign the developers the sys admin sql role. ... Why can't Profiler run without logging in as Admin? ...
    (microsoft.public.sqlserver.security)