Data Provider Architecture

Delphi 8 for .NET supports the .NET Framework providers, plus providers included in BDP.NET.

  1. NET provides a high performance architecture for accessing data sources without a COM Interop layer.
  2. NET Advantages
  3. NET provides a number of advantages:
  • A unified programming model applicable to multiple database platforms.
  • A high performance data-access architecture.
  • The open architecture supports additional databases easily.
  • Portable code to write once and connect to any supported databases.
  • Consistent data type mapping across databases where applicable.
  • Logical data types mapped to .NET native types.
  • Unlike OLE DB, no need for a COM Interop layer.

Delphi 8 for .NET extends .NET support to additional database platforms, providing a consistent connection architecture and data type mapping.

BDP.NET and ADO.NET Components_

All databases and connection components expose data in ADO.NET's DataSet component. The DataSet is the common denominator for all databases, presenting a unified programming model with tables and relational navigation. BDP.NET providers encapsulate implementation details for each database, while still providing high performance data-access.

BDP.NET Data Types_

The .NET Framework includes a wide range of logical data types. BDP.NET inherits logical data types, providing built-in mappings to supported databases. For more information, see the BDP.NET Data Types topic.

BDP.NET Interfaces_

You can extend BDP.NET to support other DBMS by implementing a subset of the .NET Provider interface. BDP.NET generalizes much of the functionality required to implement data providers. While the .NET Framework gives you the capabilities to create individual data providers for each data source, Borland has simplified the task by offering a generalized set of capabilities. Instead of building separate providers, along with corresponding DataAdapters, DataReaders, Connection objects, and other required objects, you can implement a set of BDP.NET interfaces to build your own data source plugins to the Borland Data Provider.

Building plug-ins is a much easier task than building a completely new data provider. You build an assembly that contains the namespace for your provider, as well as classes that encapsulate provider-specific functionality. Much of the functionality you need to connect to, execute commands against, and retrieve data from your data source has already been defined in the Borland Data Provider interfaces.

  1. NET Data Types
  2. NET data types map to .NET logical types. Dependant upon the database, BDP.NET data types map to native data types. Where applicable, BDP.NET provides:
  • Consistent data type mapping across databases.
  • Logical data types mapped to .NET native types.
Project Management Made Easy

Project Management Made Easy

What you need to know about… Project Management Made Easy! Project management consists of more than just a large building project and can encompass small projects as well. No matter what the size of your project, you need to have some sort of project management. How you manage your project has everything to do with its outcome.

Get My Free Ebook

Post a comment