pfAppsLibrary V3.0 Published May 20, 2016
The pfAppsLibrary suite of application and DLL source code modules was officially released on the CodePlex Open Source web site May 20, 2016.
Link to CodePlex page: https://pfappslibrary.codeplex.com/
These modules required the Windows .NET 4.0 runtime or later.
The applications and classes were originally developed in Visual Studio 2010 using the C# programming language.
Summary of features:
pfAppsLibrary includes a suite of source code modules and test databases that focuses on providing pre-built routines that enhance the building of .NET database applications.
Application Data Components
Classes in the AppDataComponents library provide a rich set of processing modules and input/output forms that can be used to build database applications in .NET.
Functionality found in AppDataCompnents:
- Routines to randomize DataTable column values with realistic looking random data.
- Classes that provide extensive support for exporting, filtering and sorting data in the data grid.
- Routines to import and export data to and from various database and file formats.
- Simplified methods for defining and applying filters to data output result sets.
Database Applications
Source code for the following database applications is provided:
- pfDataViewerCP
- Runs queries against relational data stores and displays results in a DataGridView object.
- Provides for randomizing and filtering of output data.
- XML formatted files used to save query definitions for later use.
- pfDataExtractorCP
- Runs data exports and imports for a variety of data sources and destinations.
- Provides for randomizing and filtering of output data.
- XML formatted files used to save extractor definitions for later use.
- Provides ability to preview data extract using a DataGridView object.
- pfConnectionStringManager
- Shows form on which database connection strings can be defined and verified.
- pfRandomDataSources
- Provides a set of forms for the definition and generation of random data.
Databases and Data Files
Routines include support for the following data formats:
- Relational Databases
- SQL Server, SQL CE 3.5 and 4.0.
- ODBC drivers and OLEDB providers via ADO.NET ODBC and OLEDB classes.
- DB2, Informix, Oracle, MySQL, SQLAnywhere, SQLAnywhere
UltraLite, Sybase
- These platforms require client drivers to be obtained and installed on your machine.
- Desktop Databases
- MS Access
- Excel
- Text Files
- XML Formatted
- Delimited
- Fixed Length
pfAppsLibrary also includes numerous test databases, sample query/extract definitions and random data files.
Visual Studio Application Templates
Library also includes several application modules that can be used as Visual Studio templates for .NET project development.