Database access tools suck!! -- dotnet datatools

Relaxin
12/28/2004 3:33:39 AM

It is just me or has MS created some of the worst ways to access and display
data?

You can use a DataSet, but if you want to sort or filter the data to must
use a DataView which is created from a DataSet.

But, if you sort by using the Grid (clicking the header) you can no longer
use the DataSet (or maybe the DataView, if that is what you are using) to
locate the record that the user has selected!!

You have to write code to get the current position...this should just be a
property!!

Also, can someone explain to me why does the FindRows return
DataRowView...what can you do with a DataRowView, I haven't figure out a way
to load this data into a new DataView or a DataSet (if there is a way,
please explain it to me). It seems that the FindRows should have just
return a new DataView!!

I understand why all of the necessary data access components are broken out
into many different parts, but why not ALSO build a component that
encompasses all of the components and use that as an "enhanced DataSet" that
can also be used as a Datasource to the grid and other components.(This is
something that I have already done for myself.)

Maybe it's because I'm coming from Borland and expect top notch development
tools/comopnents...where there VCL Framework and Data Access components were
THE BEST!!!

But I had to leave Borland because their management said that they were
killing the Borland C++ Builder (BCB) product about 6 months ago. But, they
just recently announced that they had a change of heart and will now support
BCB.
That's a little to flaky for me, so I jumped ship and moved to MS.

But with what I have seen in VS.NET (C#), I might have to talk my chances
with Borland.

Bishoy Ghaly
12/29/2004 5:53:54 AM

Dear Relaxin,
As a borland regular customer that just moved to C# from Delphi I Advice
you to not expect the easiest coding experience with M$ products, but to be
honest, Alan hejlesberg did a great job on C#. if he was still with borland
and did not migrate to M$ the whole thing would be reversed and more M$
customers would have been migrating to borland by now, anyway to the topic,
ADO.NET is better than OLD ADO, if you used to ADO with BCB or Delphi then
you know the difference is big and i encourage you to take the OOP route in
your ADO.NET development as it make things easier and maintainable by the
time

[quoted text, click to view]

dotnet datatools : Database access tools suck!!