DbcToDbf 1.0.5

DbcToDbf (.NET)

A professional, 100% C# library to download, decompress, and read DATASUS .dbc files.

Features

• 100% Managed Code: No native dependencies.
• DBC Decompressor: Efficient implementation of the BLAST (PKWARE DCL) algorithm.
• DBF Reader (ADO.NET): Full DbDataReader implementation for seamless integration with Dapper, SqlBulkCopy, and DataTables.
• Datasus FTP Client: Smart navigation and filtering for the official DATASUS FTP server.
• High Compatibility: Targets .NET Standard 2.0.

Installation

dotnet add package DbcToDbf

Quick Start

1. Download and Read directly from DATASUS

The "Golden Path" for health data processing:

using DbcToDbf;

using (var client = new DatasusClient())
{
    // Search for SIHSUS files from São Paulo (SP) in 2023
    var files = client.GetFiles(DatasusSystems.Sihsus, uf: "SP", year: 2023);

    foreach (var file in files)
    {
        // OpenReader handles: Download -> Decompress -> DBF Open
        using (var reader = client.OpenReader(file))
        {
            while (reader.Read())
            {
                // Access data by name or index
                var value = reader["VAL_TOT"];
                var date = reader.GetDateTime(reader.GetOrdinal("NASC"));
            }
        }
    }
}

2. Manual Decompression

If you already have a .dbc file locally:

var decompressor = new DbcDecompressor();
decompressor.Decompress("input.dbc", "output.dbf");

3. Standalone DBF Reading

Read any .dbf file (dBase III+) with strong typing:

using (var reader = new DbfDataReader("output.dbf"))
{
    while (reader.Read())
    {
        string name = reader.GetString(reader.GetOrdinal("NOME"));
        decimal amount = reader.GetDecimal("VALOR");
    }
}

Advanced Filtering

The DatasusClient.GetFiles supports Regex and Wildcards:

// Get all RD files from SP or MG
var files = client.GetFiles(DatasusSystems.Sihsus, pattern: "RD(SP|MG).*");

Credits

Based on the BLAST algorithm by Mark Adler and inspired by the Python/C implementations for DATASUS.

License

MIT License.