Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

ADO.Net technology vs DW.net technology

3 posts in DataWindow .NET Last posting was on 2004-10-21 00:12:20.0Z
Simon Blais Posted on 2004-10-19 21:45:41.0Z
From: Simon Blais <sblais@REMOVETHISpgmensys.com>
Newsgroups: sybase.public.datawindow.net
Subject: ADO.Net technology vs DW.net technology
Organization: PG Mensys Systemes d'Information inc.
Message-ID: <h9ran0lflcsiv7j7tif060m1o92rvug7n1@4ax.com>
X-Newsreader: Forte Free Agent 1.93/32.576 English (American)
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: user11.pgsystem.com
X-Original-NNTP-Posting-Host: user11.pgsystem.com
Date: 19 Oct 2004 14:45:41 -0700
X-Trace: forums-1-dub 1098222341 142.169.224.21 (19 Oct 2004 14:45:41 -0700)
X-Original-Trace: 19 Oct 2004 14:45:41 -0700, user11.pgsystem.com
Lines: 36
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.datawindow.net:560
Article PK: 124986

Hi!

We are starting a new development cycle in .Net and we are currently
working on the standards we should use in our development. We are
studying the possibility to use the Datawindow.Net.

My question is: is it a good idea to use the Datawindow all over our
new apps? What are the pros and cons of using DW.Net instead of the
datasets and databinding in ADO.net?

We have been using PowerBuilder since 1996 and use the Datawindow a
lot. We now use PB8 and will probably migrate to PB10 or 11 next year.

First, some background: We will build our new architecture around
business classes in which we will hide the way we access data. For
example, if my user interface wants to display data, it will use an
instance of a class and get the data it needs from properties of the
class. The interface will never know which technology is used to
access the database, whether it is ADO.Net or the DW.Net.

There is no plan to reuse our current development in the new apps but
I expect that with tight schedules and the current knowledge about the
DW technology, this possibility will occur. But I don't think this
reason is enough to justify an extended use of DW.net.

We plan to support Oracle9i, SQLServer 2000 and probably Access as
back-end databases. At first, I thought that was a big pro for the DW
but after giving a second thought, since we usually try to build
database-independant queries, I am not so sure anymore.

So I call to all of you out there to get another point of view on that
matter. All questions or comments, good or bad, will be welcome.

Thanks a lot!

Simon.


upscale Posted on 2004-10-20 13:46:35.0Z
From: "upscale" <up@scale.com>
Newsgroups: sybase.public.datawindow.net
References: <h9ran0lflcsiv7j7tif060m1o92rvug7n1@4ax.com>
Subject: Re: ADO.Net technology vs DW.net technology
Lines: 56
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
X-RFC2646: Format=Flowed; Original
X-Original-NNTP-Posting-Host: 12.32.34.2
Message-ID: <41766c37$1@forums-2-dub>
X-Original-Trace: 20 Oct 2004 06:46:31 -0700, 12.32.34.2
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 20 Oct 2004 06:46:32 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 20 Oct 2004 06:46:35 -0700
X-Trace: forums-1-dub 1098279995 10.22.108.75 (20 Oct 2004 06:46:35 -0700)
X-Original-Trace: 20 Oct 2004 06:46:35 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.datawindow.net:563
Article PK: 124990

Simon,

A few points,

- DW.NET 2.0 will use the ADO.NET dataset so you won't be limiting yourself
by using DW.NET
- a DW.NET is not bound to a particular brand of database until you bind the
DW control to a connection. (This is assuming you write your SQL statements
in an ANSI SQL manner.)
- don't forget all the good things about the datawindow. It's still the
most powerfull tool of it's kind for presentation and ease of use.

My advice is to make two competing small prototypes with and without DW.NET
and compare.

"Simon Blais" <sblais@REMOVETHISpgmensys.com> wrote in message
news:h9ran0lflcsiv7j7tif060m1o92rvug7n1@4ax.com...
> Hi!
>
> We are starting a new development cycle in .Net and we are currently
> working on the standards we should use in our development. We are
> studying the possibility to use the Datawindow.Net.
>
> My question is: is it a good idea to use the Datawindow all over our
> new apps? What are the pros and cons of using DW.Net instead of the
> datasets and databinding in ADO.net?
>
> We have been using PowerBuilder since 1996 and use the Datawindow a
> lot. We now use PB8 and will probably migrate to PB10 or 11 next year.
>
> First, some background: We will build our new architecture around
> business classes in which we will hide the way we access data. For
> example, if my user interface wants to display data, it will use an
> instance of a class and get the data it needs from properties of the
> class. The interface will never know which technology is used to
> access the database, whether it is ADO.Net or the DW.Net.
>
> There is no plan to reuse our current development in the new apps but
> I expect that with tight schedules and the current knowledge about the
> DW technology, this possibility will occur. But I don't think this
> reason is enough to justify an extended use of DW.net.
>
> We plan to support Oracle9i, SQLServer 2000 and probably Access as
> back-end databases. At first, I thought that was a big pro for the DW
> but after giving a second thought, since we usually try to build
> database-independant queries, I am not so sure anymore.
>
> So I call to all of you out there to get another point of view on that
> matter. All questions or comments, good or bad, will be welcome.
>
> Thanks a lot!
>
> Simon.


