.NET interview: What is ADO.NET?
ADO.NET is a part of the Microsoft .NET Framework. This framework provides the set of classes that deal with data communication between various layers of the software architecture and the database. It provides a continious access to different data source types such as SQL Server versions 7, 2000, 2005. It also provides connectivity options to data sources through OLE DB and XML. Connectivity may be established with other databases like Oracle, MySQL etc. as well.
ADO.NET has the ability to separate data access
mechanisms, data manipulation mechanisms and data connectivity mechanisms.
ADO.NET introduces along with it the disconnected architecture. In a disconncted architecture, data may be stored in a DataSet. It contains providers for connecting to databases, commands for execution and retrieval of results.
The classes for ADO.NET are stored in the DLL System.Data.dll.
10 .NET questions
How do you view the methods and members of a DLL? - What is shadowing?
- How do you load an assembly at runtime?
- If I am writing in a language like VB or C++, what are the procedures to be followed to support .NET?
- Compare Client server application with n-Tier application
- Differences between DLL and EXE?
- Can an assembly have EXE?
- Can a try block have more than one catch block?
- Can a DLL be changed to an EXE?
- Compare & contrast rich client (smart clients or Windows-based) & browser-based Web application
- What are the collections you’ve used?
- Can a try block have nested try blocks?
