Data Controls or Code

I'm fairly new to .NET, so bear with me if this question is naive. But do
most developers use the VS data controls for connections, adapters, and
datasets, or do you write all that code manually?

And if you use the controls, how do you wrap your connection and adapter
code so that you can easily switch between SQL Server, OLE DB, and ODBC?

I've been writing the code manually, and I'm comfortable with that, but I'm
wondering whether I'd be more productive using the Visual data controls.

Thanks,
Steve Murphy

William
Wed Jan 26 13:44:23 CST 2005

There is no easy one-line answer for this question. While many developers
use the wizards and the code they generated, others (more than half) find
this code to be too simplistic for their specific requirements. In cases
where you need to write a front-end that can access several data sources, we
usually suggest creating a separate data access layer (tier) that handles
DBMS-specific operations and expose this class to the application. This way
you can (in theory) "simply" substitute another layer to access other DBMS
backends. I discuss this in depth in my books.

hth

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________

"Steve Murphy" <smurphy@granite-ridge.com> wrote in message
news:%23CyNX39AFHA.1524@TK2MSFTNGP09.phx.gbl...
> I'm fairly new to .NET, so bear with me if this question is naive. But do
> most developers use the VS data controls for connections, adapters, and
> datasets, or do you write all that code manually?
>
> And if you use the controls, how do you wrap your connection and adapter
> code so that you can easily switch between SQL Server, OLE DB, and ODBC?
>
> I've been writing the code manually, and I'm comfortable with that, but
> I'm
> wondering whether I'd be more productive using the Visual data controls.
>
> Thanks,
> Steve Murphy
>
>
>

KurtSchroeder
Wed Jan 26 16:45:01 CST 2005

this is a very big issue for me. Which book do you recomend for what you just
described.
thankd you
kes

"William (Bill) Vaughn" wrote:

> There is no easy one-line answer for this question. While many developers
> use the wizards and the code they generated, others (more than half) find
> this code to be too simplistic for their specific requirements. In cases
> where you need to write a front-end that can access several data sources, we
> usually suggest creating a separate data access layer (tier) that handles
> DBMS-specific operations and expose this class to the application. This way
> you can (in theory) "simply" substitute another layer to access other DBMS
> backends. I discuss this in depth in my books.
>
> hth
>
> --
> ____________________________________
> William (Bill) Vaughn
> Author, Mentor, Consultant
> Microsoft MVP
> www.betav.com
> Please reply only to the newsgroup so that others can benefit.
> This posting is provided "AS IS" with no warranties, and confers no rights.
> __________________________________
>
> "Steve Murphy" <smurphy@granite-ridge.com> wrote in message
> news:%23CyNX39AFHA.1524@TK2MSFTNGP09.phx.gbl...
> > I'm fairly new to .NET, so bear with me if this question is naive. But do
> > most developers use the VS data controls for connections, adapters, and
> > datasets, or do you write all that code manually?
> >
> > And if you use the controls, how do you wrap your connection and adapter
> > code so that you can easily switch between SQL Server, OLE DB, and ODBC?
> >
> > I've been writing the code manually, and I'm comfortable with that, but
> > I'm
> > wondering whether I'd be more productive using the Visual data controls.
> >
> > Thanks,
> > Steve Murphy
> >
> >
> >
>
>
>

Steve
Wed Jan 26 17:07:18 CST 2005

> this is a very big issue for me. Which book do you recomend for what you
just
> described.
>
> > There is no easy one-line answer for this question. While many
developers
> > use the wizards and the code they generated, others (more than half)
find
> > this code to be too simplistic for their specific requirements. In cases
> > where you need to write a front-end that can access several data
sources, we
> > usually suggest creating a separate data access layer (tier) that
handles
> > DBMS-specific operations and expose this class to the application. This
way
> > you can (in theory) "simply" substitute another layer to access other
DBMS
> > backends. I discuss this in depth in my books.


I am also interested in your book. What is the title, and where is the best
place to get it?

Thanks,
Steve Murphy

William
Wed Jan 26 22:04:57 CST 2005

See www.betav.com for details. Note there is a site there that looks up the
best price. http://www.bestwebbuys.com/books/search?t=ISBN&q=1-893115-68-2

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________

"Steve Murphy" <smurphy@granite-ridge.com> wrote in message
news:uat4st$AFHA.2644@TK2MSFTNGP10.phx.gbl...
>> this is a very big issue for me. Which book do you recomend for what you
> just
>> described.
>>
>> > There is no easy one-line answer for this question. While many
> developers
>> > use the wizards and the code they generated, others (more than half)
> find
>> > this code to be too simplistic for their specific requirements. In
>> > cases
>> > where you need to write a front-end that can access several data
> sources, we
>> > usually suggest creating a separate data access layer (tier) that
> handles
>> > DBMS-specific operations and expose this class to the application. This
> way
>> > you can (in theory) "simply" substitute another layer to access other
> DBMS
>> > backends. I discuss this in depth in my books.
>
>
> I am also interested in your book. What is the title, and where is the
> best
> place to get it?
>
> Thanks,
> Steve Murphy
>
>

Steve
Fri Jan 28 11:49:43 CST 2005


"William (Bill) Vaughn" <billvaRemoveThis@nwlink.com> wrote:

> See www.betav.com for details. Note there is a site there that looks up
the
> best price. http://www.bestwebbuys.com/books/search?t=ISBN&q=1-893115-68-2


Are the VB and C# books pretty much equivalent? Do they both cover layering
with the same depth?

Thanks,
Steve Murphy

William
Sun Jan 30 20:54:25 CST 2005

The difference between the two books (if you ignore the language
differences) is in how ADO classic covered--it's not mentioned in the C#
book.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________

"Steve Murphy" <smurphy@granite-ridge.com> wrote in message
news:%23EaMgEWBFHA.1292@TK2MSFTNGP10.phx.gbl...
>
> "William (Bill) Vaughn" <billvaRemoveThis@nwlink.com> wrote:
>
>> See www.betav.com for details. Note there is a site there that looks up
> the
>> best price.
>> http://www.bestwebbuys.com/books/search?t=ISBN&q=1-893115-68-2
>
>
> Are the VB and C# books pretty much equivalent? Do they both cover
> layering
> with the same depth?
>
> Thanks,
> Steve Murphy
>
>