Microsoft SQL Server T-SQL date and datetime formats
[crayon-6647816e386ac281670817/]
Read moreAuthor: Vivek More
Testing Routing and URL Generation in ASP.NET MVC
In ASP.NET MVC, getting your routes setup properly can be tricky if you have a lot of routes. Whenever something is tricky, and might be touched often, having a set of unit tests around it can very helpful to ensure you aren't breaking it when you make changes. Lots of
Read moreHow to Generate Machine Key in IIS7
Open your IIS Manager from Administrative tool -> Internet Information Services Manager. In Connection pane on left side of window, click on the website. Double click on Machine Key icon as shown below. You will see Machine key page, default encryption method is SHA1, you can change it from dropdown list as shown. Click
Read moreSQL SERVER – List all the database
EXEC sp_databasesEXEC sp_helpdb ----SQL 2000 Method still works in SQL Server 2005SELECT nameFROM sys.databasesSELECT nameFROM sys.sysdatabases ----SQL SERVER Un-Documented ProcedureEXEC sp_msForEachDB 'PRINT ''?'''
Read moreEasily Share to Social Media using Links
Facebook To create the link, use the following formula: http://www.facebook.com/sharer.php?u=URL can be created with the following html code [crayon-6647816e399d4916724578/] Twitter To create the link, use the following formula: http://twitter.com/share?text=TEXT&url=URL [crayon-6647816e399db481491102/] Google plus To create the link, use the following formula: https://plus.google.com/share?url=URL [crayon-6647816e399de310382390/]
Read moreC# Display Name From Property Using Reflection
Getting the Display Name Attribute Value From a Property [crayon-6647816e39cd5406446617/] MetadataType Display Names With generated ORM models Microsoft added another layer of indirectly by creating the metadata class attribute. [crayon-6647816e39cdf297431186/] In order to grab the meta data display name, you have to traverse the MetadataType attribute: [crayon-6647816e39ce3437841775/] Display Name Utility ClassFor completeness, here is my display name
Read moreASP.NET MVC – Default Model Binder with HTML Validation
This post demonstrates how we can handle gracefully the HTTP request validation which exists in ASP.NET, when using ASP.NET MVC. Request validation is a feature in ASP.NET that examines an HTTP request and determines whether it contains potentially dangerous content. For example, if a user tries to input some malicious
Read moreException or Error Handling and Logging in MVC4
HandleError Attribute [crayon-6647816e3a58e757849033/] HandleError Attribute at Action Method Level [crayon-6647816e3a596708889550/] HandleError Attribute at Controller Level [crayon-6647816e3a599256203292/] HandleError Attribute at Global Level [crayon-6647816e3a59d950105542/] Extending HandleError Filter for logging and handling more errors [crayon-6647816e3a5a0977995948/]
Read moreSQL Server Find and Replace Values in All Tables and All Text Columns
The only thing that needs to change to run this script are the database where you want this to run and the values for these two parameters: @stringToFind @stringToReplace [crayon-6647816e3a8fe905447786/]
Read moreA Cool New ‘Paste JSON As Classes’ Feature in ASP.NET Web Tools 2012.2 RC
Here’s a simple example:A) Copy to clipboard your JSON object.[crayon-6647816e3ab9b154210878/] B) In VS2012, open edit menu, choose ‘Past Special’ and click on ‘Past JSON As Classes’.The result:[crayon-6647816e3aba1698170745/] Of course it also supports more complex objects like Multi-Dimensional Arrays etc.
Read more