Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>As requested by @joshcomley, an automated answer using the TempData approach:</p> <p>This assumes that you have a BaseController and your controllers are inheriting from it.</p> <pre><code>public class AjaxianController : /*Base?*/Controller { private const string AjaxTempKey = "__isAjax"; public bool IsAjax { get { return Request.IsAjaxRequest() || (TempData.ContainsKey(AjaxTempKey)); } } protected override RedirectResult Redirect(string url) { ensureAjaxFlag(); return base.Redirect(url); } protected override RedirectToRouteResult RedirectToAction(string actionName, string controllerName, System.Web.Routing.RouteValueDictionary routeValues) { ensureAjaxFlag(); return base.RedirectToAction(actionName, controllerName, routeValues); } protected override RedirectToRouteResult RedirectToRoute(string routeName, System.Web.Routing.RouteValueDictionary routeValues) { ensureAjaxFlag(); return base.RedirectToRoute(routeName, routeValues); } private void ensureAjaxFlag() { if (IsAjax) TempData[AjaxTempKey] = true; else if (TempData.ContainsKey(AjaxTempKey)) TempData.Remove(AjaxTempKey); } } </code></pre> <p>To use this, make your controller inherit from AjaxianController and use the "IsAjax" property instead of the IsAjaxRequest extension method, then all redirects on the controller will automatically maintain the ajax-or-not flag.</p> <p>...</p> <p>Havn't tested it though, so be wary of bugs :-)</p> <p>...</p> <p>Another generic approach that doesn't require using state that I can think of may requires you to modify your routes.</p> <p>Specifically, you need to be able to add a generic word into your route, i.e.</p> <pre><code>{controller}/{action}/{format}.{ajax}.html </code></pre> <p>And then instead of checking for TempData, you'd check for RouteData["ajax"] instead.</p> <p>And on the extension points, instead of setting the TempData key, you add "ajax" to your RouteData instead.</p> <p>See <a href="https://stackoverflow.com/questions/255876/asp-net-mvc-routes-with-file-extensions">this question on multiple format route</a> for more info.</p>
    singulars
    1. This table or related slice is empty.
    1. POIs there a way to maintain IsAjaxRequest() across RedirectToAction?
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USCommunity
    1. USchakrit
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POIs there a way to maintain IsAjaxRequest() across RedirectToAction?
      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. VTAcceptedByOriginator
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. CO@chakrit - thanks, actually a solution like this had occurred to me whereby I inject the new isAjax parameter in on the overridden RedirectToAction method. But then I (initially) scrapped it due to the fact that when you do something like RedirectToAction("Home", new { id = 1 }), MVC uses reflection to figure out what should be in the route values and I didn't fancy injecting properties into an object. But of course that just boils down to the RedirectToAction() that takes a RouteValueCollection, at which point it should be easy to inject a new value. I was just being a complete moron! Thanks!
      singulars
      1. PO
      1. USjoshcomley
    2. CO@chakrit (and anyone else) - I've gone down pretty much this route, but without using TempData, which I think is cleaner. I'll probably blog about the final solution in the coming weeks and put a link to the blog on here :) but for all intents and purposes this was the answer I was looking for!
      singulars
      1. PO
      1. USjoshcomley
    3. CO@joshcomley When you're done don't forget to share it with the rest of us :-)
      singulars
      1. PO
      1. USchakrit
 

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