Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>The code is taken from <a href="http://blogs.microsoft.co.il/blogs/shay/archive/2009/03/06/real-world-error-hadnling-in-asp-net-mvc-rc2.aspx" rel="noreferrer">http://blogs.microsoft.co.il/blogs/shay/archive/2009/03/06/real-world-error-hadnling-in-asp-net-mvc-rc2.aspx</a> and works in ASP.net MVC 1.0 as well </p> <p>Here's how I handle http exceptions:</p> <pre><code>protected void Application_Error(object sender, EventArgs e) { Exception exception = Server.GetLastError(); // Log the exception. ILogger logger = Container.Resolve&lt;ILogger&gt;(); logger.Error(exception); Response.Clear(); HttpException httpException = exception as HttpException; RouteData routeData = new RouteData(); routeData.Values.Add("controller", "Error"); if (httpException == null) { routeData.Values.Add("action", "Index"); } else //It's an Http Exception, Let's handle it. { switch (httpException.GetHttpCode()) { case 404: // Page not found. routeData.Values.Add("action", "HttpError404"); break; case 500: // Server error. routeData.Values.Add("action", "HttpError500"); break; // Here you can handle Views to other error codes. // I choose a General error template default: routeData.Values.Add("action", "General"); break; } } // Pass exception details to the target error View. routeData.Values.Add("error", exception); // Clear the error on server. Server.ClearError(); // Avoid IIS7 getting in the middle Response.TrySkipIisCustomErrors = true; // Call target Controller and pass the routeData. IController errorController = new ErrorController(); errorController.Execute(new RequestContext( new HttpContextWrapper(Context), routeData)); } </code></pre>
    singulars
    1. This table or related slice is empty.
    1. POHow can I properly handle 404 in ASP.NET MVC?
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USEduardo Molteni
    1. USShay Jacoby
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POHow can I properly handle 404 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. VTAcceptedByOriginator
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COI'd like to add that this is fairly easy to write unit tests for the above code as well. I only had to make a few small changes. +1
      singulars
      1. PO
      1. USPage Brooks
    2. COI'm not sure I understand why you're checking for an httpException. isn't the point of this handler to catch - for instance - a NullReferenceException and then GENERATE an http exception. when would Server.GetLastError() ever actually be an HttpException unless you had made an Http call within your actual business logic. i removed this from my implementation but would love to know if it is justified and i missed something
      singulars
      1. PO
      1. USSimon_Weaver
    3. COupdate: checking for an http 404 is definitely required, but i'm still not quite sure when you'd ever get a 500. also you need to also explicitly set the Response.StatusCode = 404 or 500 otherwise google will start indexing these pages if you are returning a 200 status code which this code currently does
      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