DapperMappers

An example of using Dapper with the custom Xml and Json mappers. Can be used to serialize and deserialize objects by Dapper.

Project structure

DapperMappers.Api - Sample REST API that uses serialization and deserialization to XML (uses the MS SQL Server Express database)
DapperMappers.Domain - Sample domain used by the REST API
DapperMappers.Domain.Tests - Domain tests using SQLite database
DbConnectionExtensions - DBConnection extension

How to use

Create a class that implements IXmlObjectType or IJsonObjectType interface
```csharp
public class Book
{
public long Id { get; set; }
public string Title { get; set; }
public BookDescription Description { get; set; }
}

public class BookDescription : IXmlObjectType
{
public Learn Learn { get; set; }
public string About { get; set; }
public Features Features { get; set; }
}

public class Learn
{
public List Points { get; set; }
}

public class Features
{
public List Points { get; set; }
}

- Register these new classes in Startup.cs
```csharp
services.RegisterDapperCustomTypeHandlers(typeof(Book).Assembly);

Create a table in the database that contains a column of the XML type

CREATE TABLE [dbo].[Books](
  [Id] bigint IDENTITY(1,1) NOT NULL,
  [Title] nvarchar(200) NOT NULL,
  [Description] xml NULL
  CONSTRAINT [PK_Books] PRIMARY KEY CLUSTERED
  (
      [Id] ASC
  )
)

Use Dapper to save object data in the database

public async Task SaveBook(Book book)
{
  using (var conn = _connectionFactory.Connection())
  {
      await conn.ExecuteAsync(_@"INSERT INTO Books (Title, Description) VALUES (@Title, @Description)", book);
  }
}

How to Run test REST API

Download and install .NET 8.0 SDK
Download and install MS SQL Server Express
Create an empty database called BookDB and run CreateDapperMappersDbSQLServer.sql script

Clone or download source code

git clone https://github.com/kubagdynia/DapperMappers.git

Set a database connection string in the API project in the appsettings.json

{
"ConnectionStrings": {
  "DefaultConnection": "Data Source=(localdb)\MSSQLLocalDB;Initial Catalog=BookDB;Integrated Security=True;MultipleActiveResultSets=True;"
}  
}

If you are running from IDE set the Startup Item to the DapperMappers.API project, not IIS Express

Running the API project from the command line

dotnet run --project .\DapperMappers\DapperMappers.Api\

Open the API documentation in your browser
```
https://localhost:5001/swagger
```

How to Test

Every commit or pull request is built and tested on the Continuous Integration system.

To test locally:

Download and install .NET 8.0 SDK

Clone or download source code

git clone https://github.com/kubagdynia/DapperMappers.git

Start tests from the command line
```
dotnet test ./DapperMappers/
```

Technologies

List of technologies, frameworks and libraries used for implementation:

.NET 8.0 (platform)
MS SQL Server Express (database)
Dapper (micro ORM)
Dapper.CustomTypeHandlers (custom handlers)
Automapper (object mapper)
FluentValidation (data validation)
System.Text.Json (JSON serialization/deserialization)
Swashbuckle.AspNetCore (Swagger automated API documentation)
NUnit (testing framework)
SQLite (database for testing purpose)
FluentAssertions (fluent API for asserting the result of unit tests)

License

This project is licensed under the MIT License.