Einfaches Mapping

Question

Einfaches Mapping

c# dapper orm sql-server

Frage

Tabelle:

create table Documents 
   (Id int, 
    SomeText varchar(100), 
    CustomerId int, 
    CustomerName varchar(100)
   )

insert into Documents (Id, SomeText, CustomerId, CustomerName) 
   select 1, '1', 1, 'Name1' 
     union all
   select 2, '2', 2, 'Name2'

Klassen:

public class Document
{
    public int Id { get; set; }
    public string SomeText { get; set; }
    public Customer { get; set; }
}

public class Customer
{
    public int Id { get; set; }
    public string Name { get; set; }
}

Wie kann ich alle Documents mit ihren Customers bei Dapper bekommen? Dies gibt mir alle Dokumente, aber der Kunde ist (natürlich) null:

connection.Query<Document>("select Id, SomeText, CustomerId, CustomerName from Documents")...

EDIT - ähnliche, aber erweiterte Mapping-Frage: Dapper intermediate mapping

sventevit

Meer bekijken op Stack Overflow

AdaTheDev · Accepted Answer · 4/16/2012 8:39:00 AM

Beispiel aus der Dapper-Projektseite (siehe Abschnitt Multi-Mapping):

var sql = 
@"select * from #Posts p 
left join #Users u on u.Id = p.OwnerId 
Order by p.Id";

var data = connection.Query<Post, User, Post>(sql, (post, user) => { post.Owner = user; return post;});
var post = data.First();

post.Content.IsEqualTo("Sams Post1");
post.Id.IsEqualTo(1);
post.Owner.Name.IsEqualTo("Sam");
post.Owner.Id.IsEqualTo(99);

Marc Gravell · Accepted Answer · 4/16/2012 8:45:00 AM

Expertenantwort

var docs = connection.Query<Document, Customer, Document>(
    "select Id, SomeText, CustomerId as [Id], CustomerName as [Name] from Documents",
    (doc, cust) => { doc.Customer = cust; return doc; }).ToList();

Marc Gravell

Einfaches Mapping

Frage

Fastest Dapper Plus Extensions

Akzeptierte Antwort

Expertenantwort

Performance

Expression Evaluator