This library that contains an extension of DbDataReader that automatically maps a database row to a model.
Get Started
$ dotnet add package DbDataReaderMapperReadme
DbDataReaderMapper
This is a .NET library that contains an extension of DbDataReader that automatically maps a row to a model.
Works with all major DB connections, tested on MySQL, SQL Server, Azure SQL and OLEDB (Access).
Usage
Imagine a database with the following code
CREATE TABLE Employee (
Id INT NOT NULL PRIMARY KEY,
FirstName VARCHAR(128) NOT NULL,
LastName VARCHAR(128) NOT NULL,
Age INT NULL
)
We create a model for the object we want to map
class EmployeeDao
{
public int Id { get; set; }
public string FirstName { get; set; }
public string LastName { get; set; }
public int? Age { get; set; }
}
In our database interface, we import the namespace
using DbDataReaderMapper;
And when we query the database we can use the extension method MapToObject as follows (this example uses the OLEDB connector for simplicity, but it works with others too)
OleDbCommand cmd = connection.CreateCommand();
cmd.CommandText = "SELECT * FROM Employee;";
cmd.Connection = connection;
var reader = await cmd.ExecuteReaderAsync();
while (await reader.ReadAsync())
{
var employeeObj = reader.MapToObject<EmployeeDao>();
}
Additional features
Custom property to column mapping
You can map a property of your model to a column with a different name by using the DbColumn attribute.
For example, if your database instance uses snake case for column naming, you can do the following:
class EmployeeDao
{
[DbColumn("id")]
public int Id { get; set; }
[DbColumn("first_name")]
public string FirstName { get; set; }
[DbColumn("last_name")]
public string LastName { get; set; }
[DbColumn("age")]
public int? Age { get; set; }
}