Just a newbie question: we are referencing an ado.net dataservice in our
application. When we are debugging and watching the service reference we
are noticing that we can immediately expand and view the individual row data
from each of the entity's tables inside of VS's watch window as soon as the
reference is created.

Does this imply that the data is being retrieved dynamically as we are
debugging and expanding the individual entities/results, or is (I can't
imagine this) all of the data being returned at the time the service is
created and prior to any actual query being performed ?

Quick code example of what I mean:

_svcAegis = New svcAegisEntities.AegisEntities(New
Uri("http://localhost:2118/svcAegisEntities.svc", UriKind.Absolute))

Dim s as string = String.Empty <<< if we set a breakpoint here and watch the
_svcAegis reference we can expand each of the referenced entity tables and
all of the data therein even though no actual query of any sort has been
performed

Dim q = From cc In AegisEntitiesPubRef.CodeCountries Select cc Order By
cc.cc_iso3166_name_e

Dim l = q.ToList()

Thanks in advance

Thanks Patrice - I wish I had thought of that to begin with. You were
right - the trace proves that the data is being retrieved dynamically as I
move through the query object in the watch window. For me this was
completely unexpected behavior and I needed proof to convince myself that
some sort of unholy mass data retrieval wasn't happening.

"Patrice" <http://www.chez.com/scribe/> wrote in message
news:075B162A-9BEC-4B0C-9647-(E-Mail Removed)...
> Yes. They are properties and code runs when you want to get a property
> value... You could use SQL Server profiler (if this is the database you
> are uisng) to see what is sent to the server while you browse those
> properties...
>
> --
> Patrice
>
> "CGatto" <(E-Mail Removed)> a écrit dans le message de
> groupe de discussion : u#(E-Mail Removed)...
>> Just a newbie question: we are referencing an ado.net dataservice in our
>> application. When we are debugging and watching the service reference we
>> are noticing that we can immediately expand and view the individual row
>> data from each of the entity's tables inside of VS's watch window as soon
>> as the reference is created.
>>
>> Does this imply that the data is being retrieved dynamically as we are
>> debugging and expanding the individual entities/results, or is (I can't
>> imagine this) all of the data being returned at the time the service is
>> created and prior to any actual query being performed ?
>>
>> Quick code example of what I mean:
>>
>> _svcAegis = New svcAegisEntities.AegisEntities(New
>> Uri("http://localhost:2118/svcAegisEntities.svc", UriKind.Absolute))
>>
>> Dim s as string = String.Empty <<< if we set a breakpoint here and watch
>> the _svcAegis reference we can expand each of the referenced entity
>> tables and all of the data therein even though no actual query of any
>> sort has been performed
>>
>> Dim q = From cc In AegisEntitiesPubRef.CodeCountries Select cc Order By
>> cc.cc_iso3166_name_e
>>
>> Dim l = q.ToList()
>>
>> Thanks in advance
>
>