I considered my self, quite proficient with the ADO.NET 1.0/1.1 objects.

Today, I was trying to use the "new way" of dragging and dropping your way to writing some database code with ADO.NET 2.0. The code generated by the dataset wizard, is way, way, way, beyond my comprehension. I now feel like I know nothing about ADO.NET, yet I have 3 + years experieince in SQL/ADO.NET.

My Question:
Is this dataset class (the one with 1859 lines of marvelous looking code), really useful. I mean, can you really build a piece of sofware using this class?

Is this stuff just for people who have no clue how a dataset/datatable works?

I am used to creating a stored procedure, which has maybe 10-100 lines of code, and then filling a datatable using either a datareader or dataAdapter. In this specific case, I created a dataset using the dataset wizard, and I tried to duplicate the same thing, the table has 10 columns, of which I only need 2 columns of information, I was horrified when I looked at the code it generated.

Using my old manual methods, the entire project would only be 200-400 lines of code. But then maybe I am just ignorant, and have a lot to learn...

Can any of you seasoned database developers offer some philosophy/insight on this dataset wizard which Microsoft has offered us?

Thanks

Russell Mangel
Las Vegas, NV
PS
I feel like an Idiot, with 2 brain cells.