Best Practice in C# for ADO.NET

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ali - 20 Jul 2007 21:43 GMT

Hi,

I would like to know which way of programming database applications is
the best practice and has less problems.

using code to create connection , dataset, table adapters and so on
or
using visual tools and binding the controls to them

and please describe why...

thanks
Ali

Reply to this Message

sloan - 20 Jul 2007 21:51 GMT

The "drag and drop" stuff is for RAPID development.

When it comes to Good or Maintainble development, the drop and drag
stuff,.... is el-stinko in my book.
aka, RAPID != to Good/Maintainable

..

The best thing to me is to create your own code, but to piggyback off of the
EnterpriseLibrary.Data or DAAB 2.0 libraries.

See http://sholliday.spaces.live.com/Blog/cns!A68482B9628A842A!140.entry
for an example.

> Hi,
>
[quoted text clipped - 9 lines]
> thanks
> Ali

Reply to this Message

Mark Rae [MVP] - 20 Jul 2007 23:34 GMT

> The best thing to me is to create your own code, but to piggyback off of
> the EnterpriseLibrary.Data or DAAB 2.0 libraries.

I completely agree with that.

> The "drag and drop" stuff is for RAPID development.

I would actually question that... Once you have a good DAL in place, I think
it's quicker and easier to use that rather than the visual tools...