CrystalNet ADO.Net VCL for Delphi 4.0.2.0

ADO.Net VCL for Delphi is the fastest and most reliable database connectivity solutions for any database using ADO.Net technology in Delphi. It provides data access to data sources such as SQL Server, Oracle, SQLite and to data sources exposed through OLE DB and ODBC using ADO.Net data provider framework. ADO.Net VCL for Delphi is an enterprise solution with highest performance and unlimited possibilities. Data-sharing consumer applications can use ADO.NET VCL for Delphi to connect to these data sources and retrieve, handle, and update the data that they contain.

With its powerful common architecture base on ADO.Net technology, ADO.Net VCL for Delphi enables high-speed direct data access from Delphi to SQL Server, Oracle, SQLite and other data sources exposed through OLE DB and ODBC.

ADO.Net VCL for Delphi provides a library of components for connecting to a database, executing commands, and retrieving results. Those results are either processed directly, placed in a Virtual Table components. The Virtual Table component can also be used independently of any active connection to manage data local to the application or sourced from XML.

You have the choice of either using client-side or server-side cursors. The ADO.Net VCL for Delphi actually handle the work of cursors. The developer has the freedom of choice in development, for creating efficient applications.

The ADO.Net VCL for Delphi consists of the following library of Data Access components:
SqlClient Data Access Components
OracleClient Data Access Components
SQLite Data Access Components
ODBC Data Access Components
OLE DB Data Access Components
Virtual Table Components

SqlClient Data Access Components (SqlClientDAC) is a feature-rich and high-performance library of components that provides native connectivity to SQL Server from Delphi for both 32-bit and 64-bit Windows platforms. SqlClientDAC-based applications connect to SQL Server directly through the ADO.Net SqlClient, which is a .NET Framework Data Provider for SQL Server. SqlClientDAC aims to assist programmers in developing of fast and native SQL Server database applications. SqlClientDAC uses its own protocol to communicate with SQL Server and it is lightweight and performs well because it is optimized to access a SQL Server directly without adding an OLE DB or Open Database Connectivity (ODBC) layer.

OracleClient Data Access Components (OracleClientDAC) is a feature-rich and high-performance library of components that provides native connectivity to Oracle from Delphi for both 32-bit and 64-bit Windows platforms. OracleClientDAC-based applications connect to Oracle directly through the ADO.Net OracleClient, which is an Oracle Data Provider for .NET (ODP.Net). OracleClientDAC aims to assist programmers in developing of fast and native Oracle database applications. OracleClientDAC allows developers to take advantage of advanced Oracle database functionality, including Real Application Clusters, self-tuning statement cache, and fast connection failover.

SQLite Data Access Components (SQLiteDAC) is a feature-rich and high-performance library of components that provides native connectivity to SQLite from Delphi for both 32-bit and 64-bit Windows platforms. SQLiteDAC-based DB applications are easy to deploy, do not require installation of other data provider layers (such as BDE or ODBC), and that’s why they can work faster than the ones based on standard Delphi data connectivity solutions. SQLiteDAC-based applications connect to SQLite directly through the SQLite.Net, which is an ADO.NET provider for SQLite.

ODBC Data Access Components (ODBCDAC) is a feature-rich and high-performance library of components that provides data access for data sources exposed through ODBC from Delphi for both 32-bit and 64-bit Windows platforms. ODBCDAC-based applications connects to any data source exposed through ODBC using the .NET Framework Data Provider for ODBC. ODBCDAC aims to assist programmers in developing of fast and native database applications. ODBCDAC uses the native ODBC Driver Manager (DM) to enable data access.

OLE DB Data Access Components (OLEDBDAC) is a feature-rich and high-performance library of components that provides data access for data sources exposed through OLE DB from Delphi for both 32-bit and 64-bit Windows platforms. OLEDBDAC aims to assist programmers in developing of fast and native database applications. OLEDBDAC uses native OLE DB through COM interop to enable data access.

OLEDBDAC does not support OLE DB version 2.5 interfaces. OLE DB Providers that require support for OLE DB 2.5 interfaces will not function correctly with the OLE DB Data Access Components. This includes the Microsoft OLE DB provider for Exchange and the Microsoft OLE DB provider for Internet Publishing.

Virtual Table Components is a feature-rich and high-performance library of components that provides an in-memory cache of data retrieved from a data source. It offers a disconnected data source architecture which means there is no need of active connections during work with this component. It can be used to hold multiple tables with data. You can select data form tables, create views based on table. The component also provides you with rich features like saving data as XML and loading XML data.

Main Features
Direct Mode
Allows your application to work with SQL Server, Oracle, SQLite and other data sources through ODBC or OLE DB providers directly without involving a DB Client library, thus significantly facilitating deployment and configuration of your applications.

