What is DuckDB.NET and how does it integrate with C#?

DuckDB.NET is an open-source provider of .NET bindings for the DuckDB native library, allowing developers to leverage DuckDB's powerful analytical capabilities within .NET applications. It integrates seamlessly with C#, providing an ADO.NET provider for easy database interactions.

How can I install DuckDB.NET in my C# project?

You can install DuckDB.NET in your C# project by using the .NET CLI command 'dotnet add package DuckDB.NET.Data.Full' or by using the NuGet Package Manager in Visual Studio.

What is the basic usage example of DuckDB.NET in a C# application?

In a C# application, you can use DuckDB.NET to execute SQL queries by establishing a DuckDBConnection to an in-memory database, creating tables, inserting data, and retrieving results using SQL commands and C# constructs.

How does IronPDF complement DuckDB.NET for developers?

IronPDF is a C# PDF library that can generate, manage, and extract content from PDF documents. It complements DuckDB.NET by allowing developers to create PDF reports containing database query results using HTML conversion and browser-based rendering technologies.

What are the capabilities of IronPDF in handling PDFs?

IronPDF allows you to convert HTML, CSS, and JavaScript content to PDF documents, extract images and text from PDFs, and perform editing operations like setting properties and adding digital signatures, all within cross-platform .NET environments.

Can IronPDF work with both HTML strings and files?

Yes, IronPDF can convert both HTML strings and HTML files to PDF documents, offering the flexibility to generate PDFs from various sources including URLs and in-app HTML content.

How does DuckDB.NET support data ingestion from files?

DuckDB.NET supports reading data from various file formats like CSV and Parquet. For example, you can use the COPY statement to import data from a CSV file into a DuckDB table.

Is there a way to export data from DuckDB.NET to a file?

Yes, using DuckDB.NET, you can export table data to files such as CSVs through SQL commands like 'COPY integers TO 'output.csv' (FORMAT CSV);'.

How do DuckDB.NET and IronPDF enhance the development of data-driven applications?

DuckDB.NET offers powerful data processing capabilities by allowing SQL-based interactions within C#, while IronPDF enables rich report generation in PDF format. Together, they provide an efficient workflow for producing data-centric applications that require in-depth data analysis and presentation.

Do I need a license to use IronPDF, and how can I obtain it?

Yes, IronPDF requires a license to run. You can acquire a trial license from IronPDF's trial license page or purchase a full license for broader use.

The C# PDF Library

Explore IronPDF Start Free Trial

HTML to PDF

Online Demo See All Code Examples

using IronPdf;

// Disable local disk access or cross-origin requests
Installation.EnableWebSecurity = true;

// Instantiate Renderer
var renderer = new ChromePdfRenderer();

// Create a PDF from a HTML string using C#
var pdf = renderer.RenderHtmlAsPdf("<h1>Hello World</h1>");

// Export to a file or Stream
pdf.SaveAs("output.pdf");

