ADO.Net Data Access Methods

Question

Hi,

 

This question has been going around in my mind for some time. I have a very silly question but something that has started to bother me now. I want to know which is a better technique for Data Access.

 

Is using DataAdapter or TableAdapter from a design view or creating them at runtime a better option? I am asking this because creating adapter object at design view automatcally generates Select, Insert, Update and Delete Command objects. But in many cases I do not use all these Command objects. Don't they increase the burden on the processors? Whereas If I create these objects at runtime I only add the Command Objects I require.

 

If anyone can help me with my queries, it would be great

 

Regards

 

Vineed

Answer 1

Isn't it faster for VS to create the objects for you, then for you to have to type them all out?
The extra command objects will consume more memory; however it will be insignificant.

Answer 2

Hi,

 

Thanks for your time. Actually I asked this question because I have an ASP.Net page which has about 3 or 4 DataAdapters that were created at design time and the page now seems somewhat slow as it already has a lot of processing work that happens. So, just wanted to know which is the best option

 

Thanks again......

 

Regards

 

Vineed