Shulou(Shulou.com)06/02 Report--

This article mainly explains "what are the skills related to the use of ADO.NET classes and interfaces". Interested friends may wish to have a look. The method introduced in this paper is simple, fast and practical. Now let the editor take you to learn "what are the skills related to the use of ADO.NET classes and interfaces"?

Customizing database access classes for each type of database server is one of the main features of the design of ADO.NET classes and interfaces. Although driver classes are different, all of these classes have the same basic functionality and can usually be used interchangeably. The trick is by defining database-specific ADO.NET classes and interfaces.

If you have ever used Borland ®Delphi, C++Builder, or Kylix, you know that the most convenient way to connect to a database like IBM ®DB2 ®Universal Database TM (UDB) is to use some components from Borland Visual Component Library (VCL).

With Borland C#Builder TM, everything has changed: instead of using Borland VCL, you now use Microsoft ®.NET Framework, especially ADO.NET, and you don't need Borland Database Engine or dbExpress.

Bob Swart's two articles on connecting to DB2 UDB data show that C#Builder makes it easy to create simple database applications that use Borland Data Provider (BDP) and ADO.NET classes and interfaces.

In this article, ADO.NET classes and interfaces we'll see what all those ADO.NET classes and interfaces can do for us. We will use C#Builder Enterprise, DB2 UDB, and IBM Managed Data Provider for the Microsoft .NET Framework.

Note that we will use a code provider managed by DB2 as some examples. To install the code manager, you need a DB2 UDB 8.1 FixPak 3 or better WADO.NET class and interface indows client that installs the Microsoft .NET Framework DB2 UDB driver.

If you are using C#Builder now, you will need to add an IBM.Data.DB2 assembly (assembly)-- use Project | Add Reference, then select Browse and navigate to the IBM DB2 .NET Framework 1.1 assembly. By default, this assembly is installed in C:\\ Program Files\\ IBM\\ SQLLIB\\ BIN\\ netf11. If necessary, I will use the regular DB2 UDB sample database for ADO. Net classes and interfaces.

Using ADO.NET: visual or non-visual?

One of the major challenges that VCL users will soon encounter is that there is no corresponding data model in the .NET Framework. This means that there is no easy way to reference an object from an object in another format in the visual context of the user interface. Although there are many alternatives, they all depend on the code.

In this article, I include some code examples to show you what to do. Fortunately, like VCL, one of the impressive aspects of ADO.NET classes and interfaces is that it is very easy to create database access logic from program code. All of these code examples will use C #. Once you understand the program code (especially the subtleties of interfaces and classes), it's easy to write a "wrapper" class for database access logic. If the wrapper class is written in an appropriate manner, the end result is the "business logic" class, which can handle all database access and can be used throughout the application. A good example of this is the IBuySpy application we discussed in the previous article.

At this point, I believe you have a deeper understanding of "what are the skills related to the use of ADO.NET classes and interfaces". You might as well do it in practice. Here is the website, more related content can enter the relevant channels to inquire, follow us, continue to learn!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.