07 October 2015

Shadowing in C#

›
In Method override   both methods (base & child class methods) have the same name, same number and same type of parameter in the same ...
10 September 2015

ref vs out in C#

›
While writing a code, we often come across situations where we need to return multiple values from a single function/method. But a method ca...
09 September 2015

.js vs .min.js

›
They are both the same functionally but the .min has all unnecessary characters (white-spaces and comments stripped out, shorter variable na...

Extension Methods in C#.Net

›
Extension methods are a new feature in C# 3.0 You can use extension methods to extend a class/interface, but not to override them. Ext...
24 August 2015

.xlsx sheet data to datatable in C#

›
using System.Data.OleDb; string qry = "Select * from [Sheet1$]"; string excelConnectionString = @"Provider=Microsoft.ACE.OLED...
18 August 2015

Search a column in a table

›
SELECT t.name AS table_name, SCHEMA_NAME(schema_id) AS schema_name, c.name AS column_name FROM sys.tables AS t INNER JOIN sys.columns c ON t...
14 August 2015

Delegates

›
It is not compulsory to create delegates. It is just the easiest way in some situations to get the thing done. If you have multiple methods ...
12 August 2015

The Global Assembly Cache (GAC)

›
Global - Applies to the entire machine Assembly - code-libraries (DLLs) Cache – Place to store things for common access GAC is a com...
07 August 2015

Struct Vs Class in C#

›
Structs may seem similar to classes Members of a class are private by default and members of struct are public by default. When derivi...
21 May 2015

Sql Query vs Linq to Sql Query VS Entity Query

›
select NAME as names from dbo.MASTER where NAME like '%value%' IList<string> names = (from OM in dbo.MASTER where OM.NAME.Cont...

Left vs right join in linq to sql

›
Here's how you do a left join in Linq: var results = from tbl1 in table1 join tbl2 in table2 on tbl1.User equals tbl2.User into joined f...
19 May 2015

orderby in linq to sql

›
SELECT DISTINCT UNIVERSE FROM dbo.MASTER ORDER BY UNIVERSE from M in dbo.MASTER where M.UNIVERSE != null orderby M.UNIVERSE select new { M.U...
12 May 2015

Difference between substring and substr in JavaScript

›
substr takes parameters as (from, length). substring takes parameters as (from, to). alert("abc".substr(1,2)); // returns "bc...
11 May 2015

Clustered & Non-Clustered Indexes in SqlServer

›
Suppose we have 16 million records. When we try to retrieve records for two or three customers based on their customer id, all 16 million re...
06 May 2015

Serialization vs DeSerialization

›
Serialization is the process of converting an object into some data format such as XML or stream of bytes in order to store the object to a ...