$location in angularjs

$scope.EmployeeId = $location.search().employeeId ;

serialization and deserialization in C#

Serialization

// Creating emp object 
Employee Obj = new Employee () 
{ 
    Name = "Hamid", 
    Designation= "Software Engineer" 
}; 
 
// Convert Employee  object to JOSN string format 
string jsonDataTest = JsonConvert.SerializeObject(Obj); 
 
Response.Write(jsonDataTest);

Deserialization
Employee  obj= JsonConvert.DeserializeObject<Employee>(jsonDataTest ); 
 
Response.Write(obj.Name);

try parse guid in C#

Guid empGuidValue;

Guid.TryParse(empGuidStringValue, out empGuidValue);

expando object in C#

https://msdn.microsoft.com/en-us/library/system.dynamic.expandoobject(v=vs.110).aspx


http://www.c-sharpcorner.com/UploadFile/ca6c61/object-vs-dynamic-vs-var-and-expandoobject/

update multiple row if we have duplicate record in sql

UPDATE T1 SET Col1=Col1+CAST(EmpId AS VARCHAR)
WHERE EmpId NOT IN (
  SELECT MIN(EmpId)
  FROM T1
  GROUP BY Col1
);

add column if not exist in sql

IF not EXISTS (

SELECT * FROM sys.columns WHERE object_id = OBJECT_ID(N'Employee') AND name = 'Name'


) 
 Begin
 ALTER TABLE [Employee] ADD Name VARCHAR(200) NULL

end;

convert from string to enum in c#

var abc = (yourEnumName)Enum.Parse(typeof(yourEnumName), yourStringValue);