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();
}
Monday, March 11, 2013
Get Exception details recursively
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
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
Friday, November 23, 2012
Subscribe to:
Posts (Atom)