"darrel" <notreal@nowhere.com> wrote in message
news:OgJHsXG8FHA.1484@tk2msftngp13.phx.gbl...
> When retrieving data, I typically use an OleDbDataAdapter.
>
> When updating data, I normally use an OleDbCommand. But it seems as if a
> OleDbDataAdapter would work just fine too.
>
> What is the general rules of thumb for using one over the other for a
> given DB query?
>
> -Darrel
>

"Scott M." <s-mar@nospam.nospam> wrote in message
news:OENoSWR8FHA.2816@tk2msftngp13.phx.gbl...
> DataAdapters only work because of Command objects that it wraps around.
>
> What's nice about DataAdapters is that they have the ability to invoke the
> correct Command with simple method calls. In other words, they are a
> convienience. There are no rules of thumb for their use.
>
> "darrel" <notreal@nowhere.com> wrote in message
> news:OgJHsXG8FHA.1484@tk2msftngp13.phx.gbl...
>> When retrieving data, I typically use an OleDbDataAdapter.
>>
>> When updating data, I normally use an OleDbCommand. But it seems as if a
>> OleDbDataAdapter would work just fine too.
>>
>> What is the general rules of thumb for using one over the other for a
>> given DB query?
>>
>> -Darrel
>>
>
>

"S.M. Altaf [MVP]" <smaltaf@PLEASEDONTSPAMMEmsn.com> wrote in message
news:%23JMRo3c8FHA.1248@TK2MSFTNGP14.phx.gbl...
>
> It'd all be on personal preference and the architecture of the
> application. When using all SPs for data retrieval, for example, you
> wouldn't use any dataadapters.
>
> --------------------------------------------------------------------------------
> All that glitters has a high refractive index.
> www.mendhak.com
>
>
> "Scott M." <s-mar@nospam.nospam> wrote in message
> news:OENoSWR8FHA.2816@tk2msftngp13.phx.gbl...
>> DataAdapters only work because of Command objects that it wraps around.
>>
>> What's nice about DataAdapters is that they have the ability to invoke
>> the correct Command with simple method calls. In other words, they are a
>> convienience. There are no rules of thumb for their use.
>>
>> "darrel" <notreal@nowhere.com> wrote in message
>> news:OgJHsXG8FHA.1484@tk2msftngp13.phx.gbl...
>>> When retrieving data, I typically use an OleDbDataAdapter.
>>>
>>> When updating data, I normally use an OleDbCommand. But it seems as if a
>>> OleDbDataAdapter would work just fine too.
>>>
>>> What is the general rules of thumb for using one over the other for a
>>> given DB query?
>>>
>>> -Darrel
>>>
>>
>>
>
>