DataTransfer Class

Definition

Namespace

Cuemon.Data

Assemblies

Cuemon.Data.dll

Source

src/Cuemon.Data/DataTransfer.cs

Provides a way to convert an IDataReader implementation to a table-like data transfer object.

public static class DataTransfer

Inheritance

object

DataTransfer

Examples

The following example demonstrates how to use to convert an into row-based and column-based collections.

using System;
using System.Data;
using Cuemon.Data;

namespace MyApp.Data;

public sealed class DataTransferExample
{
    public void Demonstrate()
    {
        var table = new DataTable("Products");
        table.Columns.Add("Id", typeof(int));
        table.Columns.Add("Name", typeof(string));
        table.Columns.Add("Price", typeof(decimal));
        table.Rows.Add(1, "Widget", 9.99m);
        table.Rows.Add(2, "Gadget", 24.95m);

        using IDataReader reader = table.CreateDataReader();

        // Convert reader rows to a collection
        DataTransferRowCollection rows = DataTransfer.GetRows(reader);
        Console.WriteLine($"Row count: {rows.Count}");
        Console.WriteLine($"Columns: {string.Join(", ", rows.ColumnNames)}");

        // Access data by column name
        foreach (DataTransferRow row in rows)
        {
            Console.WriteLine($"{row["Id"]}: {row["Name"]} @ {row["Price"]:C}");
        }

        // Re-read and get columns
        reader.Dispose();
        using IDataReader reader2 = table.CreateDataReader();
        reader2.Read();
        DataTransferColumnCollection columns = DataTransfer.GetColumns(reader2);
        Console.WriteLine($"Column count: {columns.Count}");
        Console.WriteLine($"First column: {columns[0].Name} ({columns[0].DataType.Name})");
    }
}

Methods

Name	Description
GetColumns(IDataReader)	Converts the specified and read-initialized reader implementation to a column-like data transfer object collection.
GetRows(IDataReader)	Converts the specified reader implementation to a table-like data transfer object collection.