Performance
All our components and libraries are designed to help you write high-performance, lightweight data access layers, therefore they use ado.net data access technologies and techniques of optimization.

Handling Cursors
When a SQL command is executed and it has to return rows, the DBMS creates a cursor on the DBMS server. An application uses the cursor to retrieve rows from a database. There are serveral cursor kinds to choose from using the FetchOptions.CursorKind property.

Rowset Fetching
Rowset Fetching allows you to specify the number of records that will be fetched from the server in one network round trip. You can optimize this separately for each SELECT statement that you execute, thereby minimizing the number of network round trips by specifying the RowsetSize option. The rowset size is controlled by the FetchOptions.RowsetSize property and the rowsets are fetched according to the FetchOptions.Mode property.

DataReader Provider
DataReader is used to read the data from database and it is a read and forward only connection oriented architecture when fetching data from database. DataReader will fetch the data very fast when compared to other TCustomClrDataSet descendants.

DataAdapter Provider
DataAdapter acts as a Bridge between TCustomClrDataSet descendants and database. This dataadapter object is used to read the data from database and bind that data to TCustomClrDataSet descendants. It is a disconnected oriented architecture.

IDE Compatibility
Our product is compatible with the latest IDE versions: Embarcadero RAD Studio 10.2 Tokyo. It is also compatible with the previous IDE versions since CodeGear Delphi 2009.

DB Compatibility
Our product supports the latest versions of the popular database servers like Oracle, SQL Server, SQLite and other data sources (using ODBC and OLE DB providers) such as MySQL, InterBase, Firebird, PostgreSQL etc.

SqlClientDAC components
SqlClientConnection
TSqlClientConnection
Lets you set up and control connections to SQL Server database.

SqlClientCommand
TSqlClientCommand
Executes a Transact-SQL statement or stored procedure against a SQL Server database.

SqlClientDataReader
TSqlClientDataReader
Provides a way of reading a forward-only stream of rows from a SQL Server database.

SqlClientDataAdapter
TSqlClientDataAdapter
Lets you fill Virtual Table components with data and update a SQL Server database.

SqlClientBulkCopy
TSqlClientBulkCopy
Lets you efficiently bulk load a SQL Server table with data from another source.

SqlClientQuery
TSqlClientQuery
Uses SQL statements to retrieve data from tables in a SQL Server database and pass it to one or more data-aware components through a TDataSource object.
This component provides a mechanism for updating data.

SqlClientTable
TSqlClientTable
Lets you retrieve and update data in a single table in a SQL Server database without writing SQL statements.

SqlClientStoredProc
TSqlClientStoredProc
Executes stored procedures and functions in a SQL Server database. Lets you edit cursor data returned as parameter.

OracleClientDAC components
OracleClientConnection
TOracleClientConnection
Lets you set up and control connections to Oracle database.

OracleClientCommand
TOracleClientCommand
Executes a Transact-SQL statement or stored procedure against an Oracle database.

OracleClientDataReader
TOracleClientDataReader
Provides a way of reading a forward-only stream of rows from an Oracle database.

OracleClientDataAdapter
TOracleClientDataAdapter
Lets you fill Virtual Table components with data and update an Oracle database.

OracleClientQuery
TOracleClientQuery
Uses SQL statements to retrieve data from tables in an Oracle database and pass it to one or more data-aware components through a TDataSource object.
This component provides a mechanism for updating data.

OracleClientTable
TOracleClientTable
Lets you retrieve and update data in a single table in an Oracle database without writing SQL statements.

OracleClientStoredProc
TOracleClientStoredProc
Executes stored procedures and functions in an Oracle database. Lets you edit cursor data returned as parameter.

SQLiteDAC components
SqliteConnection
TSQLiteConnection
Lets you set up and control connections to SQLite database.

SqliteCommand
TSQLiteCommand
Executes a Transact-SQL statement or stored procedure against a SQLite database.

SqliteDataReader
TSQLiteDataReader
Provides a way of reading a forward-only stream of rows from a SQLite database.

SqliteDataAdapter
TSQLiteDataAdapter
Lets you fill Virtual Table components with data and update a SQLite database.

SqlitetQuery
TSQLiteQuery
Uses SQL statements to retrieve data from tables in a SQLite database and pass it to one or more data-aware components through a TDataSource object.
This component provides a mechanism for updating data.

SqliteTable
TSQLiteTable
Lets you retrieve and update data in a single table in a SQLite database without writing SQL statements.

ODBCDAC components
OdbcConnection
TOdbcConnection
Lets you set up and control connections to a data source through ODBC drivers.

OdbcCommand
TOdbcCommand
Executes a Transact-SQL statement or stored procedure against a data source.

