SQL Server Full Text Search

[-] LIKE search ‘Search%’ can use an index. LIKE search ‘%Search’ and ‘%Search%’ can not use an index, instead, it will cause a full table scan;

[-] CONTAINS is used to search for a particular word, phrase or prefix of word or phrase.

CONTAINS(Name, 'Mountain'); -- search a word
CONTAINS(Name, '"Mountain Road"'); -- search a phrase
CONTAINS(Name, 'Mountain*'); -- search a prefix of a word

[-] FREETEXT is used to search the meaning of the keyword rather than the exact word

ASP.Net MVC View Summary

[-] View is responsible for take data from controller and produce HTML
[-] Five Ways to Add Dynamic Content to a View: Inline code, HTML helpers, Server controls, Partial views, Child actions
[-] Keep view as simple as possible to reduce incline code
[-] HTML-Encode user input. HTML Encode means replacing each special character in the text (e.g., <) with its HTML entity equivalent (e.g., & l t ; ), which means it translate the original test into a HTML-Encoded format so that browser will display the original text, rather than render then into HTML elements.
[-] Use syntax on .Net 4 render value to HTML, framework will encode HTML for you if necessary.

Avoid Resubmit Issue Caused by Page Refresh(F5)

use Post/Redirect/Get pattern

http://en.wikipedia.org/wiki/Post/Redirect/Get

ASP.Net MVC Controller Summary

[-] Controller contains application logic. Servers as a bridge between the Web and your domain model.
[-] All controllers inherited from System.Web.Mvc.Controller, which implemet IController interface.
[-] Public method is called action method, which is mapped and can be invoked by a public URL.
[-] Action method is invoked with parameters extracted from the incoming request, including HTTP Get/Post data, route data…
[-] Action method returns Action results, which are objects describing the intended result of an action (e.g., rendering a view, or redirecting to a different URL oraction method).
[-] Get user input
- Directly from context Objects: Request.QueryString["paraName"] for HTTP Get data; Request.Form["paraName"] for HTTP Post Data
- Using Action Method Parameters: framework will use the parameter name (case sensitive) as key to search Request.QueryString, Request.Form, and RouteData.Values key-value dictionary and populate the value.
- Model Binding: the action parameter is an object. MVC will populate the object property using the context data with the same name.
[-] If the framework can’t find any match for a particular parameter, it will try to supply null for that parameter, which will cause exception for value type like int. Value-type parameters are inherently compulsory. Reference-type parameters are inherently optional.
[-] Pass data to view
- ViewData, key-value(any object) pair dictionary.
- ViewData.Model object
[-] Performing Redirections using RedirectToAction, Redirect
[-] Using TempData to Preserve Data Across a Redirection. TempData automatically removes themselves from the collection after you read them back.
[-] Returning Textual Data: XML, JSON, CSV, Plain text, JavaScript Commands using ContentResult type.
[-] Return Files and Binary Data
[-] using Filters(.net attributes) to Attach Reusable Behaviors: Authorization filter, Action filter, Result filter, Exception filter
[-] use Asynchronous Controllers to boost Server Capacity

VSS 2005 Branch and File Merge

VSS – Branch
1. Select the destination folder where branch will be created.
2. Right click and select “share to …”
3. In the dialog, select the source trunk project, and check “Branch after share”.

VSS – Merge File
1. Select the trunk/mainline file file you want to merge into. Then click menu “Version” – “Merge Branch”.
2. In the dialog, select the file you want to merge from, i.e. the branch file.

Truncate and Shrink Database Log File (SQL Server 2005)

The following script only works on SQL Server 2005. “TRUNCATE_ONLY” option is discontinued on SQL Server 2008.

BACKUP LOG <DatabaseName> WITH TRUNCATE_ONLY -- Truncate all inactive log space, this will not reduce the size of log file
DBCC SHRINKFILE('Logical_Log_Name') -- Reduce log file size
-- Do a full backup immediately after running the above command!!

Memory Limits for Windows Releases

http://msdn.microsoft.com/en-us/library/aa366778%28VS.85%29.aspx

ASP.Net MVC ULR Routing

[-] In ASP.Net MVC, URL is not mapped to physical files on the disk, they are mapped to controllers (classes in assembly) and action methods defined in the controller class.
[-] When you use MvcRouteHandler (default in ASP.NET MVC), you must provide value for routing parameter “controller” and “action”.
[-] routes.MapRoute: use routes.MapRoute method to register routes in RegisterRoutes method in Global.asax.cs. It’s better not to give name to route mappings.
[-] model binding: when an action method has a parameter with the same name of route parameter, the value of route parameter is automatically assigned to the action method parameter.
[-] Default parameter value and optional parameters
[-] URL pattern constraints: regular expression, HTTP methods
[-] Prioritizing Controller classes by namespace
[-] URL Pattern Wild Card
[-] URL pointing to static files on the file system will bypass the routing engine. But this can be changed by setting the RouteExistingFiles property flag.
[-] Using IgnoreRoute to define ULRs that will not go through route engine.
[-] Generating Hyperlinks (HTML a element) with Html.ActionLink(), the method taks controller and action name as parameter, and generates URLs based on the route collection.
[-] Performing Redirections to Generated URLs using RedirectToAction or RedirectToRoute
[-] Use Area to divide website into different sections.
[-] Generate Linking to an Action in same area, different area and root area.
[-] avoid Ambiguous Controller by add namespace to the root route entry.

ASP.Net MVC Request Processing Pipeline

1. IIS
- IIS route HTTP request to the right web application (website or virtual directory).
- Web application invoke the ASP.Net module if the url type is registed with ASP.Net
- ASP.Net receives the request, invoke all the HTTP module in sequence to process the request

2. Core Routing
- HTTP Module UrlRoutingModule invoke System.Web.Routing to route the request.
- If the URL is mapped to a static file on disk (e.g. .jpg .css .js), core routing bails out, leaving IIS to handle that request natively. ASP.NET Web Forms .aspx pages will be executed in the normal way (page life cycle)
- If the incoming URL doesn’t correspond to a file on disk (e.g., requests for MVC controllers, which are .NET types), core routing will try to find the matching route handler based on the active Routing Configurations (System.Web.Routing.RouteTable.Routes entries, search from top to bottom)

3: Controllers and Actions
- If core routing find the controller, it parse the request parameters from URL and prepare the request data package, and create controller instance by MvcRouteHandler using a controller factory object.
- The action method in the controller is invoked based on the URL pattern.
- Action method will return a ActionResult, which can be ViewResult (render HTML page), RedirectToRouteResult (redirect to another URL) or others.
- Filters may be applied to inject extra logic that runs before or after action methods, or before or after action results are executed.

[jQuery] Frequently used jQuery functions

Selectors
- Attribute Contains Selector [name*=value]
- Attribute Ends With Selector [name$=value]
- Attribute Equals Selector [name=value]