ADO.NET is a model used by .NET applications to communicate with a database for retrieving, accessing, and updating data. This module will provide the necessary skills to the students to work as a database Application developer in the industry.
.NET Framework enables you to create data centric application that enable you to access data from various data sources in heterogeneous environment using ADO.NET.
Brief History
1. Tebisco is a leading producer and distributor of snacks in the U.S., as well as in most of the company’s 23 international markets. In 1998, consumers spent $9.2 billion on Tebisco’s snacks, $1.4 billion more than in the previous year.
2. Tebisco started as a small bakery in Round Rock, Texas in 1978. In a short time, its gingersnaps, macaroons, shortbread and other cookies were popular all over the U.S. Three years ago, the management embarked on a rapid expansion plan. They set up offices in Asia and Europe, in addition to strengthening their U.S. operations.
3. Tebisco has got a centralized database management system whereby the information about all the HR activities is maintained.
CLICK HERE for ADO.NET Chapter -2
Overview of ADO.NET
Overview of ADO.NET
1. Business applications allow users to retrieve data from a database by presenting data in a user-friendly interface.
2. ADO.NET enables datacentric application to various data sources and retrieve, manipulate and update data.
3. ADO.NET use XML to transfer the data across the application and data sources
4. User need not remember the database commands for retrieving or updating data in the database.
5. Microsoft has created a family of data access technologies to help programmers build efficient applications to access data, regardless of its source.
6. The guidelines that can be followed for selecting an appropriate data access technology are:
a) Use ADO.NET for writing a managed code targeting the .NET Framework in Visual Basic, C#, and C++.
b) Use (OLE) DB for writing a Microsoft based application, a VB 6 COM application, or a C++ application using COM.
c) Use JDBC for writing a Java code targeting SQL Server.
d) Use Microsoft ODBC for writing a native code targeting Windows by using C or C++.
