How to map return of a Value Object with Dapper?

Question

How to map return of a Value Object with Dapper?

Navigation

#1 by (1 votes)

0

Hello!

I have a question regarding the return of an object with an already-filled 'Value Object', for example:

I have the User.cs class

public class User
{
    public Guid UserId { get; set; }
    public string Name { get; set; }
    public string Password { get; set; }
    public Email Email { get; set; }
}

Email.cs class

public class Email
{
    public string Address { get; set; }
}

In any search I do with Dapper the return of Email always comes null. Is there any way to map the Dapper return?

Obs. The data is persisted into a single table, there is no relationship.

c# dapper

asked by anonymous 11.04.2018 / 18:00

1 answer

Return the lowest value - Python problem of event blur with submit button

score 1 · Accepted Answer

It's simple

Edit , I did without the relationship the way you said it:

List<User> ret;
using (var db = new SqlConnection(connstring))
{
    var sql =
        "select UserId, Name, Password, Email as Address from [User]";

    ret = db.Query<User, Email, User>(sql, (user, email) =>
    {
        user.Email = email;
        return user;
    }, splitOn: "Address").ToList();
}

CheckthequeryifitmeetsthecolumnsofyourDB,inmyarticleitexplainsindetail!

InmyGithubyouhavemoreabout: link

I also have an article about: link