Anyone tried async ADO.NET in Whidbey ?

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

Rick
Thu Dec 18 23:55:30 CST 2003


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/
----------------------------------
Making waves on the Web


"Lecture Snoddddgrass" <maley@hamburg.fry> wrote in message
news:#0jeg1cxDHA.2304@TK2MSFTNGP12.phx.gbl...
> 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
>
>

Lecture
Fri Dec 19 00:58:43 CST 2003

+> 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. :)

Cowboy
Fri Dec 19 11:23:01 CST 2003

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" <maley@hamburg.fry> wrote in message
news:%230jeg1cxDHA.2304@TK2MSFTNGP12.phx.gbl...
> 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
>
>

William
Fri Dec 19 16:05:10 CST 2003

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

"Lecture Snoddddgrass" <maley@hamburg.fry> wrote in message
news:utJ9L2fxDHA.1680@TK2MSFTNGP12.phx.gbl...
> +> 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. :)
>
>
>

Miha
Mon Dec 22 02:32:21 CST 2003


"Cowboy (Gregory A. Beamer)" <NoSpamMgbworld@comcast.netNoSpamM> wrote in
message news:ugneBTlxDHA.2136@TK2MSFTNGP10.phx.gbl...
Whidbey is cool. It will
> rock a lot of worlds, however.

Oh yes. :)

--
Miha Markic - RightHand .NET consulting & software development
miha at rthand com
www.rthand.com

Angel
Mon Jan 05 21:04:34 CST 2004

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)" <NoSpamMgbworld@comcast.netNoSpamM> wrote in
message news:ugneBTlxDHA.2136@TK2MSFTNGP10.phx.gbl...
> 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" <maley@hamburg.fry> wrote in message
> news:%230jeg1cxDHA.2304@TK2MSFTNGP12.phx.gbl...
> > 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
> >
> >
>
>