Open Database Connectivity (ODBC) is a standard or open Application Programming Interface (API), helpful in accessing a database. You can access files in a number of different databases, such as MS Access, dBase, DB2, MS Excel, and Text by using ODBC statements in a program. ODBC also allows programs to use SQL requests that can access databases without enabling to know the proprietary interfaces to the databases and handles the SQL request and it can convert the same into a request that the individual database system can understand.
Java Database Connectivity (JDBC) is a Java API that consists of a set of classes and interfaces written in Java for connecting programs written in Java to the data in Relational Databases. JDBC provides a standard API for tool or database developers enabling to write database applications using a pure Java API. It can also establish a connection with a database, sends SQL statements, and processes the results. It also allows SQL-based database access for EJB persistence.
Specific features like accessibility, security, localization, and performance optimization (binding) of the Windows Presentation Foundation (WPF) are best addressed by ADO.NET.
The elements can be bound from various data sources, including ADO.NET, in the form of common language runtime (CLR) and XML.
Creating a Binding
Binding an ADO.NET data follows the following steps;
- Specifying the Binding Source
- Specifying the Path to the Value
- Binding and BindingExpression
Specifying the binding source is done by setting the DataContext property on the DockPanel element, which then inherits the DataContext value from the DockPanel, its parent element. After specifying a suitable path to the values, a BindingExpression is established. BindingExpression, is the underlying object that helps the maintaining the connection between the ADO.NET data source and the target.
A binding to an ADO.NET contains all the information that can be shared across several binding expressions. Each binding usually has four components, such as binding target, target property, binding source, and a path to the source value to use.
Data accession is of crucial importance in application development. ADO. NET constitutes a set of computer software components that assists developers to access data and data services. They come as the base class libraries of Microsoft. NET Framework, and help programmers to access and make changes in the data available with relational database systems.
ADO. NET can also be used to access data for non-relational sources.
Benefits of Using of ADO. NET:
Unlike the popular belief that ADO.NET is a derivative of ActiveX Data Objects (ADO) technology, it comprises an array of added features. The extensive change makes is more of an entirely new product.
Comprising two primary subsections, viz., Data Provider and DataSets, ADO. NET offers robust XML support features. It also scores high in the subject of control of data access and behavior and is found to provide well-defined, factored components with predictable behavior, performance and semantics.
