Anyone tried async ADO.NET in Whidbey ?

  • Thread starter Lecture Snoddddgrass
  • Start date
L

Lecture Snoddddgrass

Hi,

I've read in a number of articles on MSDN and elsewhere that the Whidbey
version of .NET+framework will support true async calls for ADO.NET. Has
anyone tried this in Whidbey? I'm looking for something like a
DataAdapter.BeginFill()/EndFill() but can't seem to find anything in the
documentation. Have any articles been written on this topic? I can't seem to
find any.

[I know this product is pre-beta, but hey, it never hurts to plan ahead
for this stuff!]

Sincerely,

Xavier Mendez Lecture Snoddddgrass
 
R

Rick Strahl [MVP]

If you are interested in this stuff, there's an ADO.Net preview book out by
Addison Wesley. Good book for giving you an idea of what's there although it
sucks for actually giving you anything but a quick taste <g>...

FWIW, you can do this pretty easily to day by using delegates, the main
difference is that you can use a single connection to run multiple queries
simultaneously.

+++ Rick ---

--

Rick Strahl
West Wind Technologies
http://www.west-wind.com/
http://www.west-wind.com/blog/
 
L

Lecture Snoddddgrass

+> If you are interested in this stuff, there's an ADO.Net preview book out
by
Addison Wesley. Good book for giving you an idea of what's there although it
sucks for actually giving you anything but a quick taste <g>...

Yeah, I just discovered that on Amazon a few minutes after I posted that
message. I just ordered it. There's a book by the same company on
ASP.NET-Whidbey as well.
FWIW, you can do this pretty easily to day by using delegates,

...right, and that makes the call asynchronous from the perspective of
the main thread I suppose... but "under the hood," that thread pool thread
is still blocking. This new ADO.NET is supposed to support true async kind
of like the the Http WebRequest class and Socket classes do.
the main
difference is that you can use a single connection to run multiple queries
simultaneously.

That's really cool. I think to do *that* you need to be running both
Whidbey AND Yukon. I can't seem to get my grubby little hands on the Yukon
beta though. I think you have to be part of some special "in crowd" to get
that. :)
 
C

Cowboy \(Gregory A. Beamer\)

Some of the Whidbey stuff mentioned in articles is not in the alpha version.
I have not tried async ADO.NET yet, so I cannot answer. IF the feature is
not there, it should be in by beta 1 next spring. Whidbey is cool. It will
rock a lot of worlds, however.

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

**********************************************************************
Think Outside the Box!
**********************************************************************
 
W

William \(Bill\) Vaughn

I've tried the async parts. They require that a new version of MDAC (9.0) is
attached to the assembly. I have not bothered to figure out how to do that
yet.


--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
MVP, hRD
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
 
A

Angel Saenz-Badillos[MS]

Lecture,
The asynch support in the whidbey alpha will be SqlConnection.BeginOpen
/EndOpen and SqlCommand.BeginExecuteReader/NonQuery/XmlReader with and
without a Callback event.and with the corresponding EndExecute(s). There are
currently no plans for a BeginFill/ EndFill sorry.

This is true asynch support without under the covers magic and will allow
easier GUI asynch behavior plus it can significantly speed up asp.net pages
that require multiple expensive queries.

I am not sure if the "will rock a lot of worlds" is a possitive thing *grin*
any particular concerns I can address?
Thanks
--
Angel Saenz-Badillos [MS] Managed Providers
This posting is provided "AS IS", with no warranties, and confers no
rights.Please do not send email directly to this alias.
This alias is for newsgroup purposes only.

Cowboy (Gregory A. Beamer) said:
Some of the Whidbey stuff mentioned in articles is not in the alpha version.
I have not tried async ADO.NET yet, so I cannot answer. IF the feature is
not there, it should be in by beta 1 next spring. Whidbey is cool. It will
rock a lot of worlds, however.

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

**********************************************************************
Think Outside the Box!
**********************************************************************
Lecture Snoddddgrass said:
Hi,

I've read in a number of articles on MSDN and elsewhere that the Whidbey
version of .NET+framework will support true async calls for ADO.NET. Has
anyone tried this in Whidbey? I'm looking for something like a
DataAdapter.BeginFill()/EndFill() but can't seem to find anything in the
documentation. Have any articles been written on this topic? I can't
seem
to
find any.

[I know this product is pre-beta, but hey, it never hurts to plan ahead
for this stuff!]

Sincerely,

Xavier Mendez Lecture Snoddddgrass
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top