AutoDataTable 1.1.1

dotnet add package AutoDataTable --version 1.1.1                
NuGet\Install-Package AutoDataTable -Version 1.1.1                
This command is intended to be used within the Package Manager Console in Visual Studio, as it uses the NuGet module's version of Install-Package.
<PackageReference Include="AutoDataTable" Version="1.1.1" />                
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add AutoDataTable --version 1.1.1                
#r "nuget: AutoDataTable, 1.1.1"                
#r directive can be used in F# Interactive and Polyglot Notebooks. Copy this into the interactive tool or source code of the script to reference the package.
// Install AutoDataTable as a Cake Addin
#addin nuget:?package=AutoDataTable&version=1.1.1

// Install AutoDataTable as a Cake Tool
#tool nuget:?package=AutoDataTable&version=1.1.1                

AutoDataTable

Nuget

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 or structs targeted for conversion should have the DataTable attribute:

using AutoDataTable.Core;

namespace MyProject;

[DataTable]
public 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 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 class Customer
{
    [DataColumn("phone_number")]
    public string PhoneNumber { get; set; }
}

To create a DataTable you need to first declare a factory method with the static and partial modifiers and no body. Then you should annotate the factory method with the GenerateDataTable attribute and provide as a parameter the type you wish to convert:

public partial class CustomerService
{
    [GenerateDataTable(typeof(Customer))]
    private static partial DataTableFactory CustomerFactory();
    
    public DataTable CreateCustomerTable()
    {
        return CustomerFactory().Create();
    }
}

NOTE

The factory method implementation returns a singleton, so you don't need to cache it.


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.

Changelog

1.1.1 (2023-10-30)

  • Fixed namespaces for generated parameters

1.1.0 (2023-10-30)

  • Added support for structs
  • Factory method can now be placed anywhere
  • Moved attributes to the AutoDataTable.Core namespace

1.0.0 (2023-07-30)

First release

Product Compatible and additional computed target framework versions.
.NET net5.0 was computed.  net5.0-windows was computed.  net6.0 was computed.  net6.0-android was computed.  net6.0-ios was computed.  net6.0-maccatalyst was computed.  net6.0-macos was computed.  net6.0-tvos was computed.  net6.0-windows was computed.  net7.0 was computed.  net7.0-android was computed.  net7.0-ios was computed.  net7.0-maccatalyst was computed.  net7.0-macos was computed.  net7.0-tvos was computed.  net7.0-windows was computed.  net8.0 was computed.  net8.0-android was computed.  net8.0-browser was computed.  net8.0-ios was computed.  net8.0-maccatalyst was computed.  net8.0-macos was computed.  net8.0-tvos was computed.  net8.0-windows was computed. 
.NET Core netcoreapp2.0 was computed.  netcoreapp2.1 was computed.  netcoreapp2.2 was computed.  netcoreapp3.0 was computed.  netcoreapp3.1 was computed. 
.NET Standard netstandard2.0 is compatible.  netstandard2.1 was computed. 
.NET Framework net461 was computed.  net462 was computed.  net463 was computed.  net47 was computed.  net471 was computed.  net472 was computed.  net48 was computed.  net481 was computed. 
MonoAndroid monoandroid was computed. 
MonoMac monomac was computed. 
MonoTouch monotouch was computed. 
Tizen tizen40 was computed.  tizen60 was computed. 
Xamarin.iOS xamarinios was computed. 
Xamarin.Mac xamarinmac was computed. 
Xamarin.TVOS xamarintvos was computed. 
Xamarin.WatchOS xamarinwatchos was computed. 
Compatible target framework(s)
Included target framework(s) (in package)
Learn more about Target Frameworks and .NET Standard.
  • .NETStandard 2.0

    • No dependencies.

NuGet packages

This package is not used by any NuGet packages.

GitHub repositories

This package is not used by any popular GitHub repositories.

Version Downloads Last updated
1.1.1 274 10/31/2023
1.0.0 215 7/31/2023