Re: Data Access...

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

Ty Salistean <tsaliste@xxxxxxxxx> wrote:
> > > > Well yes, but there are also plenty of apps which save data but don't
> > > > need to use a database. Most word processors don't have databases in
> > > > them, for example...
>
> I assume people read things in the context of the subject. Since this post
> originally had to deal with DATA ACCESS lets talk in terms of DATA ACCESS.
> So if you do not access data, then please do not respond.

Your original post didn't qualify it at all though. It expressed
surprise at the fact that people have programmed in .NET without
knowing SQL - not .NET which access databases, just .NET.

Have another look at your original post and see whether you don't think
it's a bit overdone.

> It would be nice if we could get an ANSI standard SQL compliant way to
> manipulate data, for those people that need to manipulate data in
> datatables/datasets.

I agree it's a nice to have. I just disagree that it's vital.

> > I don't see your point. I was offering a much more straightforward
> > solution to the problem - one which would give a similar amount of
> > power, making things easier in some cases and harder in others. It
> > would not only be easier to implement, but much cheaper in terms of
> > space, so it could be available on space-limited devices.
>
> My point was that RDO, DAO, and ADO took *alot* of resources and they still
> suck. What was the main problem with them? Data manipulation, navigation,
> etc... I think it is time to address the real issues...

And callbacks would address many of those issues, IMO, in a far cheaper
way.

> > SQL wouldn't accommodate everyone to start with. There are many things
> > which are hard to express in SQL but easy to express programmatically.
> > Consider a data table which doesn't just store strings, numbers etc,
> > but rich objects - how would you access those in ANSI SQL?
>
> The same way SQL Server and every other SQL compliant database handles it.

I thought SQL wasn't designed around a rich object model though. How do
you call a method on an object in SQL (rather than a function)? How do
you get at the properties of an object? Does SQL even mention objects,
rather than specific predefined datatypes?

> Using the ANSI standard is a better soution, to me. I am sick of buying and
> learning 3rd party tools. I want enterprise tools out of the box. I can
> choose to use those tools or not.

What difference does it make whether it's 3rd party or from MS? Given
that you've said it should be optional anyway, what does it matter who
provides it?

> It would take more time to get a SQL engine plugged into .NET than your
> solution. But then things, like adding a row(s) to a datatable would not be
> so cryptic or updating a row(s) would be auto-magical. How cool would that
> be?

I don't find adding rows to be cryptic anyway, personally...

--
Jon Skeet - <skeet@xxxxxxxxx>
http://www.pobox.com/~skeet
If replying to the group, please do not mail me too
.

Relevant Pages

  • Re: SQL CE 3 and CF 1.0 support
    ... > We have designed our application so that all data access logic is ... > using our automated upgrade mechanism and at the same time upgrade the ... > from the engine download and the database upgrade delay). ... > I also know of applications that have been using SQL CE databases in RAM ...
    (microsoft.public.sqlserver.ce)
  • Three Tier Access Database page
    ... Data Access Pages on the Internet or Your Intranet". ... ;[sql default] will modify the Sql if name is not found ... ;If we want to disable unknown connect values, we set Access to ... [connect CustomerDatabase] ...
    (microsoft.public.access.dataaccess.pages)
  • Re: Database Application Example
    ... SQL database and although it is working fine I'm not sure I'm going about it in the best way. ... If you abstract the form from the data access, then it shouldn't matter what the form Web or Windows is being used. ... The UI uses a business layer object to access the data access layer object. ... click 'Design Patterns Bootcamp: Model View * Patterns* ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Question about Datasets and ASP.NET
    ... SQL server? ... Some features or products Microsoft gives developers to use ... data access and retrain them, because data binding is all they knew. ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Jet SQL vs. standard SQL
    ... Most of the Jet extensions to ANSI SQL were included in the ... Any ANSI standard db engine should accept ...
    (microsoft.public.access.queries)