LINQ, Using Include Function

Question

I am using EF 6 in Visual Studio 2013. I want to get matching records from a Parent table on behalf of foreign key from Child table. I have following line of code

var record = db.ChannelFees.Include(x =>x.SubSource).ToList();

Here ChannelFees is the child table in which SubSourceId is foreign key from SubSource(Parent Table).

Channel Fee Class Looks Like:

    using System;
    using System.Collections.Generic;

    public partial class ChannelFee
{
    public virtual SubSource SubSource { get; set; }
    public int SubSource_id { get; set; }
    public double Fee { get; set; }
    public int Id { get; set; }
}

and the SubSource Class

using System;
    using System.Collections.Generic;

    public partial class SubSource
    {
        public int Id { get; set; }
        public string Description { get; set; }
        public string MapName { get; set; }
    }

But I am getting the following exception.

A specified Include path is not valid. The EntityType 'FinancialManagmentModel.ChannelFee' does not declare a navigation property with the name 'SubSource'.

What is wrong with it?

Could you send ChannelFee and SubSource classes please? Also the mapping configuration if you are using fluent interface mapping. — bubi
– bubi, Commented Dec 9, 2015 at 7:10
I have updated the question with ChannelFee and SubSource classes @bubi — Ikram Khan
– Ikram Khan, Commented Dec 9, 2015 at 7:18
I am new to Entity Framework so I actually don't know what else has to be done to get this — Ikram Khan
– Ikram Khan, Commented Dec 9, 2015 at 7:19
Your question states that you do have two partial classes called SubSource! is that typo? — Jenish Rabadiya
– Jenish Rabadiya, Commented Dec 9, 2015 at 7:20

Dave Greilach · Accepted Answer · 2015-12-09 06:23:49Z

2

I think it should be:

public virtual ICollection<SubSource> SubSource;

answered Dec 9, 2015 at 6:23

Dave Greilach

8955 silver badges9 bronze badges

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

1 Comment

Ikram Khan Over a year ago

'The modifier 'virtual' is not valid for this item' Following error is occuring on placing virtual keyword

bubi · Accepted Answer · 2015-12-09 07:30:35Z

2

You could try with this:

public partial class ChannelFee
{
    public virtual ICollection<SubSource> SubSource { get; set; } // Just to enable lazy load
    public int Id { get; set; }
    public string Description { get; set; }
    public string MapName { get; set; }
}

public partial class SubSource
{
    public int Id { get; set; }
    public string Description { get; set; }
    public string MapName { get; set; }
    public virtual ChannelFee ChannelFee {get; set; } // Navigation property
}

And usually I also add a Mapping in the context (you can achieve the same result with configuration attributes)

protected override void OnModelCreating(DbModelBuilder modelBuilder)
{
    modelBuilder.Entity<SubSource>().HasRequired(t => t.ChannelFee)
            .WithMany(t => t.SubSource);
}

answered Dec 9, 2015 at 7:30

bubi

6,5013 gold badges32 silver badges50 bronze badges

1 Comment

Ikram Khan Over a year ago

Where to put the last method (OnModelCreating())?

Raj Kamal · Accepted Answer · 2015-12-09 11:37:07Z

1

Simplest way to solve the problem is to declare a navigation property with the name 'SubSource'. through Annotations

public partial class ChannelFee
{
        [ForeignKey("SubSource_id")]  
        public virtual SubSource SubSource { get; set; }        
        public int SubSource_id { get; set; }     

}

edited Dec 9, 2015 at 11:37

answered Dec 9, 2015 at 11:05

Raj Kamal

5776 silver badges15 bronze badges

Comments

Ikram Khan · Accepted Answer · 2015-12-09 14:50:09Z

0

I have resolved the issue at my own. Actually the EF was not generating navigation property in the Model on the behalf of Foreign Key Constraint which I created in SQL, that is why error was occuring. So I simply deleted the Model and added it again. Problem was solved.

answered Dec 9, 2015 at 14:50

Ikram Khan

891 silver badge9 bronze badges

Collectives™ on Stack Overflow

LINQ, Using Include Function

4 Answers 4

1 Comment

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

1 Comment

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related