Get display name of enum

Problem:
How to get Display name or Description of Enum.

Solution:
I made on extension helper to get display name or description  of Enum.


Usage:

var weekofday = Days.Sun; 

Console.WriteLine(weekofday.ToDisplayName()); 

Console.WriteLine(weekofday.ToDescription());

public enum Days
{
    [Display(Name = "Sunday")]
    [Description("First day of week.")]
    Sun,
    [Display(Name = "Monday")]
    Mon,
    [Display(Name = "Tuesday")]
    Tue,
    [Display(Name = "Wednesday")]
    Wed,
    [Display(Name = "Thursday")]
    Thu,
    [Display(Name = "Friday")]
    Fri,
    [Display(Name = "Saturday")]
    Sat
}

Output:

Sunday
First day of week. 

Enum Helper:

using System;
using System.Linq;
using System.ComponentModel.DataAnnotations;
using System.ComponentModel;
 
namespace TestWinApp
{
    public static class EnumHelper
    {
        #region Public Method
 
        // This extension method is broken out so you can use a similar pattern with 
        // other MetaData elements in the future. This is your base method for each.
        //In short this is generic method to get any type of attribute.
        public static T GetAttribute<T>(this Enum value) where T : Attribute
        {
            var type = value.GetType();
            var memberInfo = type.GetMember(value.ToString());
            var attributes = memberInfo[0].GetCustomAttributes(typeof(T), false);
            return (T)attributes.FirstOrDefault();//attributes.Length > 0 ? (T)attributes[0] : null;
        }
 
        // This method creates a specific call to the above method, requesting the
        // Display MetaData attribute.
        //e.g. [Display(Name = "Sunday")]
        public static string ToDisplayName(this Enum value)
        {
            var attribute = value.GetAttribute<DisplayAttribute>();
            return attribute == null ? value.ToString() : attribute.Name;
        }
 
        // This method creates a specific call to the above method, requesting the
        // Description MetaData attribute.
        //e.g. [Description("Day of week. Sunday")]
        public static string ToDescription(this Enum value)
        {
            var attribute = value.GetAttribute<DescriptionAttribute>();
            return attribute == null ? value.ToString() : attribute.Description;
        }
 
        #endregion
    }
}

MySQL – 'mysql' is not recognised as an internal or external command

Problem:

'mysql' is not recognized as an internal or external command, operable program or batch file.

Solution:
To solve the above the error message, please follow the below steps:

1. Open Control Panel
2. Then open System and Click on Advanced system Settings
3. Select “Advanced” Tab and click on Environment Variables
4. In System variables, Select Path and Click on Edit button. At the end of Variable value text box, write the path of MySQL bin directory.

For example

C:\Program Files\MySQL\MySQL Server 5.6\bin;

How to get the row count of all tables in a SQL SERVER

1) Using  sp_MSForEachTable SP

sp_MSForEachTable 'DECLARE @t AS VARCHAR(MAX); 
SELECT @t = CAST(COUNT(1) as VARCHAR(MAX)) 
+ CHAR(9) + CHAR(9) + ''?'' FROM ? ; PRINT @t';

Output:  

2) Using System Table.
 

SELECT 
    sc.name +'.'+ ta.name TableName, SUM(pa.rows) RowCnt
FROM 
    sys.tables ta
INNER JOIN sys.partitions pa
    ON pa.OBJECT_ID = ta.OBJECT_ID
INNER JOIN sys.schemas sc
    ON ta.schema_id = sc.schema_id
WHERE 
 ta.is_ms_shipped = 0 AND pa.index_id IN (1,0)
GROUP BY 
 sc.name,ta.name
ORDER BY 
 SUM(pa.rows) DESC

 

Output:  

No set method for property in WCF service

Problem:

I have some class that I'm passing as a result of a service method, and that class has a get-only property:
 

public string PropertyName
{
    get
    {
        return "Some Value";
    }    
}

 I'm getting an exception on service side "No set method for property"

Solution:

Remember that WCF needs to create an instance of the object from its serialized representation (often XML) and if the property has no setter it cannot assign a value. Objects are not transferred between the client and the server but only serialized representations, so the object needs to be reconstructed at each end.

Make setter property private. So, client can never see the set method on your property acting much like a read only property. 

public string PropertyName
{
    get
    {
        return "Some Value";
    }
    private set
    { }
}

C# datetime formatting separators issue

Problem:

Console.WriteLine(DateTime.Now.ToString("MM/dd/yyyy"));  

Output:

08-28-2013 

Expected output: 

08/28/2013

Solution:

Console.WriteLine(DateTime.Now.ToString("MM/dd/yyyy", CultureInfo.InvariantCulture));

Reason,

If a CultureInfo is not specified, the current culture will be used.

If this is a culture that doesn't use slashes as separators in dates and 

the format string specifies the date separator to be a /, that is replaced 

by whatever the actual culture date separator is –

WCF: The maximum array length quota (16384) has been exceeded while reading XML data

Error:

"The maximum array length quota (16384) has been exceeded while reading XML data. This quota may be increased by changing the MaxArrayLength property on the XmlDictionaryReaderQuotas object used when creating the XML reader."

Solution:

Try to change config file:

Add <readerQuotas> and set maxArrayLength="2147483647"

<binding name="WSHttpBinding_IBackup"
         closeTimeout="1:00:00"
         maxBufferPoolSize="2147483647"
         maxBufferSize="2147483647"
         maxReceivedMessageSize="2147483647"
         openTimeout="1:00:00"
         receiveTimeout="1:00:00"
         sendTimeout="1:00:00"
         transferMode="Streamed">
 
  <readerQuotas
    maxArrayLength="2147483647"
    maxBytesPerRead="2147483647"
    maxDepth="2147483647"
    maxNameTableCharCount="2147483647"
    maxStringContentLength="2147483647" />
 
  <!--if any issue then try this one-->
  <!--<textMessageEncoding messageVersion="Soap11" 
                       maxReadPoolSize="2147483647" 
                       maxWritePoolSize="2147483647">
    <readerQuotas
      maxArrayLength="2147483647"
      maxBytesPerRead="2147483647"
      maxDepth="2147483647"
      maxNameTableCharCount="2147483647"
      maxStringContentLength="2147483647" />
  </textMessageEncoding>-->
 
</binding>

If you have same issue then try following solution.

Reason:-

• My service is simply ignoring my binding “basicHttp_ServiceName” and it’s always taking default binding
• Reason is
  
  • My configuration service name does not match with service name in Service Host
  • The name I given is "ServiceName" where it has to be "XYZ.ServiceName"
  • E.g.
    

    <%@ ServiceHost Language="C#" 
                    Debug="true" 
                    Service="XYZ.ServiceName" 
                    CodeBehind="ServiceName.svc.cs" %>
    
    

Fix :-

• Right click your “.svc” file and choose “View Markup”
• Copy the Service name and paste it in your service name
• Now my Service configuration looks below
• E.g
  

   <services>
      <service name="XYZ.ServiceName">
   
      </service>
    </services>

Cannot login to network server in sql server

GO to "Sql Server Configuration Manager"

Select Sql server Services

Check following service are running
- Sql Server(Instance Name)
- Sql Server Browser

Go to "Sql Server Network Configuration"
- Select Protocol for <Instance Name>

 Now check TCP/IP and Named Pipes is Enable.

and make sure Your system Firewall should not block SQL Server port. SQL SERVER port is by Default 1433