How many types of CommandType options are there in Command object of ADO.NET?

There are 3 types of CommandType in Command object of ADO.NET. They are :

1. CommandType.Text
2. CommandType.TableDirect
3. CommandType.StoredProcedure


1. CommandType.Text:
Should be used when you pass a TSQL statement(select,insert,update,etc).


2. CommandType.TableDirect
You will specify the name of the table from which you want the records.


3. CommandType.StoredProcedure
Is used when you pass the name of a stored procedure.

www.codecollege.NET

How many types of Execute methods are there in ADO.NET's Command Object?

There are 4 types of Execute Methods ADO.NET's Command Object. They are :

1. ExecuteNonQuery();
2. ExecuteReader();
3. ExecuteScalar();
4. ExecuteXmlReader();

www.codecollege.NET

Can you store multiple data types in a System.Array?

No.

www.codecollege.NET

Which .NET type maps to the C# keyword 'int' ?

System.Int32;

www.codecollege.NET

What are the different methods to deploy an Assembly?

MSI Installer, a CAB archive, XCOPY command.

www.codecollege.NET

What is the smallest unit of execution in .NET?

Assembly.

www.codecollege.NET

What is the name of technique used to convert a value-type to a reference-type ?

Boxing.

www.codecollege.NET