Click here to Skip to main content
15,891,372 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
I am having a little difficulty trying to make asynchronous calls to a linq to sql using Stored procedures. I really don't know how to start to approach the situation.

this is my regular call to my webservice
<webmethod()> _
       Public Function _LoadPostingArchive() As List(Of _sp_PostingsResult)
      Using db As New postingsDataContext
          Return db._sp_Postings("archive", Nothing, Nothing, Nothing, Nothing, Nothing, Nothing, Nothing, Nothing, Nothing, Nothing, Nothing, Nothing, _
                                  Nothing, Nothing, Nothing, Nothing, Nothing, Nothing, Nothing, Nothing, Nothing, Nothing, Nothing, Nothing, _
                                  Nothing, Nothing, Nothing, Nothing).ToList()
      End Using
  End Function


I am trying to make this call an asynchronous call but like i said I can't find much about this approach I want to make create something scaleable that as my users and data grows I only modify my webservice and the rest of the code is undisturbed

any help if apprciated and if something is not clear please let me know so I can further clarify the questions
Posted

1 solution

Nothing you've done, is related to making it asyncronous. You need AJAX for that, or the ASP.NET AJAX library, if you want it made easy for you. Your VB runs on the server. You need to run js on the client to make it asynch.
 
Share this answer
 
Comments
Member 7790032 5-Jun-11 22:32pm    
I am new to this topic but I noticed that my loading time and calls are running a little slower now i have a lot more records to retrieve and format. Could you point me in a direction or an example to help me make this change.
Member 7790032 5-Jun-11 22:42pm    
No i haven't done anything to make it async because what i have done didn't work so far so i have given you what I have and where I need or would want to take it

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900