/* ------------------------ My Meta Content Here SEO ------------------------ */

Pages

Main Menu

Saturday, November 16, 2019

Fill Factor in sql server performance tuning server level, index/table level

Fill Factor:

Working in performance tuning area, one has to know about Index and Index Maintenance. For any Index the most important property is Fill Factor. Fill Factor is directly related to Indexes.

Fill factor is the value that determines the percentage of space on each leaf-level page to be filled with data. In an SQL Server, the smallest unit is a page, which is made of Page with size 8K.

A page is the basic unit of data storage in SQL server. Its size is 8KB(8192 bytes). Data is stored in the leaf-level pages of Index. The percentage of space to be filled with data in a leaf level page is decided by fill factor. The remaining space left is used for future growth of data in the page. Fill factor is a number from 1 to 100. Its default value is 0, which is same as 100. So when we say fill factor is 70 means, 70% of space is filled with data and remaining 30% is vacant for future use. So higher the fill factor, more data is stored in the page. Fill factor setting is applied when we create/rebuild index.

Page Split:

Page split occurs, when there is no more space to accommodate data in leaf-level pages. Page split is movement of data from one page to another page, when data changes in the table.

Fill factor and its effect on performance:

From above, we have gathered some idea about fill factor. Now let see how fill factor can performance. From above discussion we can say if we have higher value of fill factor, we can save more data in a page. By storing more data in less space, we can save memory, resource uses(like IO, CPU).

But downside of it is page split. Page split hamper performance.

Now let us discuss about low value of fill factor. By setting low value of fill factor, page split can be avoided. But it will need more memory(although memory is cheap now), more resource uses. Let say we have a table where the data was fit in 50 pages when the fill factor setting was 100 or 0. Now let say we reduced the fill factor to 50. So it will take 100 pages. When we need to read all the rows, the number of read is doubled now.

How to decide fill factor?

What is correct value of fill factor, we need to set for better performance ? There is no specific answer. It depend upon your application. You are the best person to decide its value. Below is the criteria you need to consider while choosing fill factor.

1:For static/look-up table: This type of tables have static data means data changes very rarely in the table. So we can set high value of fill factor means 100 or 0.

2:For Dynamic table: In this type of table, data get changes(inserted/updated) frequently. So we need to set low fill factor, between 80 to 90.

3:For Table with Clustered Index on Identity Column: Here the data is inserted at the end of the table always. So we can have higher value of fill factor between 95 to 100.

How to set Fill factor ? We can set fill factor in 2 ways 

1) Server level:

A generic fill factor setting is applied at the server level for all table/index. To see what is the current current default fill factor set at the server level, you can use below script.
 
Hide Copy Code​EXEC [sys].[sp_configure] 'fill factor' GO

You can set a server level default fill factor by using sp_configure with a parameter as below script. Here are setting a fill factor value of 90.
EXEC sys.sp_configure 'fill factor', 90 
GO 
RECONFIGURE WITH OVERRIDE 
GO

2) At Index/Table level: 

While creating/rebuilding index we can set a specific fill factor. We can use below script to set fill factor while rebuilding index.

USE YourDatabaseName 
GO 
ALTER INDEX YourIndexName ON [YourSchemaName].[YourTableName] 
REBUILD WITH (FILLFACTOR = 80); 
GO

Points of Interest

Index play an important role to increase the performance of the query. But it is not only the magic pain killer. As fill factor is related to Index, so it has some role on performance improvement. Before setting a fill factor, analyses your requirement, do experiment with different fill factor value and finally set correct value.

Measuring Counters

All of the above discussions lead us to think that a higher Fill Factor and high transaction server implies higher page split. However, Fill Factor can help us to reduce the number of the page splits as the new data will be accommodated in the page right away without much difficulty and further page splits. We can measure the page split by the watching performance monitor counter
“SQLServer:AccessMethods:Page Splits/Sec”.

Additionally, you can measure the same using the following sys query.

SELECT cntr_value FROM MASTER.dbo.sysperfinfo WHERE counter_name ='Page Splits/sec' AND OBJECT_NAME LIKE'%Access methods%'

Fill factor is usually measured at the server level as well as table level. Below we have the scripts for the same.

Here is the script to measure the Fill Factor at the server level:

SELECT * FROM sys.configurations WHERE name ='fill factor (%)'

And, here is the script to measure the Fill Factor at the table/index level:

USE YourDatabaseName; SELECT OBJECT_NAME(OBJECT_ID) Name, type_desc, fill_factor FROM sys.indexes

SQL SERVER – Set Server Level FILLFACTOR Using T-SQL Script

SQL SERVER - Set Server Level FILLFACTOR Using T-SQL Script fillfactor-800x633

SQL Script to set Server level FILL FACTOR to 90


EXEC sys.sp_configure 'show advanced options', '1'
RECONFIGURE WITH OVERRIDE
GO
EXEC sys.sp_configure 'fill factor (%)', '90'
GO
RECONFIGURE WITH OVERRIDE
GO
EXEC sys.sp_configure 'show advanced options', '0'
RECONFIGURE WITH OVERRIDE
GO

For Example Using a table named tblTransactionTable.

The image below displays the sp_spaceused command and the output from the command to display table information such as space used for the table and the underlying indexes. This table has 11.7 million rows and there are no indexes currently on this table.
sql query

Step 1 - High Fill Factor Value

From SQL Server Management Studio, I am creating a non-clustered index with one column, CustomerID, as the Index Key.
new index
I then move to the Options page and set the Fill Factor to 100 %. If the value for the fill factor is not set, the index is created using the value from the default index fill factor value set at the instance level. Remember that a value of 0 and 100 are both same and the page will be completely filled. For this example we will ignore the other options on this page. I finish creating the index by clicking OK.
new index
After creating the index, I run sp_spaceused again to view the table information and find that the index size is now 327040 KB, where before it was 72KB before we created the index.
sql query
You might choose a high fill factor value when there is very little or no change in the underlying table's data, such as a decision support system where data modification is not frequent, but on a regular and scheduled basis. Such a fill factor value would be better, since it creates an index smaller in size and hence queries can retrieve the required data with less disk I/O operations since it has to read less pages.
On the other hand if you have an index that is constantly changing you would want to have a lower value to keep some free space available for new index entries. Otherwise SQL Server would have to constantly do page splits to fit the new values into the index pages.

Step 2 - Low Fill Factor Value

Next, I drop the index and create the same index with a change in the fill factor value set to 50. When I created the index earlier (in Step 1), I chose to script the create index task which is used in this step (image below) which will change the fill factor value to 50%.
sql query
The resulting index will be created with pages being 50% full. I check and confirm this by running sp_spaceused again which displays the table details. The image below is the result set displayed when the query is executed. Notice that the index size is now 651640 KB which is approximately twice the size of the index created earlier using fill factor as 100. Which makes sense since we left the pages half empty.
sql query
Using a fill factor value of less than 100 would be necessary in situations where data is added to the underlying indexes more frequently. With new data records added, the index pages need to have sufficient space to take the new entries. When there is not enough space a page split needs to occur which could impact performance depending on how frequently page splits need to occur.

Some points to be remembered

  • When 0 or 100 is specified, the page is filled to the maximum possible, not 100 % since a page may not accommodate the Index Key the final time and results in leaving that much empty space unused.
  • The size of the index is proportional to the columns that are used in the index, hence more columns (the limit being 16) will create a larger index and therefore require more index pages to store the index
  • Since indexes need storage space, creating an appropriate index along with the fill factor should be well planned.
  • Before finalizing a fill factor value, it should be tested and analyzed before deploying on the actual SQL Server.
Read More »

What is bit, nibble, byte, kilobyte, megabyte, gigabyte, terabyte, petabyte, exabyte, zettabyte, yottabyte etc.?


How much is 1 byte, kilobyte, megabyte, gigabyte, etc.?

