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