How to create object hierarchy with dapper.net?

Question

I have a table defination as below:

enter code here

CREATE TABLE Milestone
( 
    MilestoneID Int,
    MilestoneName Nvarchar(256),
    ParentMilestoneID Int
)

Class defination as below:

enter code here

public class Milestone
{
    public int MilestoneID {get;set;}
    public string MilestoneName {get;set:}
    public Milestone milestone {get;set;}
}

How to mapping sql query to parent-child hierarchy objects?

Any suggestion or idea is welcome.

Leon Bambrick · Accepted Answer · 2015-06-19 01:21:13Z

3

This is not exactly a hierarchy, but is better a parent-child relationship, I suppose you can look in the example page in the section called Multi Mapping.

edited Jun 19, 2015 at 1:21

Leon Bambrick

26.4k9 gold badges53 silver badges76 bronze badges

answered Jun 19, 2012 at 16:04

Felice Pollano

33.4k10 gold badges77 silver badges125 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to create object hierarchy with dapper.net?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related