Entity Framework Database First Configuration

Question

I have the following tables in my database

Notes Table:

NoteID
Description
TaskID (Can be NULL)

Task Table:

TaskID
TaskType
TaskDescription

I an using Entity Framework 5.0 Database First approach.

In some cases there will be notes which linked to a single task but there will be cases that note are standalone that means that they not linked to single task.

My question is how do i need to configure the edmx (model) file so when i am asking for a single task he will give me the associated noted?

I think it something that i need to configure the mapping no?

Quinton Bernhardt · Accepted Answer · 2013-01-18 15:30:27Z

1

You don't have to configure anything. Just gen the model from the db and then

 var query = context.Tasks.Include("Notes");

answered Jan 18, 2013 at 15:30

Quinton Bernhardt

4,81321 silver badges29 bronze badges

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

2 Comments

Silagy Over a year ago

I use it when I am creating new query? For example GetAllTasks()?

Quinton Bernhardt Over a year ago

Yes, get all tasks and any notes associated

NinjaNye · Accepted Answer · 2013-01-18 16:06:52Z

1

If you are doing code first then this will do it automatically. Simply make the TaskId nullable:

public class Note
{
    public int NoteID {get; set;}
    public string Description {get; set;}
    public int? TaskId {get; set;} // Notice the int is nullable

    public virtual Task {get; set;}
}

public class Task
{
    public int TaskID {get; set;}
    public TaskTypeEnum TaskType {get; set;}
    public string Description {get; set;}

    public virtual ICollection<Note> Notes {get; set;}
}

edited Jan 18, 2013 at 16:06

answered Jan 18, 2013 at 15:41

NinjaNye

7,1361 gold badge34 silver badges47 bronze badges

1 Comment

Silagy Over a year ago

Thanks for your answer, Doesn't the Task class needs to have List of Notes?

Collectives™ on Stack Overflow

Entity Framework Database First Configuration

2 Answers 2

2 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related