OdbcDataReader
TOdbcDataReader
Provides a way of reading a forward-only stream of rows from a data source.

OdbcDataAdapter
TOdbcDataAdapter
Lets you fill Virtual Table components with data and update a data source.

OdbcQuery
TOdbcQuery
Uses SQL statements to retrieve data from tables in a data source and pass it to one or more data-aware components through a TDataSource object.
This component provides a mechanism for updating data.

OdbcTable
TOdbcTable
Lets you retrieve and update data in a single table in a data source without writing SQL statements.

OdbcStoredProc
TOdbcStoredProc
Executes stored procedures and functions in a data source. Lets you edit cursor data returned as parameter.

OLEDBDAC components
OleDbConnection
TOleDbConnection
Lets you set up and control connections to a data source through OLE DB provider.

OleDbCommand
TOleDbCommand
Executes a Transact-SQL statement or stored procedure against a data source.

OleDbDataReader
TOleDbDataReader
Provides a way of reading a forward-only stream of rows from a data source.

OleDbDataAdapter
TOleDbDataAdapter
Lets you fill Virtual Tables components with data and update a data source.

OleDbQuery
TOleDbQuery
Uses SQL statements to retrieve data from tables in a data source and pass it to one or more data-aware components through a TDataSource object.
This component provides a mechanism for updating data.

OleDbTable
TOleDbTable
Lets you retrieve and update data in a single table in a data source without writing SQL statements.

OleDbStoredProc
TOleDbStoredProc
Executes stored procedures and functions in a data source. Lets you edit cursor data returned as parameter.

Virtual Table components
ClrMemTable
TClrMemTable
Use TClrMemTable to manage data in the client memory and optionally exchange the data with a data source. It offers a disconnected data source architecture which means there is no need of active connections during work with this component.

ClrDataTable
TClrDataTable
Represent an in-memory cache of data retrieved from a data source. It offers a disconnected data source architecture which means there is no need of active connections during work with this component.

Pre-requisite
Net Runtime Library for Delphi Enterprise Edition
Supported Target Platforms
Windows, 32-bit and 64-bit
General usability
Direct access to server data without using client library. Does not require installation of other data provider layers (such as BDE)
Interface compatible with standard data access methods, such as ADO
Bulk copying of data from a data source to Sql server database using TSqlClientBulkCopy component
Supports the posting of deferred updates, so called Cached Updates
Provides methods to sort the records. The dataset sorting allows you to get the required records order without requiring a database
Provides methods to filter the records. The dataset filtering allows you to get record subsets based on a condition
Provides flexible support for master-detail relationships between datasets
Support prefetching rows – specifies the number of rows that are to be fetched per server round trip. This is controlled by FetchOptions.RowsetSize property
Unicode support
Easy to deploy
Network and connectivity
Disconnected mode with automatic connection control for working with data offline
Transmission is via XML format, therefore can pass through firewalls
Compatibility
Full support of the latest server versions
Compatible with Code Gear RAD Studio 2009, Embarcadero RAD Studio 2010, XE, XE2, XE3, XE4, XE5, XE6, XE7, XE8, Seattle, Berlin, Tokyo
Support for all standard and third-party visual data-aware controls
Performance
High performance access to the data source
Fast controlled fetch of large data blocks
Advanced connection pooling
High performance of applying cached updates with batches controlled by UpdateOptions.UpdateBatchSize property.
Fast locate in a sorted DataSet
High performance batch processing
Intelligent fetch block size control
Rowset fetching support using TDbRecordSet Class which mimics the behaviour of ADO RecordSet Object using ADO.Net technology
ADO.NET VCL components uses XML to store and transfer data among applications, which provide fast access of data for desktop and distributed applications
Local data storage operations
Database-independent data storage with TClrMemtable and TClrDataTable components
CachedUpdates operation mode controlled UpdateOptions.UpdateMode property
Local sorting and filtering, including by calculated and lookup fields
Local master/detail relationship
Data access and data management automation
Automatic data updating with Query, Table, and StoredProc components
Fast-forward data retrieval with DataReader component
Automatic record refreshing and locking
Automatic query preparing
Data exchange
Transferring data from all types of TCustomClrDataSet descendants, Xml etc to a Sql Server database using TSqlClientBulkCopy component
Data export and import to/from XML
Product clarity
Documentation to get you started is available
A large amount of helpful demo projects
Licensing and support
Free license, only annual ADO.Net DAC Subscription with Priority Support is required
Royalty-free

database, components, source, Delphi, Server, through, SQLite, Oracle, access, applications, provides, component, Components, retrieve, using, performance, Access, update, sources, Virtual, database, components, source, Delphi, Server, through, SQLite, Oracle, applications, access, provides, retrieve, Components, using, component, update, Access, performance, sources, Table

DOWNLOAD