The FusionWare mvLynx Direct product family provides a number of ways to get access to your MultiValue data.  One of the places where MultiValue applications tend to have a significant and important investment is in their file dictionaries.  In addition to identifying the raw data in the file for reporting purposes, these often include complex formulas, and implicit "joins" of data from other files.

In this post we will look at how you can take advantage of these assets in building out your data access strategy.

Once you determine the command to access this data, it can be used from Java, .NET, COM/COM+. With the mvLynx managed provider, you can use this to create web services, ASP.NET forms and controls, WinForms, SilverLight, Windows Presentation Foundation (WPF), SSIS scripts, Reporting Services reports and many other applications and solutions.

This is a follow up to a previous post that showed how to map the SALESORDER file with the mvLynx Direct Designer.

In this document we will create a macro-enabled workbook and use a pre-built macro to import MultiValued data into a series of worksheets in the workbook.

The data will come from the sample CUST file in the GAXOLEDB account that is created when the FusionWare Direct Data Access Server (Direct DAS) is installed on your MultiValue system.

You will need to modify the connection string to reflect your system, and you can freely modify the COMMANDTEXT property and other code to process different tables.

We will use the FusionWare Direct OLE DB Provider to access this data.

This document describes how you can rapidly create a DataSet of your MultiValued data without having to map your data.  Starting with a TCL LIST/SORT command that produces the output that you want to retrieve, we show you how to go from that to a fully functional ADO.NET command that retrieves this data for you.  Note that although we focus on ADO.NET, the same command can be called from COM/COM+ using the FusionWare Direct OLE DB Driver, or from Java using the FusionWare Java Data Adapter.

This article provides examples and explains in depth, how Microsoft's DbDataAdapter Fill method converts nested IDataReader objects representing MultiValued data into a series of DataTable and DataRelation objects in a DataSet.

Connecting to a MultiValue (PICK) database using FusionWare Direct ADO.NET provider from a WPF application using Visual Studio 2010.  Example code using the sample CUST file in the FusionWare Direct Data Access Server (Direct DAS) account. This is part two where we customize the Data Access Layer further to allow selective retrieval of data.