Tuesday, March 06, 2012

Icons used in Fiddler

What's the circular stop icon in fiddler denotes?

The default text coloring of the Session entries derives from the HTTP Status (red for errors, yellow for authentication demands), traffic type (CONNECT appears in grey), or response type (CSS in purple, HTML in blue; script in green, images in grey).

Icons and descriptions - http://docs.telerik.com/fiddler/knowledgebase/uiguide

Using PATINDEX in SQL Server

Returns the starting position of the first occurrence of a pattern in a specified expression, or zeros if the pattern is not found, on all valid text and character data types.

e.g. SELECT PATINDEX('%:%','22:30') will return 3 as the colon appears in that position.

Quite handy to figure out whether a pattern appears in the expression or not.

'The specified default EntityContainer name '' could not be found in the mapping and metadata information

This error normally occurs if the names for the CSDL, SSDL and MSL which is part of the Entity Framework mapping is correct in the App.config file.