Using async - await in different scenarios

While using asynchronous programming you might come across different scenarios. A few of those are explained here briefly.

async & await in C#

"async" and "await" are language level constructs in C# used for asynchronous programming. Keywords "async" and "await" and types Task and Task<T> together constitute the task based async model in .NET.

as and is in C#

These keywords are used in scenarios where there is compatible type conversion or we need to check for type compatibility.

Collate in SQL Server

Collate specifies the set of rules that are used during various comparisons, sorting etc. For example it specifies whether the comparisons should be case sensitive or not etc.

KoGrid with server side paging, sorting and filtering

Here is the code for implementing server side paging, sorting and filtering in koGrid (a.k.a. knockout grid). To see how to implement lazy loading in koGrid follow the link.

Committing against a workitem in VSTS

The detailed steps for creating a workitem in VSTS and committing against it in Git version control system are provided below :-

Sorting in Angular js controller (along with paging)

Considering the problem of sorting only a handful of items that are on the current page, I guess sorting using the "orderBy" filter inside ng-repeat tag is not a good idea. So the solution is to apply sorting in AngularJS controller and here is how you can do that.

Sorting in Angular JS along with paging - (in View)

Below is the code for applying sorting in Angular js table along with paging applied. In this code the sorting is done on the view only i.e. sorting is done using attributes in the ng-repeat tag itself.

Accessing properties and methods of an object in C# using Reflection

There might be situations where you want to loop through the members of an object or you want to create some generic means to access the members of one or more classes, so here is how you can access the members of an object in C# in a generic manner.

Calling a Oracle S.P. that is returning REFCURSOR through Entity Framework

Here are the steps for how to call Oracle S.P. that is returning REFCURSOR through Entity Framework :-