2.4 Database
Delphi 2005 provides data access to ADO.NET, VCL, and VCL for .NET!
ADO.NET Data Access Support
Delphi 2005 achieves a lot of data access functions, most significant is ADO.NET, but there are many improvements in BDE, DBEXPRESS, and new DBGO for ADO.NET.
Enhanced Borland data provider
There are now many ADO.NETs corresponding to the Borland data provider, including the Boolean field supporting Interbase, Oracle Package Mechanism, Local Data Table Support, Getting Data Structure, and supports Sybase 12.5.
There is also the following certified BDP ADO.NET data provider driver: Borland Interbase 7.5 (can also work on Interbase7.1, 7.0 and 6.5, but without authentication), Oracle
10g
(Can also be in Oracle
9.2.0
And 9.1.0 running), IBM DB2 UDB 8.x (can work on 7.x), in addition, work on Microsoft SQL Server 2000, Microsoft MSDE 2000, Microsoft Access 2000, and Sybase 12.5.
An important component of the Enhanced Designer Database Design ADO.NET Designer is also enhanced in Delphi 2005. Add new stored procedure test support so you can test the specified stored procedure, including input parameters, then run the stored procedure And check the value of returning parameters (if any)
Delphi 2005 Test Sub_tot_Budget Store Dialog Box
Data table image features help you specify an image to the appropriate data table for BDPDataAdapter. You can set the column on the DataTable to a multi-specific memory table DataSet. You can also increase or remove memory data tables Column.
The object designer is now also providing a join string editor for the SqlConnection control, allowing you to specify the join string of the ADO.NET Provider.
Heterogeneous data support, BDP remote object
The two controls of RemoteServer and RemoteConnection are provided in the new ADO.NET control to support rapid development of three-layer applications (structure of the .NET remote object). Different new ADO.NET controls, DataHub and DataSync, support Different class databases are aggregated into a dataset. These four controls can be used, which can cause distributed applications to use a large number of different ADO.NET data providers. In this structure, DataHub and RemoteConnection are in the thin client layer, and The RemoteServer and DataSync controls will be in the service layer and join to the data provider.
The automatic update feature of the BDPDataAdapter is also enhanced, and now you can solve the multi-data table update and process more error.
data migration
There is a special control group in the BDP control group that supports data migration operations, which allows you to copy the BDP supported data tables to another type.
Dataset type (.NET)
The data table type can now be configured as a standard .NET assembly. It also supports the Web Services' dataset. The project manager provides a context-related menu to set the association and data editing collection in the data set, which you can be more convenient. Modify data set type
Enhanced database browser
The corresponding database browser of the BDP data provider has been enhanced in several parts. You can now simply migrate data from a BDP data provider to another. This feature allows you to copy another data from a BDP data provider. This will copy and re-establish metadata for replication target data tables. Even if this data is simply different data sources, such as migrating Oracle's data to MSSQL. This is similar to the behavior of the BDPCOPY control.
Database browser also has the ability to view additional metadata, and allow you to view and modify database models directly in the Database Browser, you can create new data tables directly, modify the data table and delete the existing data sheet .
At the same time, you can also drag a stored procedure directly in the Database Browser to the Form Designer, which will create a BDPConnection and a BDPCommand instance, and automatically set the BDPCommand parameters corresponding to the specified stored procedure. Database support for .vcl and vcl.net
Delphi 2005's database supports VCL and VCL.NETs support consists of BDE, DBEXPRESS, and DBGO for ADO, and Interbase Express (IBX), which are available in VCL and Vcl.Net projects, which provides one Seamless upgrade WIN32 program to the .NET method.
DBGO for ADO
In creating a VCL.NET application, Delphi 2005 now supports Win32 and .NET DBGO for ADO, which makes the portable Win32 DBGO for ADO to the .NET framework, DBGO for ADO controls need to install MDAC 2.8 To support.
The DBEXPRESS DBEXPRESS control group extends TSIMpleDataSet to support .NET and enhances the efficiency of TSQLSTOREDPROC, and also improves metadata.
The following drivers are now available to DBEXPRESS: Borland Interbase 7.5 (both interbases 7.1, 7.0, and 6.5, but without authentication), Oracle
10g
(Can use Oracle
9.2.0
And 9.1.0), IBM DB2 UDB 8.X (can use 7.x), Microsoft SQL Server 2000, IBM Informix 9.x, SQL Anywhere 9 (can use ASA 8), MySQL 4.0.x, and Sybase 12.5.
BDE for the Borland Database Engine (BDE) of VCL and Vcl.Net applications, is used to support local DBASE and Paradox data sets. The BDE for .NET version has now been improved, no need to specify the path, can automatically load BDE-related The DLL file has also improved the performance of the blob, and has added a few previously did not, the BDE control for .NET, which is: tupdatesql, tnestedTable, and TSToredProc.
IBX
Interbase Express (IBX) provides VCL and VCL.NET applications directly connect to Interbase.
2.5 Web Delphi 2005 contains a large number of web development technologies enhanced under VCL (Win32 and .NET) and ASP.NET.
Web deployment manager
Delphi 2005 increases a web deployment manager that can be used in the ASP.NET Web Form Each ASP.NET Web Service project, and Intraweb can adapt to VCL and VCL for .NET.WEB deployment manager can join to the directory ( Local or online) and FTP targets. The deployment manager's window can also display local files (from project directory) and remote files (from the directory or FTP location), and you just click on an option. You can implement the deployment of the entire project. You can also perform comparisons, remove files, etc. The deployment settings are saved with your project files, so you can deploy your project at different times in a consistent configuration. This is a very effective and fast deployment method. In addition to supporting the ASP.NET and Intraweb projects, the Web Deployment Manager can also extend other different project types supported.
Web data control
Web Data Controls can be used to write a powerful data-driven ASP.NET web form application. Delphi2005 introduces a large number of new web data controls, including DBWebaggRegateControl, DBWebsound, DbwebVideo, and DBWebnavigationExtender, Web
DBWebaggRegateControl can be used to display the aggregate values of each column in the data set, which can actually use the average value, count value, minimum, maximum, and total.
DBWebsound and DBWebVideo controls are added to support audio and video format. You can join a DBWebDataSource control to the data set corresponding to the data set or give it a URL path. DBWebnavigationExtender control is very useful in this case, that is, you want to send data to send data modification To the dataset, do not want to use the DBWebnavigation control (especially the ApplyToServer button in the control). DBWebnavigationExtender is a non-visual control that can be used to extend standard web controls - such as buttons - its features and DBWebnavigator The button is the same. So, you can use it to write a navigation strip control. In addition to these four new web controls, the DBWebDataSource control is extended to add an onautoApplyRequest event and now support nested updates and delete.
In addition to DBWebDataSource, web data controls can now be coupled to EcoDataSource-a control coupled to Eco II ExpressionHandler.
Delphi 2005 also provides a new Web Data Control Wizard to let you write your own web data control compatible with the ASP.NET control (you can also join DBWebDataSource or EcoDataSource)
Web data controls now support XML cache, this powerful feature enables a server-side briefcase to the web client.
Web data navigation
Delphi 2005 Web navigation data controls now have control command function, which uses the appropriate navigation API, such as RegisterNextControl, RegisterPreviousControl, RegisterFirstControl, RegisterLastControl, RegisterInsertControl, RegisterDeleteControl, RegisterUpdateControl, RegisterCancelControl, RegisterUndoControl, RegisterUndoAllControl, RegisterApplyControl, RegisterRefreshControl, and RegisterGoToControl.
Service control
ASP.NET's HTML type control is now able to represent a control in the background file. By selecting the "Run AS Server Control" option, it will add a runat = server property to the script of the control, which is like the control. Direct declarations in the source code file.
Template editor
Delphi 2005 now adds a template editor for DataGrid and DataList, allowing you to define and easier to edit your own custom column template.
IntrawEB When using VCL (Win32 or .NET), Delphi 2005 supports Intraweb using ATOZEDSOFTWARE (www.atozed.com) to develop applications. Intraweb allows fast-see-how to design web applications, very like ASP. NET, but there are still many places. The advantage of intRawb pair is to use the user without care of the underlying HTML syntax and can help the user to manage the web page. These ASP.NETs are unable to do. Intraweb class web applications and Non-visible VCL controls are compatible, such as BDE, DBEXPRESS, DBGO for ADO, and Interbase Express (this means upgrading from Win32 migration to .NET). Instead, ASP.NET's application has data The ability to access must use native .NET controls such as ADO.NET and BDP.
2.6 Enterprise Core Objects Eco II
Borland C # Builder 1.0 and Delphi8 have a first edition of ECO, now in Delphi 2005, it has been greatly strengthened to adapt to corporate applications developed with high-telescopic requirements. Relative initial version, there are many improvements in ECO II .
The most important enhancement summary is as follows:
- Support scalability, distributed application
- Support ASP.NET (Web Forms and Web Services) - supports images to an existing database
- Optimization of ease of use to make it easier to use the ECO process
Scalability, distributed application
The most important part is that Eco II now has an enterprise-class telescopic ability. Relative to the first version of the Client / Server solution, Eco II supports Client / Server and Remote Solutions. When you write ASP.NET with scalable ability or When the WinForms application, there are several structures that may be used. It is very easy to use. In the process or in different multi-processes, you want to synchronize multiple different cache objects such as ECOSPACES, you can manage it. Map relationships of synchronous persistence can be self-executed in the same process, or more likely to run in a process in the server.
Eco II and ASP.NET
Now use DEPHI 2005, we can use the Eco II and ASP.NET to use together, while fit the ASP.NET web form and ASP.NET Web service method. Orland's web data control is bound to a new EcoDataSource component by binding Ecosapce. Export objects, this is an expression of OCL to output a data source, and can also generate a data perceived ASP.NET web form. The same operation can fit any common native ASP.NET web control. ECO component, Such as ExpressionHandler can provide a list of elements that can be used as a DataSet, and can be bound to any ASP.NET components such as DataList and DataGrid. Because the requests raised by the ASP.NET application are stateless, we can in Session Or maintain the status of the ECOSPACE at the application level.
Eco II uses an optimism. When a conflict occurs, the Conflict resolution will use conflict resolution to determine the correct action. Especially when an Eco SAPCE detects the data in the background database and the "old value" saved in ECOCE, it will You will register a conflict into the ECOSPACE internal list. Developers can call RetrieveChanges to get any changes that have occurred in other ECOSapces, but also use getChanges to collect unresolved conflicts and determine how to deal with the end user control.
Eco II ASP.NET Web Forms in Delphi 2005
Image to existing database
Delphi 2005 with Eco II is now possible to use existing databases to implement application persistence. It is implemented using a newly enhanced object-associated image that uses XML file model drivers. This powerful menu has existing MS SQL Server, Oracle or Interbase database, and establish an image model as the UML model, and encapsulate the database's data.
Delphi 2005 imports Northwind into the Eco II model
