How to write stored procedure – give syntax ?

Create Procedue <procedureName>

(
Your parameter
)
As
Begin
< your Sql Statement>
End

What is Session ?

                        Session is used to store user details particularly userid and user information so once you set the information  in session you can get the data anywhere in the project .

Reflection ?

You can see the metadata information through reflection mechanism.

Ability to inspect and manipulate programs elements at runtime.

It’s the process of runtime type discovery.

Reflection Services:

Load an assembly at runtime.
Enumerate members of a type.
Instantiate a new object.
Execute the members of an object.
Find out the information about a type .
Find out the information about a assembly
Inspect custome attributes applied to a type.
Create and compile new assembly.

Boxing and Unboxing ?

Boxing:

Implicit conversion of any value type to the type object.
Value types are stored on stack.
Reference or object type are stored on heap.

Unboxing:

Explicit conversion from object type to value type.

What is Finalize and Dispose ?

Finalize:  - Automatically done by garbage collector  to clean the resource memory.

Dispose: - Force the user to dispose objects.

Difference b/w int.Parse and Convert.ToInt32()?

Int.Parse – It can’t handle NULL value.

Convert.ToInt32 – It handles null value and converts value to default value ‘0’.

Define Delegates ?

Delegate is  a class that can hold reference to a method or a function .

Delegate class has a signature and it only reference those method whose signature is compliant with the class.

Delegates are type safe , secure , object oriented.