Bruce Armstrong [TeamSybase] Posted on 2004-10-21 00:12:20.0Z
From: "Bruce Armstrong [TeamSybase]" <NOCANSPAM_bruce.armstrong@teamsybase.com>
Newsgroups: sybase.public.datawindow.net
Subject: Re: ADO.Net technology vs DW.net technology
Organization: TeamSybase
Reply-To: NOCANSPAM_bruce.armstrong@teamsybase.com
Message-ID: <jlvdn0hr08947fb5ivf1lj6le5f2uefrkq@4ax.com>
References: <h9ran0lflcsiv7j7tif060m1o92rvug7n1@4ax.com> <41766c37$1@forums-2-dub>
X-Newsreader: Forte Agent 2.0/32.652
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 68-190-226-38.la-cbi.charterpipeline.net
X-Original-NNTP-Posting-Host: 68-190-226-38.la-cbi.charterpipeline.net
Date: 20 Oct 2004 17:12:20 -0700
X-Trace: forums-1-dub 1098317540 68.190.226.38 (20 Oct 2004 17:12:20 -0700)
X-Original-Trace: 20 Oct 2004 17:12:20 -0700, 68-190-226-38.la-cbi.charterpipeline.net
Lines: 108
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.datawindow.net:569
Article PK: 124996

And then if you ever get into datagrids, I'd offer this:

http://www.syncfusion.com/FAQ/WinForms/FAQ_c44c.asp#q1076q

Just run down some of the Q&A and you'll see where the datagrid can be
particularly frustrating to accomplish things that are rather quite
simple with a datawindow.

On 20 Oct 2004 06:46:35 -0700, "upscale" <up@scale.com> wrote:

>Simon,
>
>A few points,
>
>- DW.NET 2.0 will use the ADO.NET dataset so you won't be limiting yourself
>by using DW.NET
>- a DW.NET is not bound to a particular brand of database until you bind the
>DW control to a connection. (This is assuming you write your SQL statements
>in an ANSI SQL manner.)
>- don't forget all the good things about the datawindow. It's still the
>most powerfull tool of it's kind for presentation and ease of use.
>
>My advice is to make two competing small prototypes with and without DW.NET
>and compare.
>
>
>"Simon Blais" <sblais@REMOVETHISpgmensys.com> wrote in message
>news:h9ran0lflcsiv7j7tif060m1o92rvug7n1@4ax.com...
>> Hi!
>>
>> We are starting a new development cycle in .Net and we are currently
>> working on the standards we should use in our development. We are
>> studying the possibility to use the Datawindow.Net.
>>
>> My question is: is it a good idea to use the Datawindow all over our
>> new apps? What are the pros and cons of using DW.Net instead of the
>> datasets and databinding in ADO.net?
>>
>> We have been using PowerBuilder since 1996 and use the Datawindow a
>> lot. We now use PB8 and will probably migrate to PB10 or 11 next year.
>>
>> First, some background: We will build our new architecture around
>> business classes in which we will hide the way we access data. For
>> example, if my user interface wants to display data, it will use an
>> instance of a class and get the data it needs from properties of the
>> class. The interface will never know which technology is used to
>> access the database, whether it is ADO.Net or the DW.Net.
>>
>> There is no plan to reuse our current development in the new apps but
>> I expect that with tight schedules and the current knowledge about the
>> DW technology, this possibility will occur. But I don't think this
>> reason is enough to justify an extended use of DW.net.
>>
>> We plan to support Oracle9i, SQLServer 2000 and probably Access as
>> back-end databases. At first, I thought that was a big pro for the DW
>> but after giving a second thought, since we usually try to build
>> database-independant queries, I am not so sure anymore.
>>
>> So I call to all of you out there to get another point of view on that
>> matter. All questions or comments, good or bad, will be welcome.
>>
>> Thanks a lot!
>>
>> Simon.
>

Bruce Armstrong [TeamSybase]
http://www.teamsybase.com

TeamSybase blogs:
http://www.teamsybase.net/blogs

Two 3rd party books on developing with PowerBuilder
http://www.pb9books.com?source=newsgroups

Need code sample? Check out CodeXchange:
http://www.codexchange.sybase.com

Preach the gospel at all times. If necessary, use words. - Francis of Assisi
http://www.needhim.org

---------------------------------------------------------------------
NOTE:

If you are using Google to post messages to the newsgroups, you will
*not* receive a reply. Messages posted through Google never reach the
Sybase newsgroup server, so we don't see them in order to respond to
them. You should post your question using a standard newsgroup reader
or the web based newsreaders at my.sybase.com or www.pfcguide.com.
Google is great for searching the Sybase newsgroups, but you can't post
to them from there.

---------------------------------------------------------------------
DISCLAIMER:

This newsgroup message is only intended for the recipient. Given that it
is a posting to a public newsgroup, that means if you can read this
message then you are the recipient. This message may contain information
that is confidential and protected from disclosure. And then again,
it may not.

Given that TeamSybase members are not employees of Sybase, the contents
of this message do not necessarily represent the views or policies of
Sybase. Given that TeamSybase is a diverse group of users of Sybase
products, the contents of this message do not necessarily represent the
views of a significant number of the members of TeamSybase. Given that the
author has multiple personalities and hears voices in his head, the contents
of this message do not necessarily represent his own views.