// Advanced Example with HTML Assets
// Load external html assets: Images, CSS and JavaScript.
// An optional BasePath 'C:\site\assets\' is set as the file location to load assets from
var myAdvancedPdf = renderer.RenderHtmlAsPdf("<img src='icons/iron.png'>", @"C:\site\assets\");
myAdvancedPdf.SaveAs("html-with-assets.pdf");

using IronPdf;

// Disable local disk access or cross-origin requests
Installation.EnableWebSecurity = true;

// Instantiate Renderer
var renderer = new ChromePdfRenderer();

// Create a PDF from a HTML string using C#
var pdf = renderer.RenderHtmlAsPdf("<h1>Hello World</h1>");

// Export to a file or Stream
pdf.SaveAs("output.pdf");

// Advanced Example with HTML Assets
// Load external html assets: Images, CSS and JavaScript.
// An optional BasePath 'C:\site\assets\' is set as the file location to load assets from
var myAdvancedPdf = renderer.RenderHtmlAsPdf("<img src='icons/iron.png'>", @"C:\site\assets\");
myAdvancedPdf.SaveAs("html-with-assets.pdf");

PM >Install-Package IronPdf

Install-Package IronPdf

.NET HELP

DuckDB C# (How It Works For Developers)

Jacob Mellor

Updated: August 1, 2026

DuckDB.NET is an open-source provider of .NET bindings for the DuckDB native library, designed to integrate seamlessly with C#. It provides an ADO.NET provider, making it easy to use DuckDB, a low-level bindings library, within .NET applications. This package is ideal for developers looking to leverage DuckDB's powerful analytical capabilities in a C# environment.

Installation

Installing DuckDB.NET is straightforward. You can add it to your project using the .NET CLI:

dotnet add package DuckDB.NET.Data.Full

dotnet add package DuckDB.NET.Data.Full

SHELL

Alternatively, you can install it via the NuGet Package Manager in Visual Studio.

Basic Usage

Once installed, you can start using DuckDB.NET to execute SQL queries within your C# application. Here's a simple example:

using System;
using DuckDB.NET.Data;

class Program
{
    static void Main()
    {
        // Create and open a connection to an in-memory DuckDB database
        using var duckdbconnection = new DuckDBConnection("Data Source=:memory:");
        duckdbconnection.Open();
        
        // Create a command associated with the connection
        using var command = duckdbconnection.CreateCommand();
        // Create a table named 'integers'
        command.CommandText = "CREATE TABLE integers(foo INTEGER, bar INTEGER);";
        command.ExecuteNonQuery();

        // Insert some data into the 'integers' table
        command.CommandText = "INSERT INTO integers VALUES (3, 4), (5, 6), (7, 8);";
        command.ExecuteNonQuery();

        // Retrieve the count of rows in the 'integers' table
        command.CommandText = "SELECT count(*) FROM integers";
        var executeScalar = command.ExecuteScalar();

        // Select all values from the 'integers' table
        command.CommandText = "SELECT foo, bar FROM integers;";

        // Execute the query and process the results
        using var reader = command.ExecuteReader();
        while (reader.Read())
        {
            Console.WriteLine($"{reader.GetInt32(0)}, {reader.GetInt32(1)}");
        }
    }
}

using System;
using DuckDB.NET.Data;

class Program
{
    static void Main()
    {
        // Create and open a connection to an in-memory DuckDB database
        using var duckdbconnection = new DuckDBConnection("Data Source=:memory:");
        duckdbconnection.Open();
        
        // Create a command associated with the connection
        using var command = duckdbconnection.CreateCommand();
        // Create a table named 'integers'
        command.CommandText = "CREATE TABLE integers(foo INTEGER, bar INTEGER);";
        command.ExecuteNonQuery();

        // Insert some data into the 'integers' table
        command.CommandText = "INSERT INTO integers VALUES (3, 4), (5, 6), (7, 8);";
        command.ExecuteNonQuery();

        // Retrieve the count of rows in the 'integers' table
        command.CommandText = "SELECT count(*) FROM integers";
        var executeScalar = command.ExecuteScalar();

        // Select all values from the 'integers' table
        command.CommandText = "SELECT foo, bar FROM integers;";

        // Execute the query and process the results
        using var reader = command.ExecuteReader();
        while (reader.Read())
        {
            Console.WriteLine($"{reader.GetInt32(0)}, {reader.GetInt32(1)}");
        }
    }
}

Imports System
Imports DuckDB.NET.Data

Module Program
    Sub Main()
        ' Create and open a connection to an in-memory DuckDB database
        Using duckdbconnection As New DuckDBConnection("Data Source=:memory:")
            duckdbconnection.Open()

            ' Create a command associated with the connection
            Using command = duckdbconnection.CreateCommand()
                ' Create a table named 'integers'
                command.CommandText = "CREATE TABLE integers(foo INTEGER, bar INTEGER);"
                command.ExecuteNonQuery()

                ' Insert some data into the 'integers' table
                command.CommandText = "INSERT INTO integers VALUES (3, 4), (5, 6), (7, 8);"
                command.ExecuteNonQuery()

                ' Retrieve the count of rows in the 'integers' table
                command.CommandText = "SELECT count(*) FROM integers"
                Dim executeScalar = command.ExecuteScalar()

                ' Select all values from the 'integers' table
                command.CommandText = "SELECT foo, bar FROM integers;"

                ' Execute the query and process the results
                Using reader = command.ExecuteReader()
                    While reader.Read()
                        Console.WriteLine($"{reader.GetInt32(0)}, {reader.GetInt32(1)}")
                    End While
                End Using
            End Using
        End Using
    End Sub
End Module

Imports System
Imports DuckDB.NET.Data

Module Program
    Sub Main()
        ' Create and open a connection to an in-memory DuckDB database
        Using duckdbconnection As New DuckDBConnection("Data Source=:memory:")
            duckdbconnection.Open()

            ' Create a command associated with the connection
            Using command = duckdbconnection.CreateCommand()
                ' Create a table named 'integers'
                command.CommandText = "CREATE TABLE integers(foo INTEGER, bar INTEGER);"
                command.ExecuteNonQuery()

                ' Insert some data into the 'integers' table
                command.CommandText = "INSERT INTO integers VALUES (3, 4), (5, 6), (7, 8);"
                command.ExecuteNonQuery()

                ' Retrieve the count of rows in the 'integers' table
                command.CommandText = "SELECT count(*) FROM integers"
                Dim executeScalar = command.ExecuteScalar()

                ' Select all values from the 'integers' table
                command.CommandText = "SELECT foo, bar FROM integers;"

                ' Execute the query and process the results
                Using reader = command.ExecuteReader()
                    While reader.Read()
                        Console.WriteLine($"{reader.GetInt32(0)}, {reader.GetInt32(1)}")
                    End While
                End Using
            End Using
        End Using
    End Sub
End Module

This example demonstrates how to create a table, insert data, and query the data using DuckDB.NET.

Output

DuckDB C# (How It Works For Developers): Figure 1 - DuckDB.NET Console Output

Data Ingestion

DuckDB.NET supports reading data from various formats, including CSV and Parquet files. Here's how you can read data from a CSV file:

command.CommandText = "COPY integers FROM 'example.csv' (FORMAT CSV);";
command.ExecuteNonQuery();

command.CommandText = "COPY integers FROM 'example.csv' (FORMAT CSV);";
command.ExecuteNonQuery();

command.CommandText = "COPY integers FROM 'example.csv' (FORMAT CSV)"
command.ExecuteNonQuery()

command.CommandText = "COPY integers FROM 'example.csv' (FORMAT CSV)"
command.ExecuteNonQuery()

Integration with DataFrames

DuckDB.NET can also integrate with data frames, allowing you to manipulate data using familiar SQL syntax. This is particularly useful for data analysis tasks.

Result Conversion

You can convert query results to various formats, such as lists or custom objects, making it easy to work with the data in your application:

var results = new List<(int foo, int bar)>();

// Read and store results to a List
while (reader.Read())
{
    results.Add((reader.GetInt32(0), reader.GetInt32(1))); 
    // You can also use a loop with an index to iterate the results
}

var results = new List<(int foo, int bar)>();

// Read and store results to a List
while (reader.Read())
{
    results.Add((reader.GetInt32(0), reader.GetInt32(1))); 
    // You can also use a loop with an index to iterate the results
}

Dim results = New List(Of (foo As Integer, bar As Integer))()

' Read and store results to a List
Do While reader.Read()
	results.Add((reader.GetInt32(0), reader.GetInt32(1)))
	' You can also use a loop with an index to iterate the results
Loop

Dim results = New List(Of (foo As Integer, bar As Integer))()

' Read and store results to a List
Do While reader.Read()
	results.Add((reader.GetInt32(0), reader.GetInt32(1)))
	' You can also use a loop with an index to iterate the results
Loop

Writing Data to Disk

DuckDB.NET supports writing data to disk in various formats. You can use the COPY statement to export data to a CSV file:

command.CommandText = "COPY integers TO 'output.csv' (FORMAT CSV);";
command.ExecuteNonQuery();

command.CommandText = "COPY integers TO 'output.csv' (FORMAT CSV);";
command.ExecuteNonQuery();

command.CommandText = "COPY integers TO 'output.csv' (FORMAT CSV)"
command.ExecuteNonQuery()

command.CommandText = "COPY integers TO 'output.csv' (FORMAT CSV)"
command.ExecuteNonQuery()

Introduction to IronPDF

DuckDB C# (How It Works For Developers): Figure 2 - IronPDF

IronPDF is a C# PDF library that allows the generation, management, and extraction of content from PDF documents in .NET projects. Here are some key features:

IronPDF is a handy tool that lets you turn webpages, URLs, and HTML to PDF. The best part? The PDFs look exactly like the original web pages - keeping all the formatting and style. So, if you need to make a PDF from something online, like a report or an invoice, IronPDF is your go-to.

using IronPdf;

class Program
{
    static void Main(string[] args)
    {
        var renderer = new ChromePdfRenderer();

        // 1. Convert HTML String to PDF
        var htmlContent = "<h1>Hello, IronPDF!</h1><p>This is a PDF from an HTML string.</p>";
        var pdfFromHtmlString = renderer.RenderHtmlAsPdf(htmlContent);
        pdfFromHtmlString.SaveAs("HTMLStringToPDF.pdf");

        // 2. Convert HTML File to PDF
        var htmlFilePath = "path_to_your_html_file.html"; // Specify the path to your HTML file
        var pdfFromHtmlFile = renderer.RenderHtmlFileAsPdf(htmlFilePath);
        pdfFromHtmlFile.SaveAs("HTMLFileToPDF.pdf");

        // 3. Convert URL to PDF
        var url = "http://ironpdf.com"; // Specify the URL
        var pdfFromUrl = renderer.RenderUrlAsPdf(url);
        pdfFromUrl.SaveAs("URLToPDF.pdf");
    }
}

using IronPdf;

class Program
{
    static void Main(string[] args)
    {
        var renderer = new ChromePdfRenderer();

        // 1. Convert HTML String to PDF
        var htmlContent = "<h1>Hello, IronPDF!</h1><p>This is a PDF from an HTML string.</p>";
        var pdfFromHtmlString = renderer.RenderHtmlAsPdf(htmlContent);
        pdfFromHtmlString.SaveAs("HTMLStringToPDF.pdf");

        // 2. Convert HTML File to PDF
        var htmlFilePath = "path_to_your_html_file.html"; // Specify the path to your HTML file
        var pdfFromHtmlFile = renderer.RenderHtmlFileAsPdf(htmlFilePath);
        pdfFromHtmlFile.SaveAs("HTMLFileToPDF.pdf");

        // 3. Convert URL to PDF
        var url = "http://ironpdf.com"; // Specify the URL
        var pdfFromUrl = renderer.RenderUrlAsPdf(url);
        pdfFromUrl.SaveAs("URLToPDF.pdf");
    }
}

Imports IronPdf

Friend Class Program
	Shared Sub Main(ByVal args() As String)
		Dim renderer = New ChromePdfRenderer()

		' 1. Convert HTML String to PDF
		Dim htmlContent = "<h1>Hello, IronPDF!</h1><p>This is a PDF from an HTML string.</p>"
		Dim pdfFromHtmlString = renderer.RenderHtmlAsPdf(htmlContent)
		pdfFromHtmlString.SaveAs("HTMLStringToPDF.pdf")

		' 2. Convert HTML File to PDF
		Dim htmlFilePath = "path_to_your_html_file.html" ' Specify the path to your HTML file
		Dim pdfFromHtmlFile = renderer.RenderHtmlFileAsPdf(htmlFilePath)
		pdfFromHtmlFile.SaveAs("HTMLFileToPDF.pdf")

		' 3. Convert URL to PDF
		Dim url = "http://ironpdf.com" ' Specify the URL
		Dim pdfFromUrl = renderer.RenderUrlAsPdf(url)
		pdfFromUrl.SaveAs("URLToPDF.pdf")
	End Sub
End Class

Imports IronPdf

Friend Class Program
	Shared Sub Main(ByVal args() As String)
		Dim renderer = New ChromePdfRenderer()

		' 1. Convert HTML String to PDF
		Dim htmlContent = "<h1>Hello, IronPDF!</h1><p>This is a PDF from an HTML string.</p>"
		Dim pdfFromHtmlString = renderer.RenderHtmlAsPdf(htmlContent)
		pdfFromHtmlString.SaveAs("HTMLStringToPDF.pdf")

		' 2. Convert HTML File to PDF
		Dim htmlFilePath = "path_to_your_html_file.html" ' Specify the path to your HTML file
		Dim pdfFromHtmlFile = renderer.RenderHtmlFileAsPdf(htmlFilePath)
		pdfFromHtmlFile.SaveAs("HTMLFileToPDF.pdf")

		' 3. Convert URL to PDF
		Dim url = "http://ironpdf.com" ' Specify the URL
		Dim pdfFromUrl = renderer.RenderUrlAsPdf(url)
		pdfFromUrl.SaveAs("URLToPDF.pdf")
	End Sub
End Class

HTML to PDF Conversion:
- Convert HTML, CSS, and JavaScript content to PDFs.
- Chrome Rendering Engine for pixel-perfect PDF documents.
- Generate PDFs from URLs, HTML files, or HTML strings.
Image and Content Conversion:
- Convert images to and from PDF docs.
- Extract text and images from existing PDF docs.
- Support for various image formats like JPG, PNG, etc.
Editing and Manipulation:
- Set properties, security, and permissions for PDF docs.
- Add digital signatures to PDFs.
- Edit metadata and revision history.
Cross-Platform Support:
- Works with .NET Core (8, 7, 6, 5, and 3.1+), .NET Standard (2.0+), and .NET Framework (4.6.2+).
- Compatible with Windows, Linux, and macOS.
- Available on NuGet for easy installation.

Generate PDF documents Using IronPDF and DuckDB .NET

To start with, create a Console application using Visual Studio as below.

DuckDB C# (How It Works For Developers): Figure 3 - Console App

Provide the Project name.

DuckDB C# (How It Works For Developers): Figure 4 - Project Configuration

Provide .NET Version.

DuckDB C# (How It Works For Developers): Figure 5 - Target Framework

Install the IronPDF package.

DuckDB C# (How It Works For Developers): Figure 6 - IronPDF

Install the DuckDB.NET package.

DuckDB C# (How It Works For Developers): Figure 7 - DuckDB.NET

using DuckDB.NET.Data;
using IronPdf;

namespace CodeSample
{
    public static class DuckDbDemo
    {
        public static void Execute()
        {
            // Instantiate Renderer
            var renderer = new ChromePdfRenderer();
            var content = "<h1>Demo DuckDb and IronPDF</h1>";
            content += "<h2>Create DuckDBConnection</h2>";
            content += "<p>new DuckDBConnection(\"Data Source=:memory:\");</p>";
            content += "<p></p>";

            // Create and open a connection to an in-memory DuckDB database
            using var connection = new DuckDBConnection("Data Source=:memory:");
            connection.Open();
            using var command = connection.CreateCommand();
            
            // Create a table named 'integers'
            command.CommandText = "CREATE TABLE integers(book STRING, cost INTEGER);";
            command.ExecuteNonQuery();
            content += "<p>CREATE TABLE integers(book STRING, cost INTEGER);</p>";

            // Insert some data into the 'integers' table
            command.CommandText = "INSERT INTO integers VALUES ('book1', 25), ('book2', 30), ('book3', 10);";
            command.ExecuteNonQuery();
            content += "<p>INSERT INTO integers VALUES ('book1', 25), ('book2', 30), ('book3', 10);</p>";

            // Select all values from the 'integers' table
            command.CommandText = "SELECT book, cost FROM integers;";
            using var reader = command.ExecuteReader();
            content += "<p>SELECT book, cost FROM integers;</p>";

            // Execute the query and process the results, appending them to the HTML content
            while (reader.Read())
            {
                content += $"<p>{reader.GetString(0)}, {reader.GetInt32(1)}</p>";
                Console.WriteLine($"{reader.GetString(0)}, {reader.GetInt32(1)}");
            }

            // Save data to CSV
            content += "<p>Save data to CSV with COPY integers TO 'output.csv' (FORMAT CSV);</p>";
            command.CommandText = "COPY integers TO 'output.csv' (FORMAT CSV);";
            command.ExecuteNonQuery();

            // Generate and save PDF
            var pdf = renderer.RenderHtmlAsPdf(content);
            pdf.SaveAs("AwesomeDuckDbNet.pdf");
        }
    }
}

using DuckDB.NET.Data;
using IronPdf;

namespace CodeSample
{
    public static class DuckDbDemo
    {
        public static void Execute()
        {
            // Instantiate Renderer
            var renderer = new ChromePdfRenderer();
            var content = "<h1>Demo DuckDb and IronPDF</h1>";
            content += "<h2>Create DuckDBConnection</h2>";
            content += "<p>new DuckDBConnection(\"Data Source=:memory:\");</p>";
            content += "<p></p>";

            // Create and open a connection to an in-memory DuckDB database
            using var connection = new DuckDBConnection("Data Source=:memory:");
            connection.Open();
            using var command = connection.CreateCommand();
            
            // Create a table named 'integers'
            command.CommandText = "CREATE TABLE integers(book STRING, cost INTEGER);";
            command.ExecuteNonQuery();
            content += "<p>CREATE TABLE integers(book STRING, cost INTEGER);</p>";

            // Insert some data into the 'integers' table
            command.CommandText = "INSERT INTO integers VALUES ('book1', 25), ('book2', 30), ('book3', 10);";
            command.ExecuteNonQuery();
            content += "<p>INSERT INTO integers VALUES ('book1', 25), ('book2', 30), ('book3', 10);</p>";

            // Select all values from the 'integers' table
            command.CommandText = "SELECT book, cost FROM integers;";
            using var reader = command.ExecuteReader();
            content += "<p>SELECT book, cost FROM integers;</p>";

            // Execute the query and process the results, appending them to the HTML content
            while (reader.Read())
            {
                content += $"<p>{reader.GetString(0)}, {reader.GetInt32(1)}</p>";
                Console.WriteLine($"{reader.GetString(0)}, {reader.GetInt32(1)}");
            }

            // Save data to CSV
            content += "<p>Save data to CSV with COPY integers TO 'output.csv' (FORMAT CSV);</p>";
            command.CommandText = "COPY integers TO 'output.csv' (FORMAT CSV);";
            command.ExecuteNonQuery();

            // Generate and save PDF
            var pdf = renderer.RenderHtmlAsPdf(content);
            pdf.SaveAs("AwesomeDuckDbNet.pdf");
        }
    }
}

Imports DuckDB.NET.Data
Imports IronPdf

Namespace CodeSample
    Public Module DuckDbDemo
        Public Sub Execute()
            ' Instantiate Renderer
            Dim renderer = New ChromePdfRenderer()
            Dim content = "<h1>Demo DuckDb and IronPDF</h1>"
            content += "<h2>Create DuckDBConnection</h2>"
            content += "<p>new DuckDBConnection(""Data Source=:memory:"");</p>"
            content += "<p></p>"

            ' Create and open a connection to an in-memory DuckDB database
            Using connection = New DuckDBConnection("Data Source=:memory:")
                connection.Open()
                Using command = connection.CreateCommand()

                    ' Create a table named 'integers'
                    command.CommandText = "CREATE TABLE integers(book STRING, cost INTEGER);"
                    command.ExecuteNonQuery()
                    content += "<p>CREATE TABLE integers(book STRING, cost INTEGER);</p>"

                    ' Insert some data into the 'integers' table
                    command.CommandText = "INSERT INTO integers VALUES ('book1', 25), ('book2', 30), ('book3', 10);"
                    command.ExecuteNonQuery()
                    content += "<p>INSERT INTO integers VALUES ('book1', 25), ('book2', 30), ('book3', 10);</p>"

                    ' Select all values from the 'integers' table
                    command.CommandText = "SELECT book, cost FROM integers;"
                    Using reader = command.ExecuteReader()
                        content += "<p>SELECT book, cost FROM integers;</p>"

                        ' Execute the query and process the results, appending them to the HTML content
                        While reader.Read()
                            content += $"<p>{reader.GetString(0)}, {reader.GetInt32(1)}</p>"
                            Console.WriteLine($"{reader.GetString(0)}, {reader.GetInt32(1)}")
                        End While
                    End Using

                    ' Save data to CSV
                    content += "<p>Save data to CSV with COPY integers TO 'output.csv' (FORMAT CSV);</p>"
                    command.CommandText = "COPY integers TO 'output.csv' (FORMAT CSV);"
                    command.ExecuteNonQuery()
                End Using
            End Using

            ' Generate and save PDF
            Dim pdf = renderer.RenderHtmlAsPdf(content)
            pdf.SaveAs("AwesomeDuckDbNet.pdf")
        End Sub
    End Module
End Namespace

Imports DuckDB.NET.Data
Imports IronPdf

Namespace CodeSample
    Public Module DuckDbDemo
        Public Sub Execute()
            ' Instantiate Renderer
            Dim renderer = New ChromePdfRenderer()
            Dim content = "<h1>Demo DuckDb and IronPDF</h1>"
            content += "<h2>Create DuckDBConnection</h2>"
            content += "<p>new DuckDBConnection(""Data Source=:memory:"");</p>"
            content += "<p></p>"

            ' Create and open a connection to an in-memory DuckDB database
            Using connection = New DuckDBConnection("Data Source=:memory:")
                connection.Open()
                Using command = connection.CreateCommand()

                    ' Create a table named 'integers'
                    command.CommandText = "CREATE TABLE integers(book STRING, cost INTEGER);"
                    command.ExecuteNonQuery()
                    content += "<p>CREATE TABLE integers(book STRING, cost INTEGER);</p>"

                    ' Insert some data into the 'integers' table
                    command.CommandText = "INSERT INTO integers VALUES ('book1', 25), ('book2', 30), ('book3', 10);"
                    command.ExecuteNonQuery()
                    content += "<p>INSERT INTO integers VALUES ('book1', 25), ('book2', 30), ('book3', 10);</p>"

                    ' Select all values from the 'integers' table
                    command.CommandText = "SELECT book, cost FROM integers;"
                    Using reader = command.ExecuteReader()
                        content += "<p>SELECT book, cost FROM integers;</p>"

                        ' Execute the query and process the results, appending them to the HTML content
                        While reader.Read()
                            content += $"<p>{reader.GetString(0)}, {reader.GetInt32(1)}</p>"
                            Console.WriteLine($"{reader.GetString(0)}, {reader.GetInt32(1)}")
                        End While
                    End Using

                    ' Save data to CSV
                    content += "<p>Save data to CSV with COPY integers TO 'output.csv' (FORMAT CSV);</p>"
                    command.CommandText = "COPY integers TO 'output.csv' (FORMAT CSV);"
                    command.ExecuteNonQuery()
                End Using
            End Using

            ' Generate and save PDF
            Dim pdf = renderer.RenderHtmlAsPdf(content)
            pdf.SaveAs("AwesomeDuckDbNet.pdf")
        End Sub
    End Module
End Namespace

Code Explanation

The code aims to showcase how to use DuckDB.NET for database operations and IronPDF for generating a PDF report containing the database query results.

Key Components

DuckDB.NET:
- DuckDBConnection: Establishes a connection to an in-memory DuckDB database file ("Data Source=:memory:"). This connection is used throughout the code to execute SQL commands.
Database Operations:
- Table Creation: Defines a SQL command (CREATE TABLE integers(book STRING, cost INTEGER);) to create a table named integers with columns book (STRING) and cost (INTEGER).
- Data Insertion: Inserts rows into the integers table (INSERT INTO integers VALUES ('book1', 25), ('book2', 30), ('book3', 10);).
- Data Retrieval: Executes a SELECT query (SELECT book, cost FROM integers;) to fetch data from the integers table. The retrieved data is formatted into HTML (content) and printed to the console.
PDF Generation with IronPDF:
- Rendering HTML to PDF: Uses ChromePdfRenderer from IronPDF to convert the HTML content (content) into a PDF document (pdf).
- Saving PDF: Saves the generated PDF as "AwesomeDuckDbNet.pdf" in the current directory.

Output

DuckDB C# (How It Works For Developers): Figure 8 - Console Output

PDF

DuckDB C# (How It Works For Developers): Figure 9 - PDF Output

IronPDF Licensing

The IronPDF package requires a license to run. Add the below code at the start of the application before the package is accessed.

IronPdf.License.LicenseKey = "IRONPDF-KEY";

IronPdf.License.LicenseKey = "IRONPDF-KEY";

Imports IronPdf

IronPdf.License.LicenseKey = "IRONPDF-KEY"

Imports IronPdf

IronPdf.License.LicenseKey = "IRONPDF-KEY"

A trial license is available on IronPDF's trial license page.

Conclusion

The DuckDB.NET C# package is a powerful tool for integrating DuckDB's analytical capabilities into .NET applications. Its ease of use, support for various data formats, and seamless integration with C# make it an excellent choice for developers working on data-intensive applications. Whether you are building data analysis tools, ETL pipelines, or other data-driven applications, DuckDB.NET can help you achieve your goals efficiently.

Jacob Mellor

Chat with engineering team now

Chief Technology Officer

Jacob Mellor is Chief Technology Officer at Iron Software and a visionary engineer pioneering C# PDF technology. As the original developer behind Iron Software's core codebase, he has shaped the company's product architecture since its inception, transforming it alongside CEO Cameron Rimington into a 50+ person company serving NASA, Tesla, and global government agencies.

...