Bala's Blog

Sample Questions Dotnet

1) What is .Net Platform?

Microsoft .NET is a software development platform based on virtual machine architecture. Dot Net Platform is:

à Language Independent – dot net application can be developed different languages (such as C#, VB, C++, etc.)

à Platform Independent – dot net application can be run on any operating system which has .net framework installed.

à Hardware Independent – dot net application can run on any hardware configuration

It allows us to build windows based application, web based application, web service, mobile application, etc.

2) What is .Net Framework?

.Net Framework provides a foundation upon which .net application and xml webservices are built and executed.

3) Two main Components of .Net Framework

1. Common Language Runtime

2. Base Class Library.

5) .Net Compliant Languages – Language which supports .Net Programming. Eg: VB, C#, C++, J#, etc.

6) .Net Application – Application which is developed using .Net Framework.

7) .Net Framework Class Library – It consist of thousands of Pre-developed classes that can be used to build application.

8) Common Language Specification (CLS) – It defines features that all .net compatible language should support.

9) Common Type System (CTS) – All .net supported languages will produce code that is ultimately based on these type.

10) Common Language Runtime (CLR) – It provides an “managed” environment in which .net application can execute.

It provides following services :

1. Language Integration

2. Memory Management (Memory Allocation and Garbage Collection)

3. Memory Type Safety (Memory Leaks)

4. Security

11) Microsoft Intermediate Language (MSIL)

An intermediate language generated by compiler is called MSIL. All .Net assemblies are represented in MSIL. The main Advantage of using MSIL is it provides equal performance for multiple language programming, as code is compiled to native code.

Eg: Performance of application developed in C# is similar to VB.net or any other .Net compliant language that is because of MSIL.

12) Managed Environment

Code that operates within the CLR is called managed code.Managed code benefits from the services that the CLR offers, including garbage collection, memory management, security, etc.

13) Unmanaged Environment

Code that does not operate within the CLR is called unmanaged code. Unmanaged code does not get benefits offered by CLR including garbage collection, memory management, security, etc. Eg. COM components are unmanaged code.

14) Advantage provided by Dot Net Framework

Language Independent, that is programmer can concentrate more on problem than to learn new language.

What is ADO.net

ADO.net is data access architecture for the Microsoft .NET Framework.

Difference between ADOand ADO.net

1. ADO used connected data usage, while ADO.net used disconnected data environment.

1. Data Source: It can be a database, text file, excel spread sheet or an XML file.

2. Data Provider: A set of libraries that is used to communicate with data source. Eg: SQL data provider for SQL, Oracle data provider for Oracle, OLE DB data provider for access, excel or mysql.

3. SQL Connection: It establishes connection.

4. SQL Command: It allows to manipulate database by executing stored procedure or sql statements.

5. SQL DataReader: It provides a forward-only, read-only, connected recordset.

6. DataSet: dataset is a disconnected, in-memory representation of data. It can contain multiple data table from different database.

7. SQL DataAdapter: It populates dataset from data source. It contains a reference to the connection object and opens and closes the connection automatically when reading from or writing to the database.

8. DataView: It provides a means to filter and sort data within a data table.