Monday, March 11, 2013

Get Exception details recursively

public static string GetExceptionDetailsRecursively(Exception e)
        {
            StringBuilder sb = new StringBuilder();

            while (e != null)
            {
                sb.Append("Inner :");
                sb.Append(e.Message);
                sb.Append("\t");
                e = e.InnerException;
            }

            return sb.ToString();
        }

How to get all notes comma separated group by customer


SQL Query - How to get all notes comma separated group by customer

NoteKey CustomerKey Note LastEditedTime
1 18736673 Accout access error, Contact Technical team. 01/02/2013


SELECT n1.CustomerKey, (SELECT ','+  n2.Note+ ' Last Edited Time:' + convert(varchar(26),n2.LastEditedTime)
       FROM Note n2
       WHERE n1.CustomerKey= n2.CustomerKey
       ORDER BY CustomerKey, Note  
       FOR XML PATH('')) AS CustNote
       FROM Note n1
Group By n1.CustomerKey


Thursday, February 14, 2013

For Beginners : How to compile a .cs file without visual studio


Generate a proxy of a WCF Service



SVCUTIL.exe is the tool used to generate proxy of a WCF Service class. A simple way of creating a proxy with all default options is :
  • Open Microsoft Visual Studio Command Prompt 2010.
  • svcutil.exe [assembly name]- This will generate the .wsdl & .xsd files.
  • svcutil *.wsdl *.xsd /language:C# - This will generate the proxy class(.cs file) and output.config file.
  • Add the proxy class to your client project and copy the content of the output.config file to App.Config file.

Tuesday, December 4, 2012

Web API Sample

This sample application demonstrates how to use Web API framework to return all posts from your blog in Json format. Web Api framework is Http based and can be accessed from broad range of clients like Browser, Mobile App etc.


What is new in ASP.NET 4.5

URL - http://www.asp.net/vnext/overview/aspnet/whats-new

Friday, November 23, 2012

Generic based Configuration Settings Reader


Interface to read any config file Implementation