Databases
StackOverflow2013
Postsdbo
POWhat is the best way in WebMatrix to query WCF services?
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POWhat is the best way in WebMatrix to query WCF services?
    primarykey
    data
    text
    <p>I have an ASP.Net project using the Razor view engine which currently queries various databases directly with WebMatrix.Data.Database.Open.</p> <p>I'm trying to migrate all direct database access to Web Services using WCF so that I get consistent business logic. In doing this, I have also enabled the WCF service to be "httpGetEnabled". This allows me to use Excel Macros to query the same web service.</p> <p>My question is, what is the best way to query these web services from a Razor/WebMatrix page?</p> <p>Should I JSON enable my WCF service and use the WebMatrix JSON helper? Or should I be using JQuery to get the xml?</p> <p>I would assume the former would be the best way, but how do I JSON enable my WCF service? I remember seeing a video that allowed me to specify an additional query parameter to the WCF request to get JSON, but I can't find it again.</p> <p>Any thoughts or pointers in the right direction would be greatly appreciated.</p> <p>Kind regards.</p> <hr> <p>Edit:</p> <p>I've recently seen this on Stack Overflow : <a href="https://stackoverflow.com/questions/5074603/client-side-binding-using-by-converting-the-wcf-services-to-json">Client Side Binding using by Converting the WCF Services to JSON</a> </p> <p>On following this, I went to the MSDN article referred to around WebHttpBehavior. I have since added "automaticFormatSelectionEnabled=true" to the webHttp element in Web.config. In addition, I added the following code which then allowed me to specify "format=json" as a query parameter:</p> <pre><code>string formatQueryStringValue = WebOperationContext.Current.IncomingRequest.UriTemplateMatch.QueryParameters["format"]; if (!string.IsNullOrEmpty(formatQueryStringValue)) { if (formatQueryStringValue.Equals("xml", System.StringComparison.OrdinalIgnoreCase)) { WebOperationContext.Current.OutgoingResponse.Format = WebMessageFormat.Xml; } else if (formatQueryStringValue.Equals("json", System.StringComparison.OrdinalIgnoreCase)) { WebOperationContext.Current.OutgoingResponse.Format = WebMessageFormat.Json; } } </code></pre> <p>I now just need to work out how to use the WebMatrix JSON helper to get the results... Will update when I get some more information.</p> <hr> <p>Edit 2 </p> <p>Hmm, I don't think that helped... Now I can get JSON from the webservice, but the JSON web helper only seems to help if you have some JSON data already. I'm just not sure how to get that JSON data which I can then use the JSON Helper to convert it (decode) into a class.</p> <p>So I guess my question now is, how do I get JSON data and then bridge that to WebMatrix/Razor for use in a WebGrid?</p>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. USCommunity
    1. USDarren
    plurals
    1. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POWhat is the best way in WebMatrix to query WCF services?
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POWhat is the best way in WebMatrix to query WCF services?
      1. USKnox
      1. VTFavorite
    1. CODo you want to call the service from the client or the server?
      singulars
      1. POWhat is the best way in WebMatrix to query WCF services?
      1. USSLaks
    2. COI don't really have a preference, I guess I just want to do what is considered best practice...
      singulars
      1. POWhat is the best way in WebMatrix to query WCF services?
      1. USDarren
    3. COIt completely depends on what you're trying to do.
      singulars
      1. POWhat is the best way in WebMatrix to query WCF services?
      1. USSLaks
 

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