Thanks to Computer Hope for sharing this knowledge.
Below is a list of each of the accepted disk drive space values. It is important to realize that not all manufacturers and developers list their value using binary, which is base 2. For example, a manufacturer may list a product's capacity as one gigabyte (1,000,000,000 bytes, a metric value) and not 1,073,741,824 bytes (gibibyte) that it actually is. For this page, we are using the "common names" and listing all values in base 2.
Note
All values are listed as whole numbers, which means a GB shows it can only contain one 650 MB CD. Technically, 1 GB could hold 1.5753 CDs worth of data, but this document isn't meant to show you how many "parts" of an object a value can hold. Therefore, we are omitting decimal values. More plainly, you can only fit one complete 650 MB CD on a 1 GB drive since two full 650 MB discs exceed 1 GB.
Tip
Except for a bit and a nibble, all values explained below are in bytes and not bits. For example, a kilobyte (KB) is different than a kilobit (Kb). When referring to storage, bytes are used whereas data transmission speeds are measured in bits.

Bit

Computer bit and byte
bit is a value of either a 1 or 0 (on or off).

Nibble

nibble is 4 bits.

Byte

Today, a byte is 8 bits.

Kilobyte (KB)

kilobyte is 1,024 bytes.
  • 2 or 3 paragraphs of text.

Megabyte (MB)

megabyte is 1,048,576 bytes or 1,024 kilobytes.
  • 873 pages of plain text (1,200 characters).
  • 4 books (200 pages or 240,000 characters).

Gigabyte (GB)

gigabyte is 1,073,741,824 (230) bytes. 1,024 megabytes, or 1,048,576 kilobytes.
  • 894,784 pages of plain text (1,200 characters).
  • 4,473 books (200 pages or 240,000 characters).
  • 640 web pages (with 1.6 MB average file size).
  • 341 digital pictures (with 3 MB average file size).
  • 256 MP3 audio files (with 4 MB average file size).
  • 1 650 MB CD.

Terabyte (TB)

terabyte is 1,099,511,627,776 (240) bytes, 1,024 gigabytes, or 1,048,576 megabytes.
  • 916,259,689 pages of plain text (1,200 characters).
  • 4,581,298 books (200 pages or 240,000 characters).
  • 655,360 web pages (with 1.6 MB average file size).
  • 349,525 digital pictures (with 3 MB average file size).
  • 262,144 MP3 audio files (with 4 MB average file size).
  • 1,613 650 MB CD's.
  • 233 4.38 GB DVDs.
  • 40 25 GB Blu-ray discs.

Petabyte (PB)

petabyte is 1,125,899,906,842,624 (250) bytes, 1,024 terabytes, 1,048,576 gigabytes, or 1,073,741,824 megabytes.
  • 938,249,922,368 pages of plain text (1,200 characters).
  • 4,691,249,611 books (200 pages or 240,000 characters).
  • 671,088,640 web pages (with 1.6 MB average file size).
  • 357,913,941 digital pictures (with 3 MB average file size).
  • 268,435,456 MP3 audio files (with 4 MB average file size).
  • 1,651,910 650 MB CD's.
  • 239,400 4.38 GB DVDs.
  • 41,943 25 GB Blu-ray discs.

Exabyte (EB)

An exabyte is 1,152,921,504,606,846,976 (260) bytes, 1,024 petabytes, 1,048,576 terabytes, 1,073,741,824 gigabytes, or 1,099,511,627,776 megabytes.
  • 960,767,920,505,705 pages of plain text (1,200 characters).
  • 4,803,839,602,528 books (200 pages or 240,000 characters).
  • 687,194,767,360 web pages (with 1.6 MB average file size).
  • 366,503,875,925 digital pictures (with 3 MB average file size).
  • 274,877,906,944 MP3 audio files (with 4 MB average file size).
  • 1,691,556,350 650 MB CD's.
  • 245,146,535 4.38 GB DVDs.
  • 42,949,672 25 GB Blu-ray discs.

Zettabyte (ZB)

zettabyte is 1,180,591,620,717,411,303,424 (270) bytes, 1,024 exabytes, 1,048,576 petabytes, 1,073,741,824 terabytes, 1,099,511,627,776 gigabytes, or 1,125,899,910,000,000 megabytes.
  • 983,826,350,597,842,752 pages of plain text (1,200 characters).
  • 4,919,131,752,989,213 books (200 pages or 240,000 characters).
  • 703,687,443,750,000 web pages (with 1.6 MB average file size).
  • 375,299,970,000,000 digital pictures (with 3 MB average file size).
  • 281,474,977,500,000 MP3 audio files (with 4 MB average file size).
  • 1,732,153,707,691 650 MB CD's.
  • 251,030,052,003 4.38 GB DVDs.
  • 43,980,465,111 25 GB Blu-ray discs.

Yottabyte (YB)

yottabyte is 1,208,925,819,614,629,174,706,176 (280) bytes, 1,024 zettabytes, 1,048,576 exabytes, 1,073,741,824 petabytes, 1,099,511,627,776 terabytes, 1,125,899,910,000,000 gigabytes, or 1,152,921,500,000,000,000 megabytes.
  • 1,007,438,183,012,190,978,921 pages of plain text (1,200 characters).
  • 5,037,190,915,060,954,894 books (200 pages or 240,000 characters).
  • 720,575,937,500,000,000 web pages (with 1.6 MB average file size).
  • 384,307,166,666,666,666 digital pictures (with 3 MB average file size).
  • 288,230,375,000,000,000 MP3 audio files (with 4 MB average file size).
  • 1,773,725,384,615,384 650 MB CD's.
  • 257,054,773,251,740 4.38 GB DVDs.
  • 45,035,996,273,704 25 GB Blu-ray discs.

Is there anything bigger than a yottabyte?

As of 2019, there are no approved standard sizes for anything bigger than a yottabyte. However, the two standards that have been proposed are the hellabyte or brontobyte.
Read More »

Tuesday, October 29, 2019

C# Interview Questions and Answers

Here is a list of most popular C# interview questions and answers with their details explaination and code examples. The interview questions are for both, beginners and professional C# developers. 
 

1. What is C#?

 
C# is a computer programming language. C# was created by Microsoft in 2000 to provide a modern general-purpose programming language that can be used to develop all kind of software targeting various platforms including Windows, Web, and Mobile using just one programming language. Today, C# is one of the most popular programming languages in the world. Millions of software developers use C# to build all kind of software. 
C# is the primary language for building Microsoft .NET software applications. Developers can build almost every kind of software using C# including Windows UI apps, console apps, backend services, cloud APIs, Web services, controls and libraries, serverless applications, Web applications, native iOS and Android apps, AI and machine learning software, and blockchain applications.
If you want to learn more about C# application types, read,
C# with the help of Visual Studio IDE, provides a rapid application development. C# is a modern, object-oriented, simple, versatile, and performance-oriented programming language. C# is developed based on the best features and use cases of several programming languages including C++, Java, Pascal, and SmallTalk. 
C# syntaxes are like C++. .NET and C# library is similar to Java. C# supports modern object-oriented programming language features including Abstraction, Encapsulation, Polymorphism, and Inheritance. C# is a strongly typed language and most types are inherited by the Object class.
C# supports concepts of classes and objects. Classes have members such as fields, properties, events, and methods. Here is a detailed article on C# and OOP. 
C# is versatile, modern and supports modern programming needs. Since its inception, C# language has gone through various upgrades. C# 8.0 is the latest build of C# language that is expected to release this year. Read the following article for some of the newest features of C#: 

2. What is an object in C#?

 
C# language is an object-oriented programming language. Classes are the foundation of C#. A class is a template that defines how a data structure will look like, how data will be stored, managed, and transferred. A class has fields, properties, methods, and other members.
While classes are concepts, objects are real. Objects are created using class instances. A class defines the type of an object. Objects store real values in computer memory.
Any real-world entity, which can have some characteristics, or which can perform some work is called as Object. This object is also called as an instance i.e. a copy of an entity in programming language. Objects are instances of classes.
For example, we need to create a program that deals with cars. We need to create an entity for the car. Let’s call it a class, Car. A car has four properties, i.e., model, type, color, and size.
To represent a car in programming, we can create a class Car with four properties, Model, Type, Color, and Size. These are called members of a class. A class has several types of members, constructors, fields, properties, methods, delegates, and events. A class member can be private, protected, and pubic. Since these properties may be accessed outside the class, these can be public.
An object is an instance of a class. A class can have as many instances as needed. For example, Honda Civic is an instance of Car. In real programming, Honda Civic is an object. Honda Civic is an instance of class Car. The Model, Type, Color, and Size properties of Honda Civic are Civic, Honda, Red, 4 respectively. BMW 330, Toyota Carolla, Ford 350, Honda CR4, Honda Accord, and Honda Pilot are some examples of objects of Car.
To learn more about real world example of objects and instance, please read

