Asynchronous data access in ASP.NET

[developer]

Hi All,

I am lil confused with different ways of asynchronous data access.
My understanding is that, asynchronous data access frees up a thread
instead of engaging it while a stored proc is being executed. This
makes more threads available. Is this correct or are there ay other
advantages of asynchronous data access?
My questions are:
1. I cannot set the async page directive to true as suggested in
some articles. I get an error saying incorrect page directive.
2. I can set async attribute in connection string as suggested in
few articles. I get error 'Keyword not supported.
Am I missing something to get the above errors or the articles I got
the above information from are outdated?
Here is my code. I made sense from 100 different sources before coding.

Would some one tell me if I am doing it correctly? I correctly see
deferent thread id's before and after data access.
Private Function getdata() As System.Data.Sql Client.SqlDataR eader
Dim dr As System.Data.Sql Client.SqlDataR eader
'code to run any sql get dr
If dr Is Nothing OrElse dr.IsClosed OrElse Not dr.HasRows Then
Return Nothing
Exit Function
End If
Return dr
End Function
Public Delegate Function AsyncDelegate() As
System.Data.Sql Client.SqlDataR eader
Private Function getdataAsync() As
System.Data.Sql Client.SqlDataR eader
Dim dlgt As New AsyncDelegate(A ddressOf getdata)
Dim ar As IAsyncResult = dlgt.BeginInvok e(Nothing, Nothing)
'display(AppDom ain.GetCurrentT hreadId()) (this a thread)
Thread.Sleep(0)
Dim adr As System.Data.Sql Client.SqlDataR eader =
dlgt.EndInvoke( ar)
'display(AppDom ain.GetCurrentT hreadId()) (this is a different
thread than the above.)
Return adr
End Function
I greatly appreciate any help

[Patrice]

This is new in 2.0. Are you using 2.0 or 1.1 ?

--
Patrice

"developer" <vp*******@yaho o.coma écrit dans le message de news:
11************* ********@h48g20 00...legro ups.com...

Hi All,

I am lil confused with different ways of asynchronous data access.
My understanding is that, asynchronous data access frees up a thread
instead of engaging it while a stored proc is being executed. This
makes more threads available. Is this correct or are there ay other
advantages of asynchronous data access?
My questions are:
1. I cannot set the async page directive to true as suggested in
some articles. I get an error saying incorrect page directive.
2. I can set async attribute in connection string as suggested in
few articles. I get error 'Keyword not supported.
Am I missing something to get the above errors or the articles I got
the above information from are outdated?
Here is my code. I made sense from 100 different sources before coding.

Would some one tell me if I am doing it correctly? I correctly see
deferent thread id's before and after data access.
Private Function getdata() As System.Data.Sql Client.SqlDataR eader
Dim dr As System.Data.Sql Client.SqlDataR eader
'code to run any sql get dr
If dr Is Nothing OrElse dr.IsClosed OrElse Not dr.HasRows Then
Return Nothing
Exit Function
End If
Return dr
End Function
Public Delegate Function AsyncDelegate() As
System.Data.Sql Client.SqlDataR eader
Private Function getdataAsync() As
System.Data.Sql Client.SqlDataR eader
Dim dlgt As New AsyncDelegate(A ddressOf getdata)
Dim ar As IAsyncResult = dlgt.BeginInvok e(Nothing, Nothing)
'display(AppDom ain.GetCurrentT hreadId()) (this a thread)
Thread.Sleep(0)
Dim adr As System.Data.Sql Client.SqlDataR eader =
dlgt.EndInvoke( ar)
'display(AppDom ain.GetCurrentT hreadId()) (this is a different
thread than the above.)
Return adr
End Function
I greatly appreciate any help

[developer]

I have 2.0 installed. I think 2.0 is being used to execute the code I
gave, Or else I will get an error executing it, right?
Patrice wrote:

This is new in 2.0. Are you using 2.0 or 1.1 ?

--
Patrice

"developer" <vp*******@yaho o.coma écrit dans le message de news:
11************* ********@h48g20 00...legro ups.com...

Hi All,

