Re: Querying a DataSet/DataTable in .NET

I don't think it's the same thing.

The goal of .NET is to provide tools so that you could write the program you
really need to, even if it means more work. So you have basic tools that you
can use and put together for more advanced tasks. There are a lot of basic
tools, and most of us only use a small subset of them.

But that means there are not too many more advanced tools, which is what you
are looking for.

I just don't think you can compare a data-adapter, which is a pretty basic
data manipulation mechanism, to writing an in-memory database engine.

"Ty Salistean" <TySalistean@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:30C24DB9-CBEB-4DF1-8741-74A123B7B7CF@xxxxxxxxxxxxxxxx
>I understand your point.
>
> But every .NET developer has access to a DataAdapter but may never use it.
> This can be the same type of thing - it is available if you need it. This
> is
> just a suggestion as to how M$ can make their data handling better for
> people
> that handle these types of apps.
>
> Thanks for the post...
>
> "Marina" wrote:
>
>> When a technology is developed for writing very specific types of
>> applications, then this can be done.
>>
>> ..NET can be used to program anything - video games, database access
>> programs, etc. So it really becomes harder to provide features to
>> accomodate
>> everyone who may be writing anything. You may need this feature, someone
>> else may really need something else, etc.
>>
>> "Ty Salistean" <TySalistean@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
>> news:576D5923-7967-4B40-9BC6-F7595E28056E@xxxxxxxxxxxxxxxx
>> >I think it would be nice if we could have a SQL engine available on the
>> > client side. I primarily do Windows Forms programming and it seems
>> > that I
>> > have to make alot of calls accross the wire to manipulate data for
>> > display
>> > purposes.
>> >
>> > I am a FoxPro guy but I have been in .NET for 1 year now. We have an
>> > application in FoxPro hitting SQL Server and I think that system is
>> > architected well. If I have a screen that requires the data to be
>> > displayed
>> > in a certain way that is completly different than how the data is
>> > stored,
>> > I
>> > think that information should be generated client side - since it is a
>> > for
>> > display only (I could put it in business objects so I can reuse the
>> > same
>> > display in a different client). Either way - it is a display item.
>> >
>> > I need to do this in a SQL SP for .NET. I feel by placing this logic
>> > in a
>> > SQL SP, I am moving that logic to a 'procedural' based smart database.
>> > I
>> > have a problem with that. This just does not seem productive to me.
>> > If I
>> > switch my database, alot of my business logic will need to be
>> > rewritten...
>> >
>> > How do we get M$ ear to ask for this? I think FoxPro got it right on
>> > this
>> > topic...hopefully .NET will follow.
>>
>>
>>


.

Relevant Pages

  • Re: Querying a DataSet/DataTable in .NET
    ... everyone who may be writing anything. ... >I think it would be nice if we could have a SQL engine available on the ... > have to make alot of calls accross the wire to manipulate data for display ... > I am a FoxPro guy but I have been in .NET for 1 year now. ...
    (microsoft.public.dotnet.general)
  • Re: Native exception 0xc0000005 when using SQLCE and .NET CF 2.0?!
    ... Try to check out this article by Joao Paulo Figueira entitled "SQL Compact ... doesn't matter whether the database is empty or not when the test is ... SqlCeEngine sqlEngine = new SqlCeEngine( ... // Display all error messages ...
    (microsoft.public.sqlserver.ce)
  • Increment & back page
    ... I have a database and a webpage with a table view linked to a formview to ... I would like to be able to display the number of times a particular record ... Is there an easy way of incrementing a value with SQL code or do I need to ...
    (microsoft.public.dotnet.framework.aspnet.webservices)
  • Re: Is there a way to keep the StreamWriter open?
    ... Are you suggesting that using the same hardware but with good SQL configuration I can expect the same speed writing transactionally to SQL that I can writing to a text file with some decient programming wrapped around it? ... They do not have to be solved in the same database. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Treating NULL database values in classes and Form fields.
    ... A Null in SQL means in fact unused. ... When I read numeric data from a database into a class object and then ... my application the associated Form fields should then display nothing ...
    (microsoft.public.vb.general.discussion)