3. What is Managed or Unmanaged Code?

 
Managed Code
“The code is the code that is developed using the .NET framework and its supported programming languages such as C# or VB.NET. The manage code is directly executed by the Common Language Runtime (CLR or Runtime) and its lifecycle including object creation, memory allocation, and object disposal is managed by the Runtime. Any language that is written in .NET Framework is managed code”.

Unmanaged Code

The code, which is developed outside of the .NET framework is known as unmanaged code.

“Applications that do not run under the control of the CLR are said to be unmanaged. The languages such as C or C++ or Visual Basic are unmanaged. The object creation, execution, and disposal on unmanaged code is directly managed by the programmers. If programmers write bad code, it may lead to the memory leaks and unwanted resource allocations.”

The .NET Framework provides a mechanism for unmanaged code to be used in managed code and vice versa. The process is done with the help of wrapper classes.
Here is a detailed article on managed and unmanaged code.

4. What is Boxing and Unboxing in C#?

 
Boxing and Unboxing both are used for type conversions.
The process of converting from a value type to a reference type is called boxing. Boxing is an implicit conversion. Here is an example of boxing in C#.
  1. // Boxing  
  2. int anum = 123;  
  3. Object obj = anum;  
  4. Console.WriteLine(anum);  
  5. Console.WriteLine(obj); 
The process of converting from a reference type to a value type is called unboxing. Here is an example of unboxing in C#.
  1. // Unboxing  
  2. Object obj2 = 123;  
  3. int anum2 = (int)obj;  
  4. Console.WriteLine(anum2);  
  5. Console.WriteLine(obj);  
Check out these two articles to learn more about boxing and unboxing.

5. What is the difference between a struct and a class in C#?

 
Answer
Class and struct both are the user defined data type but have some major differences:

Struct
  • The struct is value type in C# and it inherits from System.Value Type.
  • Struct is usually used for smaller amounts of data.
  • Struct can’t be inherited to other types.
  • A structure can't be abstract.
  • No need to create object by new keyword.
  • Do not have permission to create any default constructor.
Class
  • The class is reference type in C# and it inherits from the System.Object Type.
  • Classes are usually used for large amounts of data.
  • Classes can be inherited to other class.
  • A class can be abstract type.
  • We can create a default constructor.
Read the following articles to learn more on structs vs classes.

6. What is the difference between Interface and Abstract Class in C#?

 
Answer
Here are some of the common differences between an interface and an abstract class in C#.
  • A class can implement any number of interfaces but a subclass can at most use only one abstract class.
  • An abstract class can have non-abstract methods (concrete methods) while in case of interface all the methods has to be abstract.
  • An abstract class can declare or use any variables while an interface is not allowed to do so.
  • In an abstract class all data member or functions are private by default while in interface all are public, we can’t change them manually.
  • In an abstract class we need to use abstract keyword to declare abstract methods while in an interface we don’t need to use that.
  • An abstract class can’t be used for multiple inheritance while interface can be used as multiple inheritance.
  • An abstract class use constructor while in an interface we don’t have any type of constructor.
To learn more about the difference between an abstract class and an interface, visit the following articles.

7. What is enum in C#?

 
Answer
An enum is a value type with a set of related named constants often referred to as an enumerator list. The enum keyword is used to declare an enumeration. It is a primitive data type, which is user defined.

An enum type can be an integer (float, int, byte, double etc.). But if you use it beside int it has to be cast.

An enum is used to create numeric constants in .NET framework. All the members of enum are of enum type. Their must be a numeric value for each enum type.

The default underlying type of the enumeration element is int. By default, the first enumerator has the value 0, and the value of each successive enumerator is increased by 1. 
  1. enum Dow {Sat, Sun, Mon, Tue, Wed, Thu, Fri};    
Some points about enum
  • Enums are enumerated data type in c#.
  • Enums are not for the end-user, they are meant for developers.
  • Enums are strongly typed constant. They are strongly typed, i.e. an enum of one type may not be implicitly assigned to an enum of another type even though the underlying value of their members are the same.
  • Enumerations (enums) make your code much more readable and understandable.
  • Enum values are fixed. Enum can be displayed as a string and processed as an integer.
  • The default type is int, and the approved types are byte, sbyte, short, ushort, uint, long, and ulong.
  • Every enum type automatically derives from System.Enum and thus we can use System.Enum methods on enums.
  • Enums are value types and are created on the stack and not on the heap.
For more details follow the link,

8. What is the difference between “continue” and “break” statements in C#?

 
Answer
Using break statement, you can 'jump out of a loop' whereas by using continue statement, you can 'jump over one iteration' and then resume your loop execution.

Eg. Break Statement  
  1. using System;  
  2. using System.Collections;  
  3. using System.Linq;  
  4. using System.Text;  
  5. namespace break_example {  
  6.     Class brk_stmt {  
  7.         public static void main(String[] args) {  
  8.             for (int i = 0; i <= 5; i++) {  
  9.                 if (i == 4) {  
  10.                     break;  
  11.                 }  
  12.                 Console.WriteLine("The number is " + i);  
  13.                 Console.ReadLine();  
  14.             }  
  15.         }  
  16.     }  
  17. }  
Output 

