Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>How about a TransferResult class? (based on <a href="https://stackoverflow.com/questions/799511/how-to-simulate-server-transfer-in-asp-net-mvc/892545#892545">Stans answer</a>)</p> <pre><code>/// &lt;summary&gt; /// Transfers execution to the supplied url. /// &lt;/summary&gt; public class TransferResult : ActionResult { public string Url { get; private set; } public TransferResult(string url) { this.Url = url; } public override void ExecuteResult(ControllerContext context) { if (context == null) throw new ArgumentNullException("context"); var httpContext = HttpContext.Current; // MVC 3 running on IIS 7+ if (HttpRuntime.UsingIntegratedPipeline) { httpContext.Server.TransferRequest(this.Url, true); } else { // Pre MVC 3 httpContext.RewritePath(this.Url, false); IHttpHandler httpHandler = new MvcHttpHandler(); httpHandler.ProcessRequest(httpContext); } } } </code></pre> <p><strong>Updated:</strong> Now works with MVC3 (using code from <a href="https://stackoverflow.com/questions/799511/how-to-simulate-server-transfer-in-asp-net-mvc/1242525#1242525">Simon's post</a>). It <em>should</em> (haven't been able to test it) also work in MVC2 by looking at whether or not it's running within the integrated pipeline of IIS7+.</p> <p>For full transparency; In our production environment we've never use the TransferResult directly. We use a TransferToRouteResult which in turn calls executes the TransferResult. Here's what's actually running on my production servers.</p> <pre><code>public class TransferToRouteResult : ActionResult { public string RouteName { get;set; } public RouteValueDictionary RouteValues { get; set; } public TransferToRouteResult(RouteValueDictionary routeValues) : this(null, routeValues) { } public TransferToRouteResult(string routeName, RouteValueDictionary routeValues) { this.RouteName = routeName ?? string.Empty; this.RouteValues = routeValues ?? new RouteValueDictionary(); } public override void ExecuteResult(ControllerContext context) { if (context == null) throw new ArgumentNullException("context"); var urlHelper = new UrlHelper(context.RequestContext); var url = urlHelper.RouteUrl(this.RouteName, this.RouteValues); var actualResult = new TransferResult(url); actualResult.ExecuteResult(context); } } </code></pre> <p>And if you're using <a href="http://mvccontrib.codeplex.com/wikipage?title=T4MVC" rel="noreferrer">T4MVC</a> (if not... do!) this extension might come in handy.</p> <pre><code>public static class ControllerExtensions { public static TransferToRouteResult TransferToAction(this Controller controller, ActionResult result) { return new TransferToRouteResult(result.GetRouteValueDictionary()); } } </code></pre> <p>Using this little gem you can do</p> <pre><code>// in an action method TransferToAction(MVC.Error.Index()); </code></pre>
    singulars
    1. This table or related slice is empty.
    1. POHow to simulate Server.Transfer in ASP.NET MVC?
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USCommunity
    1. USMarkus Olsson
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POHow to simulate Server.Transfer in ASP.NET MVC?
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COthis works great. be careful not to end up with an infinite loop - as i did on my first attempt by passing the wrong URL in. i made a small modification to allow a route value collection to be passed in which may be useful to others. posted above or below...
      singulars
      1. PO
      1. USSimon_Weaver
    2. COupdate: this solution seems to work well, and although I am using it only in a very limited capacity haven't yet found any issues
      singulars
      1. PO
      1. USSimon_Weaver
    3. COone issue: cannot redirect from POST to GET request - but thats not necessarily a bad thing. something to be cautious of though
      singulars
      1. PO
      1. USSimon_Weaver
 

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