What is Finalize and Dispose ?



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

Dispose: - Force the user to dispose objects.


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.


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.


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 .


Syntax:

Session[“username”] = “Venkat”;


How to write stored procedure – give syntax ?



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


To create a new Guid?



Guid getnewID = Guid.NewGuid();


Difference between timestamp and uniqueidentifier ?



TimeStamp:

Size – 8 bytes.
Note based on system date or time
To track the operation in tables on the database level.

Uniqueidentifier

16 – bytes.
Value is based on the computer MAC Addresss and system datetime.
It remains unique in any system in the world.