Answers

Conditional include in linq

mjasri

1.1k

I have the below code

//var result = (from hold in db.WcmHold

// where hold.Name.Contains(name)

// select hold).Where(x => managments.Contains(x.ManagemntId)).Include("DocumentsImage").Include("FieldsDescription").OrderByDescending(x=>x.CreatDate).Take(100).ToList();

I want to show/Include just the "DocumentsImage" that there Id>=1000

Answers (3)

From my understanding you have two tables one is WcmHold and another is managments,

On which table id based you want to retrieve the data .again what is the common key for both tables

Thanks and regards

var result = Table.Where(c=>c.Id >= 1000).Select(i=>i.DocumentsImage).ToList().

Thanks.

Hi Majsri,

Please use below links which will help you,

https://entityframework.net/include-with-where-clause

https://www.codeproject.com/Questions/898509/how-to-do-more-conditional-includes-in-linq-to-ent

Next Recommended Forum

Unable to install package from package manager console

How to write Owin Middleware for Basic Authentication for web api?