Best Practice in C# for ADO.NET

[Ali]

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

 

[sloan]

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.

 

[Mark Rae [MVP]]

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...