The number is 0; 
The number is 1; 
The number is 2; 
The number is 3;
Eg. Continue Statement
  1. using System;  
  2. using System.Collections;  
  3. using System.Linq;  
  4. using System.Text;  
  5. namespace continue_example {  
  6.     Class cntnu_stmt {  
  7.         public static void main(String[] {  
  8.                 for (int i = 0; i <= 5; i++) {  
  9.                     if (i == 4) {  
  10.                         continue;  
  11.                     }  
  12.                     Console.WriteLine(“The number is "+ i);   
  13.                         Console.ReadLine();  
  14.                     }  
  15.                 }  
  16.             }  
  17.         }  
Output
The number is 1;
The number is 2;
The number is 3;
The number is 5;


For more details follow link,

9. What is the difference between constant and readonly in C#?

 
Answer
Const is nothing but "constant", a variable of which the value is constant but at compile time. And it's mandatory to assign a value to it. By default, a const is static and we cannot change the value of a const variable throughout the entire program.
Readonly is the keyword whose value we can change during runtime or we can assign it at run time but only through the non-static constructor.
See the example

We have a Test Class in which we have two variables, one is readonly and other is a constant.
  1. class Test {    
  2.     readonly int read = 10;    
  3.     const int cons = 10;    
  4.     public Test() {    
  5.         read = 100;    
  6.         cons = 100;    
  7.     }    
  8.     public void Check() {    
  9.         Console.WriteLine("Read only : {0}", read);    
  10.         Console.WriteLine("const : {0}", cons);    
  11.     }    
  12. }    
Here I was trying to change the value of both the variables in constructor but when I am trying to change the constant it gives an error to change their value in that block which I have to call at run time.
ASP.NET

So finally remove that line of code from class and call this Check() function like the following code snippet,

  1. class Program {    
  2.     static void Main(string[] args) {    
  3.         Test obj = new Test();    
  4.         obj.Check();    
  5.         Console.ReadLine();    
  6.     }    
  7. }    
  8. class Test {    
  9.     readonly int read = 10;    
  10.     const int cons = 10;    
  11.     public Test() {    
  12.         read = 100;    
  13.     }    
  14.     public void Check() {    
  15.         Console.WriteLine("Read only : {0}", read);    
  16.         Console.WriteLine("const : {0}", cons);    
  17.     }    
  18. }    
Output
ASP.NET 
Learn more about const and readonly here:

10. What is the difference between ref and out keywords?

 
Answer
The ref keyword passes arguments by reference. It means any changes made to this argument in the method will be reflected in that variable when control returns to the calling method.
The out keyword passes arguments by reference. This is very similar to the ref keyword.

ASP.NET

To learn more about ref and out keywords, read the following article:

11. Can “this” be used within a static method?

 
Answer
We can't use this in a static method because the keyword 'this' returns a reference to the current instance of the class containing it. Static methods (or any static member) do not belong to a particular instance. They exist without creating an instance of the class and are called with the name of a class not by instance, so we can’t use this keyword in the body of static Methods, but in the case of Extension Methods we can use it the functions parameters.
Let’s have a look at the “this” keyword.

The "this" keyword in C# is a special type of reference variable that is implicitly defined within each constructor and non-static method as a first parameter of the type class in which it is defined.
Learn more here on The this Keyword In C#.

12. What are Properties in C#?

 
Answer
C# properties are members of a C# class that provide a flexible mechanism to read, write or compute the values of private fields, in other words, by using properties, we can access private fields and set their values. Properties in C# are always public data members. C# properties use get and set methods, also known as accessors to access and assign values to private fields.

Now the question is what are accessors?

The get and set portions or blocks of a property are called accessors. These are useful to restrict the accessibility of a property, the set accessor specifies that we can assign a value to a private field in a property and without the set accessor property it is like a readonly field. By the get accessor we can access the value of the private field, in other words, it returns a single value. A Get accessor specifies that we can access the value of a field publically.

We have three types of properties: Read/Write, ReadOnly and WriteOnly. Let's see each one by one.
Learn more here: Property in C#

13. What are extension methods in C#?

 
Answer
 
What are extension methods?
Extension methods enable you to add methods to existing types without creating a new derived type, recompiling, or otherwise modifying the original type. 

An extension method is a special kind of static method, but they are called as if they were instance methods on the extended type.
How to use extension methods?
An extension method is a static method of a static class, where the "this" modifier is applied to the first parameter. The type of the first parameter will be the type that is extended.

Extension methods are only in scope when you explicitly import the namespace into your source code with a using directive.
For more details on extension methods, you can read these articles,

14. What is the difference between dispose and finalize methods in C#?

 
Answer
 
The finalize and dispose, both methods are used to free unmanaged resources. Here are the difference between the two.
Finalize
  • Finalize used to free unmanaged resources those are not in use like files, database connections in application domain and more, held by an object before that object is destroyed.
  • In the Internal process it is called by Garbage Collector and can’t called manual by user code or any service.
  • Finalize belongs to System.Object class.
  • Implement it when you have unmanaged resources in your code, and make sure that these resources are freed when the Garbage collection happens.
Dispose
  • Dispose is also used to free unmanaged resources those are not in use like files, database connections in Application domain at any time.
  • Dispose explicitly it is called by manual user code.
  • If we need to dispose method so must implement that class by IDisposable interface.
  • It belongs to IDisposable interface.
  • Implement this when you are writing a custom class that will be used by other users.
For more details follow this link,

15. What is the difference between string and StringBuilder in C#?

 
Answer
StringBuilder and string both use to string value but both have many differences on the bases of instance creation and also for performance:

String

String is an immutable object. Immutable like when we create string object in code so we cannot modify or change that object in any operations like insert new value, replace or append any value with existing value in string object, when we have to do some operations to change string simply it will dispose the old value of string object and it will create new instance in memory for hold the new value in string object like,
ASP.NET  

Note
  • It’s an immutable object that hold string value.
  • Performance wise string is slow because its’ create a new instance to override or change the previous value.
  • String belongs to System namespace.
StringBuilder
System.Text.Stringbuilder is mutable object which also hold the string value, mutable means once we create a System.Text.Stringbuilder object we can use this object for any operation like insert value in existing string with insert functions also replace or append without creating new instance of System.Text.Stringbuilder for every time so it’s use the previous object so it’s work fast as compare than System.String. Let’s have an example to understand System.Text.Stringbuilder like,
ASP.NET 
Note
  • StringBuilder is a mutable object.
  • Performance wise StringBuilder is very fast because it will use same instance of StringBuilder object to perform any operation like insert value in existing string.
  • StringBuilder belongs to System.Text.Stringbuilder namespace.
For More details read this article by following link:

16. What is delegates in C# and uses of delegates?

 
Answer
A Delegate is an abstraction of one or more function pointers (as existed in C++; the explanation about this is out of the scope of this article). The .NET has implemented the concept of function pointers in the form of delegates. With delegates, you can treat a function as data. Delegates allow functions to be passed as parameters, returned from a function as a value and stored in an array. Delegates have the following characteristics,
  • Delegates are derived from the System.MulticastDelegate class.
  • They have a signature and a return type. A function that is added to delegates must be compatible with this signature.
  • Delegates can point to either static or instance methods.
  • Once a delegate object has been created, it may dynamically invoke the methods it points to at runtime.
  • Delegates can call methods synchronously and asynchronously.
The delegate contains a couple of useful fields. The first one holds a reference to an object, and the second holds a method pointer. When you invoke the delegate, the instance method is called on the contained reference. However, if the object reference is null then the runtime understands this to mean that the method is a static method. Moreover, invoking a delegate syntactically is the exact same as calling a regular function. Therefore, delegates are perfect for implementing callbacks.

Why Do We Need Delegates
Historically, the Windows API made frequent use of C-style function pointers to create callback functions. Using a callback, programmers were able to configure one function to report back to another function in the application. So the objective of using a callback is to handle button-clicking, menu-selection, and mouse-moving activities. But the problem with this traditional approach is that the callback functions were not type-safe. In the .NET framework, callbacks are still possible using delegates with a more efficient approach. Delegates maintain three important pieces of information, as in the following,
  • The parameters of the method.
  • The address of the method it calls.
  • The return type of the method.
A delegate is a solution for situations in which you want to pass methods around to other methods. You are so accustomed to passing data to methods as parameters that the idea of passing methods as an argument instead of data might sound a little strange. However, there are cases in which you have a method that does something, for instance, invoking some other method. You do not know at compile time what this second methods is. That information is available only at runtime hence Delegates are the device to overcome such complications.

17. What are sealed classes in C#?

 
Answer
Sealed classes are used to restrict the inheritance feature of object oriented programming. Once a class is defined as a sealed class, the class cannot be inherited. 

In C#, the sealed modifier is used to define a class as sealed. In Visual Basic .NET the Not Inheritable keyword serves the purpose of sealed. If a class is derived from a sealed class then the compiler throws an error. 

If you have ever noticed, structs are sealed. You cannot derive a class from a struct. 

The following class definition defines a sealed class in C#,
  1. // Sealed class    
  2. sealed class SealedClass    
  3. {       
  4. }    
Learn more about sealed classes here: Sealed Class in C#

18. What are partial classes?

 
Answer
A partial class is only use to splits the definition of a class in two or more classes in a same source code file or more than one source files. You can create a class definition in multiple files but it will be compiled as one class at run time and also when you’ll create an instance of this class so you can access all the methods from all source file with a same object.

Partial Classes can be create in the same namespace it’s doesn’t allowed to create a partial class in different namespace. So use “partial” keyword with all the class name which you want to bind together with the same name of class in same namespace, let’s have an example,
ASP.NET  

To learn about partial classes, visit Partial Classes in C# With Real Example.
 

19. What is boxing and unboxing in C#?

 
Answer
Boxing and Unboxing both using for type converting but have some difference:

Boxing


Boxing is the process of converting a value type data type to the object or to any interface data type which is implemented by this value type. When the CLR boxes a value means when CLR converting a value type to Object Type, it wraps the value inside a System.Object and stores it on the heap area in application domain. 

Example
ASP.NET

Unboxing

Unboxing is also a process which is use to extracts the value type from the object or any implemented interface type. Boxing may be done implicit but unboxing have to be explicit by code. 

Example
 
ASP.NET

The concept of boxing and unboxing underlies the C# unified view of the type system in which a value of any type can be treated as an object.
To learn more about boxing and unboding, visit Boxing and Unboxing in C#.

20. What is IEnumerable<> in C#?

 
Answer
IEnumerable is the parent interface for all non-generic collections in System.Collections namespace like ArrayList, HastTable etc. that can be enumerated. For the generic version of this interface as IEnumerable which a parent interface of all generic collections class in System.Collections.Generic namespace like List<> and more. 

In System.Collections.Generic.IEnumerable have only a single method which is GetEnumerator() that returns an IEnumerator. IEnumerator provides the power to iterate through the collection by exposing a Current property and Move Next and Reset methods, if we doesn’t have this interface as a parent so we can’t use iteration by foreach loop or can’t use that class object in our LINQ query.
ASP.NET  

For more details, visit Implement IEnumerable Interface in C#.
 

21. What is difference between late binding and early binding in C#?

 
Answer
Early Binding and late Binding concepts belong to polymorphism in C#. Polymorphism is the feature of object oriented programming that allows a language to use same name in different forms. For example, a method name Add that can add integers, doubles, and decimals.
Polymorphism we have 2 different types to achieve that: 
  • Compile Time also known as Early Binding or Overloading.
  • Run Time also known as Late Binding or Overriding.
Compile Time Polymorphism or Early Binding
In Compile time polymorphism or Early Binding we will use multiple methods with same name but different type of parameter or may be the number or parameter because of this we can perform different-different tasks with same method name in the same class which is also known as Method overloading.

See how we can do that by the following example,
ASP.NET 
Run Time Polymorphism or Late Binding
Run time polymorphism also known as late binding, in Run Time polymorphism or Late Binding we can do use same method names with same signatures means same type or same number of parameters but not in same class because compiler doesn’t allowed that at compile time so we can use in derived class that bind at run time when a child class or derived class object will instantiated that’s way we says that Late Binding. For that we have to create my parent class functions as partial and in driver or child class as override functions with override keyword. 

Like as following example,
ASP.NET 

22. What are the differences between IEnumerable and IQueryable?

 
Answer
Before we go into the differences, lets learn what the IEnumerable and IQueryable are.

IEnumerable

Is the parent interface for all non-generic collections in System.Collections namespace like ArrayList, HastTable etc. that can be enumerated. For the generic version of this interface as IEnumerable which a parent interface of all generic collections class in System.Collections.Generic namespace like List<> and more. 

IQueryable

As per MSDN IQueryable interface is intended for implementation by query providers. It is only supposed to be implemented by providers that also implement IQueryable. If the provider does not also implement IQueryable, the standard query operators cannot be used on the provider's data source.

The IQueryable interface inherits the IEnumerable interface so that if it represents a query, the results of that query can be enumerated. Enumeration causes the expression tree associated with an IQueryable object to be executed. The definition of "executing an expression tree" is specific to a query provider. For example, it may involve translating the expression tree to an appropriate query language for the underlying data source. Queries that do not return enumerable results are executed when the Execute method is called.
ASP.NET  

23. What happens if the inherited interfaces have conflicting method names?

 
Answer
If we implement multiple interfaces in the same class with conflict method names so we don’t need to define all or in other words we can say if we have conflict methods in same class so we can’t implement their body independently in the same class coz of same name and same signature so we have to use interface name before method name to remove this method confiscation let’s see an example,
  1. interface testInterface1 {  
  2.     void Show();  
  3. }  
  4. interface testInterface2 {  
  5.     void Show();  
  6. }  
  7. class Abc: testInterface1,  
  8.     testInterface2 {  
  9.         void testInterface1.Show() {  
  10.             Console.WriteLine("For testInterface1 !!");  
  11.         }  
  12.         void testInterface2.Show() {  
  13.             Console.WriteLine("For testInterface2 !!");  
  14.         }  
  15.     }  
Now see how to use those in a class,
  1. class Program {  
  2.     static void Main(string[] args) {  
  3.         testInterface1 obj1 = new Abc();  
  4.         testInterface1 obj2 = new Abc();  
  5.         obj1.Show();  
  6.         obj2.Show();  
  7.         Console.ReadLine();  
  8.     }  
  9. }  
Output
ASP.NET 

For one more example follow the link:

24. What are the Arrays in C#?

 
Answer
 
In C#, an array index starts at zero. That means the first item of an array starts at the 0thposition. The position of the last item on an array will total number of items - 1. So if an array has 10 items, the last 10th item is at 9th position. 

In C#, arrays can be declared as fixed length or dynamic.
fixed length array can store a predefined number of items.
dynamic array does not have a predefined size. The size of a dynamic array increases as you add new items to the array. You can declare an array of fixed length or dynamic. You can even change a dynamic array to static after it is defined.
Let's take a look at simple declarations of arrays in C#. The following code snippet defines the simplest dynamic array of integer types that do not have a fixed size.
int[] intArray;
As you can see from the above code snippet, the declaration of an array starts with a type of array followed by a square bracket ([]) and name of the array.
The following code snippet declares an array that can store 5 items only starting from index 0 to 4. 
  1. int[] intArray;    
  2. intArray = new int[5];    
The following code snippet declares an array that can store 100 items starting from index 0 to 99. 
  1. int[] intArray;    
  2. intArray = new int[100];    
Learn more about Arrays in C#: Working with Arrays In C#

25. What is the Constructor Chaining in C#?

 
Answer
 
Constructor chaining is a way to connect two or more classes in a relationship as Inheritance, in Constructor Chaining every child class constructor is mapped to parent class Constructor implicitly by base keyword so when you create an instance of child class to it’ll call parent’s class Constructor without it inheritance is not possible.

For more example follow the link:

26. What’s the difference between the Array.CopyTo() and Array.Clone()?

 
Answer
The Array.Clone() method creates a shallow copy of an array. A shallow copy of an Array copies only the elements of the Array, whether they are reference types or value types, but it does not copy the objects that the references refer to. The references in the new Array point to the same objects that the references in the original Array point to.

The CopyTo() static method of the Array class copies a section of an array to another array. The CopyTo method copies all the elements of an array to another one-dimension array. The code listed in Listing 9 copies contents of an integer array to an array of object types. 

Learn more about arrays here,

27. Can Multiple Catch Blocks executed in c#?

 
Answer
We can use multiple catch blocks with a try statement. Each catch block can catch a different exception. The following code example shows how to implement multiple catch statements with a single try statement.
  1. using System;    
  2. class MyClient {    
  3.     public static void Main() {    
  4.         int x = 0;    
  5.         int div = 0;    
  6.         try {    
  7.             div = 100 / x;    
  8.             Console.WriteLine("Not executed line");    
  9.         } catch (DivideByZeroException de) {    
  10.             Console.WriteLine("DivideByZeroException");    
  11.         } catch (Exception ee) {    
  12.             Console.WriteLine("Exception");    
  13.         } finally {    
  14.             Console.WriteLine("Finally Block");    
  15.         }    
  16.         Console.WriteLine("Result is {0}", div);    
  17.     }    
  18. }    
To learn more about Exception Handling in C#, please visit:

28. What is Singleton Design Patterns and How to implement in C#?

 
Answer
What isSingleton Design Pattern? 
  1. Ensures a class has only one instance and provides a global point of access to it.
  2. A singleton is a class that only allows a single instance of itself to be created, and usually gives simple access to that instance.
  3. Most commonly, singletons don't allow any parameters to be specified when creating the instance, since a second request of an instance with a different parameter could be problematic! (If the same instance should be accessed for all requests with the same parameter then the factory pattern is more appropriate.)
  4. There are various ways to implement the Singleton Pattern in C#. The following are the common characteristics of a Singleton Pattern.
    • A single constructor, that is private and parameterless.
    • The class is sealed.
    • A static variable that holds a reference to the single created instance, if any.
    • A public static means of getting the reference to the single created instance, creating one if necessary.
    This is the example how to write the code with Singleton,
    1. namespace Singleton {  
    2.     class Program {  
    3.         static void Main(string[] args) {  
    4.             Calculate.Instance.ValueOne = 10.5;  
    5.             Calculate.Instance.ValueTwo = 5.5;  
    6.             Console.WriteLine("Addition : " + Calculate.Instance.Addition());  
    7.             Console.WriteLine("Subtraction : " + Calculate.Instance.Subtraction());  
    8.             Console.WriteLine("Multiplication : " + Calculate.Instance.Multiplication());  
    9.             Console.WriteLine("Division : " + Calculate.Instance.Division());  
    10.             Console.WriteLine("\n----------------------\n");  
    11.             Calculate.Instance.ValueTwo = 10.5;  
    12.             Console.WriteLine("Addition : " + Calculate.Instance.Addition());  
    13.             Console.WriteLine("Subtraction : " + Calculate.Instance.Subtraction());  
    14.             Console.WriteLine("Multiplication : " + Calculate.Instance.Multiplication());  
    15.             Console.WriteLine("Division : " + Calculate.Instance.Division());  
    16.             Console.ReadLine();  
    17.         }  
    18.     }  
    19.     public sealed class Calculate {  
    20.         private Calculate() {}  
    21.         private static Calculate instance = null;  
    22.         public static Calculate Instance {  
    23.             get {  
    24.                 if (instance == null) {  
    25.                     instance = new Calculate();  
    26.                 }  
    27.                 return instance;  
    28.             }  
    29.         }  
    30.         public double ValueOne {  
    31.             get;  
    32.             set;  
    33.         }  
    34.         public double ValueTwo {  
    35.             get;  
    36.             set;  
    37.         }  
    38.         public double Addition() {  
    39.             return ValueOne + ValueTwo;  
    40.         }  
    41.         public double Subtraction() {  
    42.             return ValueOne - ValueTwo;  
    43.         }  
    44.         public double Multiplication() {  
    45.             return ValueOne * ValueTwo;  
    46.         }  
    47.         public double Division() {  
    48.             return ValueOne / ValueTwo;  
    49.         }  
    50.     }  
    51. }  
    To read more about Singleton in depth so follow the link:

    29. Difference between Throw Exception and Throw Clause

     
    Answer
    The basic difference is that the Throw exception overwrites the stack trace and this makes it hard to find the original code line number that has thrown the exception.

    Throw basically retains the stack information and adds to the stack information in the exception that it is thrown.

    Let us see what it means rather speaking so many words to better understand the differences. I am using a console application to easily test and see how the usage of the two differ in their functionality.
    1. using System;  
    2. using System.Collections.Generic;  
    3. using System.Linq;  
    4. using System.Text;  
    5. namespace TestingThrowExceptions {  
    6.     class Program {  
    7.         public void ExceptionMethod() {  
    8.             throw new Exception("Original Exception occurred in ExceptionMethod");  
    9.         }  
    10.         static void Main(string[] args) {  
    11.             Program p = new Program();  
    12.             try {  
    13.                 p.ExceptionMethod();  
    14.             } catch (Exception ex) {  
    15.                 throw ex;  
    16.             }  
    17.         }  
    18.     }  
    19. }  
    Now run the code by pressing the F5 key of the keyboard and see what happens. It returns an exception and look at the stack trace:

    To learn more about throw exceptions, please visit:

    30. What are Indexer in C#?

     
    Answer
    C# introduces a new concept known as Indexers which are used for treating an object as an array. The indexers are usually known as smart arrays in C#. They are not essential part of object-oriented programming.

    Defining an indexer allows you to create classes that act like virtual arrays. Instances of that class can be accessed using the [] array access operator.

    Creating an Indexer 
    1. < modifier > <    
    2. return type > this[argument list] {    
    3.     get {    
    4.         // your get block code    
    5.     }    
    6.     set {    
    7.         // your set block code    
    8.     }    
    9. }    
    In the above code,



    can be private, public, protected or internal.



    can be any valid C# types.

    To learn more about indexers in C#, visit Indexers in C#.

    31. What is multicast delegate in c#?


    Answer

    Delegate is one of the base types in .NET. Delegate is a class, which is used to create and invoke delegates at runtime.
    A delegate in C# allows developers to treat methods as objects and invoke them from their code.
    Implement Multicast Delegates Example,
    1. using System;    
    2. using System.Collections.Generic;    
    3. using System.Linq;    
    4. using System.Text;    
    5. delegate void MDelegate();    
    6. class DM {    
    7.     static public void Display() {    
    8.         Console.WriteLine("Meerut");    
    9.     }    
    10.     static public void print() {    
    11.         Console.WriteLine("Roorkee");    
    12.     }    
    13. }    
    14. class MTest {    
    15.     public static void Main() {    
    16.         MDelegate m1 = new MDelegate(DM.Display);    
    17.         MDelegate m2 = new MDelegate(DM.print);    
    18.         MDelegate m3 = m1 + m2;    
    19.         MDelegate m4 = m2 + m1;    
    20.         MDelegate m5 = m3 - m2;    
    21.         m3();    
    22.         m4();    
    23.         m5();    
    24.     }    
    25. }    
    Learn more about delegates in C# here,

    32. Difference between Equality Operator (==) and Equals() Method in C#

    Answer

    Both the == Operator and the Equals() method are used to compare two value type data items or reference type data items. The Equality Operator (==) is the comparison operator and the Equals() method compares the contents of a string. The == Operator compares the reference identity while the Equals() method compares only contents. Let’s see with some examples.

    In this example we assigned a string variable to another variable. A string is a reference type and in the following example, a string variable is assigned to another string variable so they are referring to the same identity in the heap and both have the same content so you get True output for both the == Operator and the Equals() method.
    1. using System;    
    2. namespace ComparisionExample {    
    3.     class Program {    
    4.         static void Main(string[] args) {    
    5.             string name = "sandeep";    
    6.             string myName = name;    
    7.             Console.WriteLine("== operator result is {0}", name == myName);    
    8.             Console.WriteLine("Equals method result is {0}", name.Equals(myName));    
    9.             Console.ReadKey();    
    10.         }    
    11.     }    
    12. }    
    For more details go with this following Links,

    33. Difference between is and as operator in C#

    Answer

    "is" operator

    In C# language, we use the "is" operator to check the object type. If two objects are of the same type, it returns true, else it returns false.
    Let's understand this in our C# code. We declare two classes, Speaker and Author.
    1. class Speaker {    
    2.     public string Name {    
    3.         get;    
    4.         set;    
    5.     }    
    6. }    
    7. class Author {    
    8.     public string Name {    
    9.         get;    
    10.         set;    
    11.     }    
    12. }    
    Now, let's create an object of type Speaker,
    1. var speaker = new Speaker { Name="Gaurav Kumar Arora"};    
    Now, let’s check if the object is Speaker type,
    1. var isTrue = speaker is Speaker;     
    In the preceding, we are checking the matching type. Yes, our speaker is an object of Speaker type.
    1. Console.WriteLine("speaker is of Speaker type:{0}", isTrue);   
    So, the results as true.

    But, here we get false,
    1. var author = new Author { Name = "Gaurav Kumar Arora" };     
    2. var isTrue = speaker is Author;     
    3. Console.WriteLine("speaker is of Author type:{0}", isTrue);    
    Because our speaker is not an object of Author type.

    "as" operator
    The "as" operator behaves in similar way as the "is" operator. The only difference is it returns the object if both are compatible to that type. Else it returns a null. 
    Let's understand this in our C# code.
    1. public static string GetAuthorName(dynamic obj)     
    2.   {     
    3.      Author authorObj = obj as Author;     
    4.      return (authorObj != null) ? authorObj.Name : string.Empty;     
    5.   }     
    We have a method that accepts a dynamic object and returns the object name property if the object is of the Author type. 

    Here, we’ve declared two objects,
    1. var speaker = new Speaker { Name="Gaurav Kumar Arora"};   
    2. var author = new Author { Name = "Gaurav Kumar Arora" };     
    The following returns the "Name" property,
    1. var authorName = GetAuthorName(author);     
    2. Console.WriteLine("Author name is:{0}", authorName);    
    It returns an empty string,
    1. authorName = GetAuthorName(speaker);     
    2. Console.WriteLine("Author name is:{0}", authorName);     
    Learn more about is vs as operators here,

    34. How to use Nullable<> Types in C#?

    Answer

    A nullable type is a data type is that contains the defined data type or the null value.

    This nullable type concept is not compatible with "var".

    Any data type can be declared nullable type with the help of operator "?". 
    For example, the following code declares int i as a null.
    1. int? i = null;  
    As discussed in previous section "var" is not compatible with nullable types. 

    So, if you declare the following, you will get an error.
    1. var? i = null;  
    To learn more about nullable types in C#, read the following:

    35. Different Ways of Method can be overloaded

    Answer

    Method overloading is a way to achieve compile time polymorphism where we can use a method with the same name but different signatures. For example, the following code example has a method volume with three different signatures base don the number and type of parameters and return values.
    Example
    1. using System;    
    2. using System.Collections.Generic;    
    3. using System.Linq;    
    4. using System.Text;    
    5.     
    6. namespace Hello_Word {    
    7.     class overloding {    
    8.         public static void Main() {    
    9.             Console.WriteLine(volume(10));    
    10.             Console.WriteLine(volume(2.5F, 8));    
    11.             Console.WriteLine(volume(100L, 75, 15));    
    12.             Console.ReadLine();    
    13.         }    
    14.     
    15.         static int volume(int x) {    
    16.             return (x * x * x);    
    17.         }    
    18.     
    19.         static double volume(float r, int h) {    
    20.             return (3.14 * r * r * h);    
    21.         }    
    22.     
    23.         static long volume(long l, int b, int h) {    
    24.             return (l * b * h);    
    25.         }    
    26.     }    
    27. }    
    Note
    If we have a method that have two parameter object type and have a same name method with two integer parameter so when we call that method with int value so it’ll call that method have integer parameter instead of object type parameters method.

    Read the following article to learn more about method overloading in C#.

    36. What is an Object Pool in .Net?

    Answer

    Object Pooling in .NET allows objects to keep in the memory pool so the objects can be reused without recreating them. This article explains what object pooling is in .NET and how to implement object pooling in C#.
    What does it mean?

    Object Pool is a container of objects that are ready for use. Whenever there is a request for a new object, the pool manager will take the request and it will be served by allocating an object from the pool.

    How it works?

    We are going to use the Factory pattern for this purpose. We will have a factory method, which will take care about the creation of objects. Whenever there is a request for a new object, the factory method will look into the object pool (we use Queue object). If there is any object available within the allowed limit, it will return the object (value object), otherwise a new object will be created and give you back.
    To learn more about object pooling in C# and .NET, read the following,

    37. What are Generics in C#?

    Answer

    Generics allow you to delay the specification of the data type of programming elements in a class or a method, until it is actually used in the program. In other words, generics allow you to write a class or method that can work with any data type.

    You write the specifications for the class or the method, with substitute parameters for data types. When the compiler encounters a constructor for the class or a function call for the method, it generates code to handle the specific data type.
    ASP.NET

    Generic classes and methods combine reusability, type safety and efficiency in a way that their non-generic counterparts cannot. Generics are most frequently used with collections and the methods that operate on them. Version 2.0 of the .NET Framework class library provides a new namespace, System.Collections.Generic, that contains several new generic-based collection classes. It is recommended that all applications that target the .NET Framework 2.0 and later use the new generic collection classes instead of the older non-generic counterparts such as ArrayList.

    Features of Generics

    Generics is a technique that enriches your programs in the following ways,
    • It helps you to maximize code reuse, type safety and performance.
    • You can create generic collection classes. The .NET Framework class library contains several new generic collection classes in the System.Collections.Generic namespace. You may use these generic collection classes instead of the collection classes in the System.Collections namespace.
    • You can create your own generic interfaces, classes, methods, events and delegates.
    • You may create generic classes constrained to enable access to methods on specific data types.
    • You may get information on the types used in a generic data type at run-time using reflection.
    Learn more here about generic classes in C# here,

    38. Describe Accessibility Modifiers in C#

    Answer 

    Access modifiers are keywords used to specify the declared accessibility of a member or a type.

    Access modifiers are keywords used to specify the scope of accessibility of a member of a type or the type itself. For example, a public class is accessible to the entiere world, while an internal class may be accessible to the assembly only. 
    Why to use access modifiers?
    Access modifiers are an integral part of object-oriented programming. Access modifiers are used to implement encapsulation of OOP. Access modifiers allow you to define who does or who doesn't have access to certain features.
    In C# there are 6 different types of Access Modifiers.
    ModifierDescription
    publicThere are no restrictions on accessing public members.
    privateAccess is limited to within the class definition. This is the default access modifier type if none is formally specified
    protectedAccess is limited to within the class definition and any class that inherits from the class
    internalAccess is limited exclusively to classes defined within the current project assembly
    protected internalAccess is limited to the current assembly and types derived from the containing class. All members in current project and all members in derived class can access the variables.
    private protectedAccess is limited to the containing class or types derived from the containing class within the current assembly.
    To learn more about access modifiers in C#, learn here,

    39. What is a Virtual Method in C#?

    Answer

    A virtual method is a method that can be redefined in derived classes. A virtual method has an implementation in a base class as well as derived the class. It is used when a method's basic functionality is the same but sometimes more functionality is needed in the derived class. A virtual method is created in the base class that can be overridden in the derived class. We create a virtual method in the base class using the virtual keyword and that method is overridden in the derived class using the override keyword.

    When a method is declared as a virtual method in a base class then that method can be defined in a base class and it is optional for the derived class to override that method. The overriding method also provides more than one form for a method. Hence it is also an example for polymorphism.

    When a method is declared as a virtual method in a base class and that method has the same definition in a derived class then there is no need to override it in the derived class. But when a virtual method has a different definition in the base class and the derived class then there is a need to override it in the derived class.

    When a virtual method is invoked, the run-time type of the object is checked for an overriding member. The overriding member in the most derived class is called, which might be the original member, if no derived class has overridden the member.

    Virtual Method
    1. By default, methods are non-virtual. We can't override a non-virtual method.
    2. We can't use the virtual modifier with the static, abstract, private or override modifiers.
    Learn more about virtual methods in C#,

    40. What are the Difference between Array and ArrayList in C#?

    Answer

    Here is a list of difference between the two.

    To learn more about arrays, collections, and ArrayList here,

    41. What do you understand by Value types and Reference types in C#?

    Answer

    In C#, data types can be of two types, value types and reference types. Value type variables contain their object (or data) directly. If we copy one value type variable to another then we are actually making a copy of the object for the second variable. Both of them will independently operate on their values, Value type data types are stored on a stack and reference data types are stored on a heap.
    In C#, basic data types such as int, char, bool, and long are value types. Classes and collections are reference types.
    For more details follow this link,

    42. What is Serialization in C#?

    Answer

    Serialization in C# is the process of converting an object into a stream of bytes to store the object to memory, a database, or a file. Its main purpose is to save the state of an object in order to be able to recreate it when needed. The reverse process is called deserialization.
    There are three types of serialization,
    1. Binary serialization (Save your object data into binary format).
    2. Soap Serialization (Save your object data into binary format; mainly used in network related communication).
    3. XmlSerialization (Save your object data into an XML file).
    Learn more about serialization in C# here,

    43. What is the use of the “using” statement in C#?

    Answer

    There are two ways to use the using keyword in C#. One is as a directive and the other is as a statement. Let's explain!
    1. using Directive
      Generally we use the using keyword to add namespaces in code-behind and class files. Then it makes available all the classes, interfaces and abstract classes and their methods and properties in the current page. Adding a namespace can be done in the following two ways:
    1. Using Statement
      This is another way to use the using keyword in C#. It plays a vital role in improving performance in Garbage Collection.
    Learn more here,

    44. What is a Jagged Array in C#?

    Answer

    A jagged array is an array whose elements are arrays. The elements of a jagged array can be of different dimensions and sizes. A jagged array is sometimes called an "array of arrays."

    A special type of array is introduced in C#. A Jagged Array is an array of an array in which the length of each array index can differ.

    Example
    1. int[][] jagArray = new int[5][];    
    In the above declaration the rows are fixed in size. But columns are not specified as they can vary.

    Declaring and initializing jagged array.
    1. int[][] jaggedArray = new int[5][];         
    2. jaggedArray[0] = new int[3];    
    3. jaggedArray[1] = new int[5];    
    4. jaggedArray[2] = new int[2];    
    5. jaggedArray[3] = new int[8];    
    6. jaggedArray[4] = new int[10];    
    7. jaggedArray[0] = new int[] { 3, 5, 7, };    
    8. jaggedArray[1] = new int[] { 1, 0, 2, 4, 6 };    
    9. jaggedArray[2] = new int[] { 1, 6 };    
    10. jaggedArray[3] = new int[] { 1, 0, 2, 4, 6, 45, 67, 78 };    
    11. jaggedArray[4] = new int[] { 1, 0, 2, 4, 6, 34, 54, 67, 87, 78 };     
    Learn more here,

    45. What is Multithreading with .NET?

    Answer

    Multithreading allows a program to run multiple threads concurrently. This article explains how multithreading works in .NET. This article covers the entire range of threading areas from thread creation, race conditions, deadlocks, monitors, mutexes, synchronization and semaphores and so on.
    The real usage of a thread is not about a single sequential thread, but rather using multiple threads in a single program. Multiple threads running at the same time and performing various tasks is referred as Multithreading. A thread is considered to be a lightweight process because it runs within the context of a program and takes advantage of resources allocated for that program.
    A single-threaded process contains only one thread while a multithreaded process contains more than one thread for execution.

    To learn more about threading in .NET, visit,

      46. Explain Anonymous Types in C#?

      Answer

      Anonymous types allow us to create new type without defining them. This is way to defining read only properties into a single object without having to define type explicitly. Here Type is generating by the compiler and it is accessible only for the current block of code. The type of properties is also inferred by the compiler.

      We can create anonymous types by using “new” keyword together with the object initializer. 

      Example 
      1. var anonymousData = new     
      2. {    
      3.     ForeName = "Jignesh",    
      4.     SurName = "Trivedi"    
      5. };    
      6. Console.WriteLine("First Name : " + anonymousData.ForeName);    
      Anonymous Types with LINQ Example

      Anonymous types are also used with the "Select" clause of LINQ query expression to return subset of properties.

      Example

      If Any object collection having properties called FirstName , LastName, DOB etc. and you want only FirstName and LastName after the Querying the data then.
      1.     class MyData {    
      2.         public string FirstName {    
      3.             get;    
      4.             set;    
      5.         }    
      6.         public string LastName {    
      7.             get;    
      8.             set;    
      9.         }    
      10.         public DateTime DOB {    
      11.             get;    
      12.             set;    
      13.         }    
      14.         public string MiddleName {    
      15.             get;    
      16.             set;    
      17.         }    
      18.     }    
      19.     static void Main(string[] args) {    
      20.         // Create Dummy Data to fill Collection.    
      21.         List < MyData > data = new List < MyData > ();    
      22.         data.Add(new MyData {    
      23.             FirstName = "Jignesh", LastName = "Trivedi", MiddleName = "G", DOB = new DateTime(1990, 12, 30)    
      24.         });    
      25.         data.Add(new MyData {    
      26.             FirstName = "Tejas", LastName = "Trivedi", MiddleName = "G", DOB = new DateTime(1995, 11, 6)    
      27.         });    
      28.         data.Add(new MyData {    
      29.             FirstName = "Rakesh", LastName = "Trivedi", MiddleName = "G", DOB = new DateTime(1993, 10, 8)    
      30.         });    
      31.         data.Add(new MyData {    
      32.             FirstName = "Amit", LastName = "Vyas", MiddleName = "P", DOB = newDateTime(1983, 6, 15)    
      33.         });    
      34.         data.Add(new MyData {    
      35.             FirstName = "Yash", LastName = "Pandiya", MiddleName = "K", DOB = newDateTime(1988, 7, 20)    
      36.         });    
      37.     }    
      38.     var anonymousData = from pl in data    
      39.     select new {    
      40.         pl.FirstName, pl.LastName    
      41.     };    
      42.     foreach(var m in anonymousData) {    
      43.         Console.WriteLine("Name : " + m.FirstName + " " + m.LastName);    
      44.     }    
      45. }     
      Learn more about anonymous types here,

      47. Explain Hashtable in C#?

      Answer

      A Hashtable is a collection that stores (Keys, Values) pairs. Here, the Keys are used to find the storage location and is immutable and cannot have duplicate entries in a Hashtable. The .Net Framework has provided a Hash Table class that contains all the functionality required to implement a hash table without any additional development. The hash table is a general-purpose dictionary collection. Each item within the collection is a DictionaryEntry object with two properties: a key object and a value object. These are known as Key/Value. When items are added to a hash table, a hash code is generated automatically. This code is hidden from the developer. All access to the table's values is achieved using the key object for identification. As the items in the collection are sorted according to the hidden hash code, the items should be considered to be randomly ordered.

      The Hashtable Collection

      The Base Class libraries offers a Hashtable Class that is defined in the System.Collections namespace, so you don't have to code your own hash tables. It processes each key of the hash that you add every time and then uses the hash code to look up the element very quickly. The capacity of a hash table is the number of elements the hash table can hold. As elements are added to a hash table, the capacity is automatically increased as required through reallocation. It is an older .Net Framework type.

      Declaring a Hashtable

      The Hashtable class is generally found in the namespace called System.Collections. So to execute any of the examples, we have to add using System.Collections; to the source code. The declaration for the Hashtable is,
      1. Hashtable HT = new Hashtable ();  
      Learn more about HashTable, visit the following,

      48. What is LINQ in C#?

      Answer

      LINQ stands for Language Integrated Query. LINQ is a data querying methodology which provides querying capabilities to .NET languages with a syntax similar to a SQL query

      LINQ has a great power of querying on any source of data. The data source could be collections of objects, database or XML files. We can easily retrieve data from any object that implements the IEnumerable interface.

      Advantages of LINQ 
      1. LINQ offers an object-based, language-integrated way to query over data no matter where that data came from. So through LINQ we can query database, XML as well as collections. 
      2. Compile time syntax checking.
      3. It allows you to query collections like arrays, enumerable classes etc in the native language of your application, like VB or C# in much the same way as you would query a database using SQL.

        ASP.NET
      For more details follow the link,

      49. What is File Handling in C#.Net?

      Answer

      The System.IO namespace provides four classes that allow you to manipulate individual files, as well as interact with a machine directory structure. The Directory and File directly extends System.Object and supports the creation, copying, moving and deletion of files using various static methods. They only contain static methods and are never instantiated. The FileInfo and DirecotryInfo types are derived from the abstract class FileSystemInfo type and they are typically, employed for obtaining the full details of a file or directory because their members tend to return strongly typed objects. They implement roughly the same public methods as a Directory and a File but they are stateful and the members of these classes are not static.
      ASP.NET

      For more details follow the link,

      50. What is Reflection in C#?

      Answer

      Reflection is the process of runtime type discovery to inspect metadata, CIL code, late binding and self-generating code. At run time by using reflection, we can access the same "type" information as displayed by the ildasm utility at design time. The reflection is analogous to reverse engineering in which we can break an existing *.exe or *.dll assembly to explore defined significant contents information, including methods, fields, events and properties.

      You can dynamically discover the set of interfaces supported by a given type using the System.Reflection namespace.
      Reflection typically is used to dump out the loaded assemblies list, their reference to inspect methods, properties etcetera. Reflection is also used in the external disassembling tools such Reflector, Fxcop and NUnit because .NET tools don't need to parse the source code similar to C++. 

      Metadata Investigation 

      The following program depicts the process of reflection by creating a console based application. This program will display the details of the fields, methods, properties and interfaces for any type within the mscorlib.dll assembly. Before proceeeding, it is mandatory to import "System.Reflection".

      Here, we are defining a number of static methods in the program class to enumerate fields, methods and interfaces in the specified type. The static method takes a single "System.Type" parameter and returns void. 
      1. static void FieldInvestigation(Type t) {    
      2.     Console.WriteLine("*********Fields*********");    
      3.     FieldInfo[] fld = t.GetFields();    
      4.     foreach(FieldInfo f in fld) {    
      5.         Console.WriteLine("-->{0}", f.Name);    
      6.     }    
      7. }    
      8.     
      9. static void MethodInvestigation(Type t) {    
      10.     Console.WriteLine("*********Methods*********");    
      11.     MethodInfo[] mth = t.GetMethods();    
      12.     foreach(MethodInfo m in mth) {    
      13.         Console.WriteLine("-->{0}", m.Name);    
      14.     }    
      15. }    
      Read More »

      My Blog List

      • काश - काश मुझे भी पीने की आदत होती,मैं कब का मुर्दा हो गया होता। छुटकारा मिलता आज के आतंकवाद से, किसी संतान भूमि में सो गया होता। मेरा एतबार कौन करेगा, मैंने मुर...
        2 months ago
      • काश - काश मुझे भी पीने की आदत होती,मैं कब का मुर्दा हो गया होता। छुटकारा मिलता आज के आतंकवाद से, किसी शमशान भूमि में सो गया होता। मेरा एतबार कौन करेगा, मैंने मुर...
        2 months ago
      • Kumaon University Nainital B.Ed entrance exam test result 2012 - कुमाऊँ विश्वविधालय, नैनीताल (उत्तराखण्ड)
        10 years ago