Differance Between CLR, CTS, CLS

Differance Between CLR, CTS, CLS

What is a CLR? Full form of CLR is Common Language Runtime and it forms the heart of the .NET framework.All Languages have runtime and its the responsibility of the runtime to take care of the code execution of the program. Java has Java Virtual Machine, Similarly .NET has CLR.The responsibilities of CLR are Garbage Collection, Code Access Security, Code Verification, IL( Intermediate language ). 

What is a CTS?

 In order that two language communicate smoothly CLR has CTS (Common Type System). In order that two different languages can communicate Microsoft introduced Common Type System. So “Integer” datatype in VB6 and “int” datatype in C++ will convert it to System.int32 which is datatype of CTS. 

What is a CLS(Common Language Specification)?

This is a subset of the CTS which all .NET languages are expected to support.Microsoft has defined CLS which are nothing but guidelines that language to follow so that it can communicate with other .NET languages in a seamless manner.

Posted By : Pratik Pachani
Stay Connected 

 ExecuteReader, ExecuteNonQuery and ExecuteScalar

What is difference between ExecuteReader, ExecuteNonQuery and ExecuteScalar.

ExecuteReader : Use for accessing data. It provides a forward-only, read-only, connected recordset
ExecuteNonQuery : Use for data manipulation, such as Insert, Update, Delete.
ExecuteScalar : Use for retriving 1 row 1 col. value., i.e. Single value. eg: for retriving aggregate 
function. It is faster than other ways of retriving a single value from DB.


Posted By : Pratik Pachani
Stay Connected