Btrieve Classes for .NET - Summary

by AG-TECH - Product Type: Component / .NET WinForms / 100% Managed Code

Summary

Btrieve Classes for .NET by AG-TECH

URLs: btrieve-classes-net, btrieve classes net, btrieveclassesnet, ag-tech, ag tech, agtech

Btrieve Classes for .NET is a set of .NET database access support classes that enable fast, easy to program access from .NET programs to Pervasive PSQL databases via the Btrieve API. They include a Native Class that allows direct Btrieve API access and a DDF Class that automatically reads Pervasive DDF files dynamically during run time, removing the need for table, field and other metadata definitions to be done statically within your program, and allowing database metadata changes after program build. As such they greatly help developers looking to write new .NET programs accessing data in Pervasive PSQL databases or those looking to migrate existing pre- .NET Btrieve/Pervasive applications to .NET.Btrieve Classes for .NET performs more efficiently and hence faster than ADO.NET or Pervasive's OLE DB provider. Moving your existing Btrieve API based business logic to an SQL DB can be very difficult, Btrieve Classes for .NET provides a way to access the Btrieve API easily from within .NET removing the need for such a business logic move. By preserving the use of Btrieve in your program, the loss of performance and full detailed locking control associated with converting to using SQL transactions is not seen. Full support of Btrieve extended operations is included for even better performance. With Version 4.0 support for Pervasive's latest Pervasive PSQL v11 database, Visual Studio 2010, and Windows 7 has been added.

Product overview

Btrieve Classes for .NET is a set of .NET database access support classes that enable fast, easy to program access from .NET programs to Pervasive PSQL databases via the Btrieve API.

They include a Native Class that allows direct Btrieve API access and a DDF Class that automatically reads Pervasive DDF files dynamically during run time, removing the need for table, field and other metadata definitions to be done statically within your program, and allowing database metadata changes after program build.

Performance Comparison Test Results

With a simple C# test application that displays all the First_Name column values of the Person table in Pervasive.SQL V8.6's DEMODATA in a list box, the test results showed that Btrieve Classes for .NET was 3-20 times faster compared with ADO.NET and Pervasive's OLEDB driver.

Why is the performance better?

The main cause for this is believed to be the sheer size of the ADO.NET and Pervasive OLE DB provider layers. It may also be because of the overhead associated with RPC based marshalling in a COM software module is also considerable.

Btrieve Classes for .NET class library calls the Btrieve API directly from

C++ unmanaged code, so the software layer is very thin. The data C++

transfer code between managed and unmanaged data has been optimized to minimize data transfer volume. Because the C++ language was chosen to produce Btrieve Classes for .NET it is possible to perform more finely tuned data marshalling compared to the generic data marshalling code available in C# and elsewhere.

Also, ADO.NET and the OLE DB provider have many features and functionality to support a large variety of multi-vendor databases. In contrast, the fact that Btrieve Classes for .NET class libraries, by specializing on Pervasive/Btrieve, avoids this kind of generic code is another reason behind the product's better performance.

The Structure Builder

The .NET language makes it possible to specify the memory alignment of structures by using the System.Runtime.Interop classes, something that was not possible in VB6 days. However the definition of this alignment is very complicated. The workload involved in coding the necessary complex structures can become very large especially as the number of columns and tables increases. Also mistakes involving the definition of the true null indicator byte can consume large amounts of a developer's time.

To make the job of defining such structures much easier, a Structure Builder Tool is included. This is a brand new add-in tool for Microsoft Visual Studio for .NET that automatically generates the stucture definition code you need directly into your source code by referring to the table definitions in your DDF files. The target languages supported for this structure code building are Visual C# and Visual Basic.NET.

Two types of class library

This product includes two types of class library. Please select according to the needs of your application.

DDF Classes - A new group of classes specifically designed for the .NET Framework. It is composed of classes such as Record/Extended/Transaction/Exception. These enable smart and efficient access to column data and definition of data type conversion code. This class provides excellent development efficiency when working on new code.

Native Class - This is a class that provides Btrieve API level access from .NET managed code, something that is as yet unavailable in the Pervasive.SQL SDK. This class is ideally suited for cases where you wish to migrate existing Btrieve API applications to .NET or if your existing application does not have DDFs. However, due to the fact that the Btrieve API contains many parameters and to the necessity of code for fetching and storing application data from the record buffer, application code can become complicated.

Features:

The product is a .NET Framework class library.

Enables easy access to Pervasive/Btrieve data from .NET languages such as C#,VB.NET

Supports both Windows and Web applications

Automatic conversion of data encoded in the code page of the locale <-> Unicode

Extended class enables maximum performance when searching Pervasive data

In only 1 line of code, it is possible to generate a DataSet Object and call a method, making filling a grid very simple

Library itself is developed using C++, in order to minimize the overhead associated with a Btrieve API call

By making full use of such .NET class library features as overloading, the classes are very easy to use Supports True Nullable column data

Supports the BigInt data type by mapping to .NET's Int64.(8byte integer)

VB.NET and C# sample code is provided for both Web and Windows applications

Full support for Pervasive PSQL's security functionality.

This includes Login and Logout methods and support for database URIs.

Support for both 32-bit and 64-bit .NET applications Support for access to Pervasive/Btrieve data via .NET Framework 3.5's LINQ

Runtime license free English and Japanese versions available

Visual Studio 2005, 2008 and 2010 are supported as the development environment of this product.

Supported .NET languages

Microsoft Visual Basic.NET

Microsoft Visual C#

Microsoft Visual J#

New Functionality in Version 4.0

Support for Pervasive's latest PSQL v11 database.

Support for Microsoft Visual Studio 2010 and Windows 7.

New Functionality in Version 3.0

LINQ support.

Support for Pervasive PSQL Summit v10.

Support for Microsoft Visual Studio 2008.

64-bit OS and application support.

Btrieve Classes for .NET is a set of .NET database access support classes that enable fast , easy to program access from .NET programs to Pervasive PSQL databases via the Btrieve API.

Pricing: Btrieve Classes for .NET V4.0 1 Developer License

Evals & Downloads: Read the Btrieve Classes for .NET help file, Btrieve Classes for .NET Programming Manual - Requires Acrobat Reader, Download the Btrieve Classes for .NET V4.0 evaluation on to your computer - Limited Functionality

Operating System for Deployment: Windows 7, Windows Server 2008, Windows Vista, Windows XP, Windows Server 2003

Architecture of Product: 32Bit, 64Bit

Product Type: Component

Component Type: .NET WinForms, 100% Managed Code

Built Using: Visual Basic .NET, Visual C++ .NET 2002 / 2003, Visual C# .NET

Compatible Containers: Microsoft Visual Studio 2010, Microsoft Visual Studio 2008, Microsoft Visual Studio 2005, Microsoft Visual Studio .NET 2003, Microsoft Visual Basic 2010, Microsoft Visual Basic 2008, Microsoft Visual Basic 2005, Microsoft Visual Basic .NET 2003, Microsoft Visual C++ 2010, Microsoft Visual C++ 2008, Microsoft Visual C++ 2005, Microsoft Visual C++ .NET 2003, Microsoft Visual C# 2010, Microsoft Visual C# 2008, Microsoft Visual C# 2005, Microsoft Visual C# .NET 2003, .NET Framework 4.0, .NET Framework 3.5, .NET Framework 3.0, .NET Framework 2.0

Product Class: .NET Development Tool

Keywords: BtrieveClasses AGTECH

AG-TECH

Development

Database DB Connectivity

Part numbers: PC-514262-325291 514262-325291