LINQ, Use Lambda Expression in Include Function

Question

My question looks simple to me but not getting it fixed. I am using EF 6 and LINQ to SQL in Visual Studio 2013. I want to fetch a record from second table on behalf of foreign key being used in first table. I wanted to use 'Include' function but 'Include' function neither show table names in IntelliSense nor accepts in a lambda expression like this:

var record= db.tblChild.Include(x=>x.tblParent)

My original code shows the libraries added.

You're missing a semicolon after the problematic line. What is the error? Hover over the lambda expression and tell us what the tooltip says. — zmbq
– zmbq, Commented Dec 8, 2015 at 19:48
using System.Data.Entity; is what you need to be able to reference the lamda version of .Include, so that should work. We need to see what the error it is giving you after you add the semi-colon. — Robert McKee
– Robert McKee, Commented Dec 8, 2015 at 19:51
My error is fixed. Actually I wasn't generating SubSource Property in ShipmentCharges Class. Generating that fixed the Issue. :) — Ikram Khan
– Ikram Khan, Commented Dec 8, 2015 at 19:52

Mihai Caracostea · Accepted Answer · 2015-12-08 19:53:17Z

5

In order to use lambdas in Include you have to import the System.Data.Entity namespace (which you have) and also reference EntityFramework.dll which includes the necessary extension methods.

answered Dec 8, 2015 at 19:53

Mihai Caracostea

8,4944 gold badges30 silver badges46 bronze badges

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

2 Comments

Ikram Khan Over a year ago

My error is fixed. Actually I wasn't generating SubSource Property in ShipmentCharges Class. Generating that fixed the Issue. :)

Mihai Caracostea Over a year ago

@IkramKhan Well, posting the error would have put us on the right path way faster. Either way, good to hear you've solved it.

Frank Pena · Accepted Answer · 2017-07-25 00:45:26Z

-1

You only need to add:

using System.Data.Entity;

Into your Namespace.

answered Jul 25, 2017 at 0:45

Frank Pena

1112 silver badges9 bronze badges

Collectives™ on Stack Overflow

LINQ, Use Lambda Expression in Include Function

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related