Databases
StackOverflow2013
Postsdbo
POCustom routing in WCF data services
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POCustom routing in WCF data services
    primarykey
    data
    text
    <p>I need to create a custom route for a WCF data service that contains a segment that must be extracted for use in filtering data. </p> <p>Example:</p> <p><a href="http://mysample.net/mysamplesvc/client123/Users" rel="nofollow">http://mysample.net/mysamplesvc/client123/Users</a></p> <p>I need to extract the client123 from the route. It looks like the Route class might provide something similar but I am not sure how to implement an IRouteHandler for a Data service.</p> <p>Is this the correct path? Are there good examples around?</p> <p>TIA!</p> <p>UPDATE:</p> <p>I have managed to achieve the solution I needed via some custom URL re-writing in the IDispatchMessageInspector. The below code is my initial hack and needs a bunch of clean-up. but, it appears to be working. If anybody sees anything galringly wrong, please let me know.</p> <pre><code> public object AfterReceiveRequest(ref System.ServiceModel.Channels.Message request, IClientChannel channel, InstanceContext instanceContext) { HttpRequestMessageProperty httpmsg = (HttpRequestMessageProperty)request.Properties[HttpRequestMessageProperty.Name]; ...Additional logic for handling Query formats in OData UriTemplate template = new UriTemplate("mysamplesvc/{ClientId}", true); Uri prefix = new Uri(HttpContext.Current.Request.Url.GetLeftPart(UriPartial.Authority)); Uri uri = new Uri(HttpContext.Current.Request.Url.AbsoluteUri); UriTemplateMatch results = template.Match(prefix, uri); if (results != null &amp;&amp; !string.IsNullOrEmpty(results.BoundVariables["ClientId"])) { _clientId = results.BoundVariables["clientId"].ToString(); } if (!string.IsNullOrEmpty(_clientId)) { httpmsg.Headers.Add("ClientId", _clientId); rewriteRequest(); } return null; } private void rewriteRequest() { if (HttpContext.Current != null &amp;&amp; HttpContext.Current.Session != null) { if (WebOperationContext.Current.IncomingRequest.UriTemplateMatch != null) { Uri serviceUri = HttpContext.Current.Session["ServiceUri"] as Uri; Uri requestUri = null; UriTemplateMatch match = WebOperationContext.Current.IncomingRequest.UriTemplateMatch; if (serviceUri == null) { UriBuilder serviceUriBuilder = new UriBuilder(match.BaseUri); serviceUri = serviceUriBuilder.Uri; HttpContext.Current.Session["ServiceUri"] = serviceUri; } if (serviceUri != null) { OperationContext.Current.IncomingMessageProperties["MicrosoftDataServicesRootUri"] = serviceUri; UriBuilder requestUriBuilder = new UriBuilder(match.RequestUri); string path = string.Empty; if (match.RelativePathSegments[0] == _clientId) { foreach (var seg in match.RelativePathSegments.Select((x, i) =&gt; new { Value = x, Index = i })) { if (seg.Index != 0) { path += "/"; path += seg.Value; } } } else { foreach (var seg in match.RelativePathSegments.Select((x, i) =&gt; new { Value = x, Index = i })) { path += "/"; path += seg.Value; } } UriBuilder serviceUriBuilder = new UriBuilder(match.BaseUri + path); // because we have overwritten the Root URI, we need to make sure the request URI shares the same host // (sometimes we have request URI resolving to a different host, if there are firewall re-directs serviceUriBuilder.Host = serviceUri.Host; requestUri = serviceUriBuilder.Uri; OperationContext.Current.IncomingMessageProperties["MicrosoftDataServicesRequestUri"] = requestUri; OperationContext.Current.IncomingMessageProperties["Via"] = requestUri; } } } } </code></pre> <p>Thanks all!</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USRockyMountainHigh
    1. USRockyMountainHigh
    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. POCustom routing in WCF data services
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POCustom routing in WCF data services
      1. USRockyMountainHigh
      1. VTBountyStart
    3. VO
      singulars
      1. POCustom routing in WCF data services
      1. This table or related slice is empty.
      1. VTUpMod
    1. COwhat does `client123` represent in your domain? A typical scenario would be `http://mysample.net/mysamplesvc/Users?client=client123` but I guess it's not what you are after?
      singulars
      1. POCustom routing in WCF data services
      1. USoleksii
    2. CO@oleksii: It is actually a client or tenant for our saas offering. The idea is to require this id and requiring it via a query parameter seems a little awkward and does not match what we do with our other RESTful services.
      singulars
      1. POCustom routing in WCF data services
      1. USRockyMountainHigh
    3. COI am really stuck with this. I have tried acheiving this route by registering a serviceroute as well. the problem with that is that placeholders do not appear to be supported in service route. Please help! :-D
      singulars
      1. POCustom routing in WCF data services
      1. USRockyMountainHigh
 

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