Question { Minecode, 31930 }

which one is faster execute reader, scalar, execute non
query ?

Answer

Scalar will be faster that the execute reader and execute
non query. As scalar only fetch one column single row.
Whereas execute reader may return numbers of record and
though non-query will not return any records it will take
time to identify the data types to validate be4 inserting
the data

Question { Six Sigma, 29192 }

what are clr,cls,cts?what is .net framework?

Answer

What is the common language runtime (CLR)?

The common language runtime is the execution engine
for .NET Framework applications. It provides a number of
services, including the following:
i) Code management (loading and execution)
ii) Application memory isolation.
iii) Version control.
iv) Conversion of IL to native code.
v) Access to metadata (enhanced type information)
vi) Garbage collection
vii) Enforcement of code access security.
viii) Exception handling, including cross-language
exceptions
ix) Interoperation between managed code.
x) Support for developer services (profiling,
debugging, and so on)



Parts of CLR (Common Language Runtime):
1. Common Type system (CTS)
2. Common Language Specification (CLS)
Q: What is the common type system (CTS)?
.Net framework supports multiple languages, and different
language defines their primitives’ data types in different
formats. For examples:
C# defines and integer variable : int i;
Where as VB.Net defines an integer variable: Dim i as
integer
Microsoft tries to convert these data types into a generic
data types. So that different codes written in different
languages code are converted into language independent
code, due to this CTS is created.
CTS contain different data type’s specification to be used
in our code. For example: the primitives’ integer data type
is known as Int32, in CTS. All data types are derived from
object data types from which the value types and reference
types are defined.
Q: What is the Common Language Specification (CLS)?
i) CLS stands for Common Language Specification
ii) CLS is subset CTS
iii) CLS allows developers, vendors, software
manufactures an opportunity to work with in a common set of
specification for language, data types.
iv) CLS defines the standard that the object must
contain in order to communicate with each other, in
homogeneous environment.