AutoDataTable 1.0.0

AutoDataTable

AutoDataTable is a .NET library that simplifies the object to row conversion when dealing with System.Data.DataTable.

It uses the Source Generators from Roslyn to generate the conversion code, instead of using reflection during runtime.

Using the generated code not only results in a faster object conversion, but also allows the app to be published as Native AOT.

Prerequisites

Since this library uses Source Generators, the app needs to target at least .NET Standard 2.0.

Installation

Use the .NET CLI to install the package and its dependencies:

dotnet add package AutoDataTable

Usage

The classes targeted for conversion should have the partial modifier and the DataTable attribute:

using AutoDataTable.Abstractions;

namespace MyProject;

[DataTable]
public partial class Customer
{
}

By default, the DataTable instance will be created using the class name as the table name, but this can be overridden using the attribute's properties:

[DataTable("Customers")]
public partial class Customer
{
}

The columns will use the property name by default. While it's not required to add the DataColumn attribute to the properties, it can be used to override the column name:

[DataTable]
public partial class Customer
{
    [DataColumn("phone_number")]
    public string PhoneNumber { get; set; }
}

The DataTable instance can be created by calling the generated CreateDataTable static method on the class:

var dataTable = Customer.CreateDataTable();

To convert an object to a row, just call the AddRow method:

var customer = new Customer();

dataTable.AddRow(customer);

Contributing

Pull requests are welcome, but please open an issue first to discuss your idea.

License

Distributed under the GPL-3.0 License. See LICENSE for more information.