I am lil confused with different ways of asynchronous data access.
My understanding is that, asynchronous data access frees up a thread
instead of engaging it while a stored proc is being executed. This
makes more threads available. Is this correct or are there ay other
advantages of asynchronous data access?
My questions are:
1. I cannot set the async page directive to true as suggested in
some articles. I get an error saying incorrect page directive.
2. I can set async attribute in connection string as suggested in
few articles. I get error 'Keyword not supported.
Am I missing something to get the above errors or the articles I got
the above information from are outdated?
Here is my code. I made sense from 100 different sources before coding.

Would some one tell me if I am doing it correctly? I correctly see
deferent thread id's before and after data access.
Private Function getdata() As System.Data.Sql Client.SqlDataR eader
Dim dr As System.Data.Sql Client.SqlDataR eader
'code to run any sql get dr
If dr Is Nothing OrElse dr.IsClosed OrElse Not dr.HasRows Then
Return Nothing
Exit Function
End If
Return dr
End Function
Public Delegate Function AsyncDelegate() As
System.Data.Sql Client.SqlDataR eader
Private Function getdataAsync() As
System.Data.Sql Client.SqlDataR eader
Dim dlgt As New AsyncDelegate(A ddressOf getdata)
Dim ar As IAsyncResult = dlgt.BeginInvok e(Nothing, Nothing)
'display(AppDom ain.GetCurrentT hreadId()) (this a thread)
Thread.Sleep(0)
Dim adr As System.Data.Sql Client.SqlDataR eader =
dlgt.EndInvoke( ar)
'display(AppDom ain.GetCurrentT hreadId()) (this is a different
thread than the above.)
Return adr
End Function
I greatly appreciate any help

[Patrice]

Do you use other features from 2.0 that are working ? Have you checked that
your site uses 2.0 (you have a tab in the IIS console that allows to select
which version the site uses).

For now I 'm suspicious as the async directive doesn't seems to be
recognized. The exact error message could help. If this something else if
you write at the same place a directive name that for sure doesn't exists ?

--
Patrice

"developer" <vp*******@yaho o.coma écrit dans le message de news:
11************* *********@h48g2 00...legr oups.com...
I have 2.0 installed. I think 2.0 is being used to execute the code I
gave, Or else I will get an error executing it, right?
Patrice wrote:

This is new in 2.0. Are you using 2.0 or 1.1 ?

--
Patrice

"developer" <vp*******@yaho o.coma écrit dans le message de news:
11************* ********@h48g20 00...legro ups.com...

Hi All,

I am lil confused with different ways of asynchronous data access.
My understanding is that, asynchronous data access frees up a thread
instead of engaging it while a stored proc is being executed. This
makes more threads available. Is this correct or are there ay other
advantages of asynchronous data access?
My questions are:
1. I cannot set the async page directive to true as suggested in
some articles. I get an error saying incorrect page directive.
2. I can set async attribute in connection string as suggested in
few articles. I get error 'Keyword not supported.
Am I missing something to get the above errors or the articles I got
the above information from are outdated?
Here is my code. I made sense from 100 different sources before coding.

Would some one tell me if I am doing it correctly? I correctly see
deferent thread id's before and after data access.
Private Function getdata() As System.Data.Sql Client.SqlDataR eader
Dim dr As System.Data.Sql Client.SqlDataR eader
'code to run any sql get dr
If dr Is Nothing OrElse dr.IsClosed OrElse Not dr.HasRows Then
Return Nothing
Exit Function
End If
Return dr
End Function
Public Delegate Function AsyncDelegate() As
System.Data.Sql Client.SqlDataR eader
Private Function getdataAsync() As
System.Data.Sql Client.SqlDataR eader
Dim dlgt As New AsyncDelegate(A ddressOf getdata)
Dim ar As IAsyncResult = dlgt.BeginInvok e(Nothing, Nothing)
'display(AppDom ain.GetCurrentT hreadId()) (this a thread)
Thread.Sleep(0)
Dim adr As System.Data.Sql Client.SqlDataR eader =
dlgt.EndInvoke( ar)
'display(AppDom ain.GetCurrentT hreadId()) (this is a different
thread than the above.)
Return adr
End Function
I greatly appreciate any help