data access with .net - visually or programatically?

[BK]

I am gently moving my database applications from vb6 to c# . I would really
appreciate if experienced c# database programmers among you could advice
whether I should connect to sql databases visually using server explore
controls or do it programatically as I have always done.

Kaz

[BK]

Re: data access with .net - visually or programatically ?

Thanks Mariano. Your advice is much appreciated.

Kaz


"Mariano Birnios" <mariano@tectim es.com> wrote in message
news:0ae101c34c a5$6c8ab3d0$a00 1280a@phx.gbl.. .[color=blue]
> Hi!
>
> I'm not a db programming guru, but maybe I can point you
> some things...
>
> If you use the visual designer (server explorer, etc.) to
> connect to a database, you are actually "creating code" in
> your project, in a visual way. That code, has a relation
> with the visual elements you have created, so if you
> change some property in the property window, that change
> is reflected in your code...
>
> So, as the desinger will just type code, I always prefer
> to write my own.
>
> But, also, there are other importan things. You must know
> the code that the designer generates. For example,
> probably you are creating a "typed dataset" with the
> designer, but maybe is just enough with a simple dataset
> created by you at the code window... without all the
> overhead of typed datasets...
>
> In a big project, I prefer not to use the visual designer
> at all. If I have to write some small PIM, maybe I just
> drag & drop a little...
>
> Cheers...
> Mariano
>
>[color=green]
> >-----Original Message---->I am gently moving my database[/color]
> applications from vb6 to c# . I would really[color=green]
> >appreciate if experienced c# database programmers among[/color]
> you could advice[color=green]
> >whether I should connect to sql databases visually using[/color]
> server explore[color=green]
> >controls or do it programatically as I have always done.
> >
> >Kaz
> >
> >
> >
> >
> >
> >
> >.
> >[/color][/color]