Databases
StackOverflow2013
Postsdbo
POWebService Calls Database Twice
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POWebService Calls Database Twice
    primarykey
    data
    text
    <p>I have a very simple web service function that pulls data from the database and returns it to the user. However I've discovered recently (via logging on the database end) that the call is being performed TWICE. I've narrowed it down to the webservice that's causing the problem... if I open the service through the browser on localhost and then execute it directly, the SQL log shows it has having run twice within about 1/100th of a second.</p> <p>I'm including my code for guidance. Built in VS2008.</p> <pre><code>&lt;WebMethod()&gt; _ Public Function MY_DATABASE_QUERY() As DataSet Dim DS As New DataSet Dim DA As New SqlDataAdapter Dim Cmd As New SqlCommand With Cmd .Connection = Connection() .CommandType = CommandType.StoredProcedure .CommandText = "SOME_STORED_PROCEDURE" .Connection.Open() .ExecuteReader() .Connection.Close() DA.SelectCommand = Cmd DA.Fill(DS) End With Return DS End Function </code></pre> <p>The Connection() function simply pulls the encrypted connection string from web.config, decrypts it, and returns the object:</p> <pre><code>Public Function Connection() As SqlConnection Dim R As New Rijndael Return New SqlConnection(R.DecryptString128Bit(System.Configuration.ConfigurationManager.ConnectionStrings("ConnString").ToString, "S0ME_HA$H_C0D3")) End Function </code></pre> <p>...and that's basically it. It's about as straightforward as you can get.</p> <p>With this in mind, does anybody have any idea why it's behaving as it is, and how I can prevent this in the future? It's no big deal for this query, but it could be a very big deal if it's doing it on (for example) a purchase or a payment.</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USmarc_s
    1. USDon Quixote
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POWebService Calls Database Twice
      1. This table or related slice is empty.
      1. VTUpMod
    1. COHave you checked if your service is called twice? For example by putting some logging into place?
      singulars
      1. POWebService Calls Database Twice
      1. USnvoigt
    2. COMy first thought was that it was being called twice from the webpage that calls it, and I wasted a large amount of time troubleshooting in that direction. However if you remove the calling webpage out of the equation and call the webservice manually (by web-browsing to http://localhost/address/to/MyWebService.asmx) it still shows it's being executed twice.
      singulars
      1. POWebService Calls Database Twice
      1. USDon Quixote
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload