Entity framework with Include method

Question

I have issue with Include Method , scenario as given

Table Warehouse has columns

Id--> unique identifier and PK
warehouseNumber--nvarchar(50)

--some more columns

Table WarehouselnkedEcorders

Id-->PK,unique Identifier
warehouseUniqueId-->(FK,Unique Identifier), It has relationship with "Warehouse" table Id column
Status

Warehouse Model has following Code

public class Warehouse
{
    public Warehouse()
    {
        this.WarehouselnkedEcorders = new List<WarehouselnkedEcorder>();
    }
    //Some stuff

    public virtual ICollection<WarehouselnkedEcorder> WarehouselnkedEcorders 
    { get; set; }
}

WarehouselnkedEcOrdeMap has following Code

        // Relationships
        this.HasOptional(t => t.Warehouse)
            .WithMany(t => t.WarehouselnkedEcorders)
            .HasForeignKey(d => d.warehouseUniqueId);

Query

I need to retrive a list of warehouse entity with status=true. I tried the following way,but could not get result. How can I do this?

  List<Warehouse> lstObjWarehouse = objWMSContext.Warehouses.Include("WarehouselnkedEcorders").Where(//o=>SomeCondition)
                                                       .Where(o => SomeCondition)
                                                       .Where(o => o.Deleted == false).ToList();

Here I need to compare value of status=true of each row of "WarehouselnkedEcorder" and it should return result.

How many of a Warehouse's related WarehouselnkedEcorders must have a true Status to include the Warehouse in the result set? — Nick Butler
– Nick Butler, Commented Dec 19, 2012 at 13:26
have you tried "WarehouselnkedEcorders" instead of "WarehouselnkedEcorder"? — lante
– lante, Commented Dec 19, 2012 at 13:28
in your code, you didn't write the "s" in the Include statment. if so, please edit — lante
– lante, Commented Dec 19, 2012 at 14:01

Jens Bergvall · Accepted Answer · 2012-12-20 10:53:15Z

1

Use Any in query:

List<Warehouse> lstObjWarehouse = db.Warehouses.Include("WarehouselnkedEcorder")
.Where(o => o.invoicePath == "SomeCondition" 
&& o.Deleted == false 
&& o.WarehouselnkedEcorders.Any(p => p.id == o.id 
&& p.Deleted == false)).ToList();

edited Dec 20, 2012 at 10:53

Jens Bergvall

1,6272 gold badges25 silver badges56 bronze badges

answered Dec 20, 2012 at 10:30

vendan

261 bronze badge

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

1 Comment

mastan Over a year ago

It works by changing navigation property name to "WarehouselnkedEcorders"

phil soady · Accepted Answer · 2012-12-19 14:13:36Z

0

Fixed to match 1:many condition

List<Warehouse> lstObjWarehouse =   objWMSContext.Warehouses.Include("WarehouselnkedEcorder")
                    .Where(o => o.somefield == "SomeCondition"
                  &&       o => o.Deleted == false
                  &&       o=>o.WarehouselnkedEcorders.Where(dep=>dep.status==true)
                 .ToList();

edited Dec 19, 2012 at 14:13

answered Dec 19, 2012 at 13:33

phil soady

11.4k5 gold badges55 silver badges100 bronze badges

1 Comment

mastan Over a year ago

It supposed to get o=>o.WarehouselnkedEcorders.status == true. But it shows WarehouselnkedEcorders as a list with methods like Any,Where,etc.

Collectives™ on Stack Overflow

Entity framework with Include method

2 Answers 2

1 Comment

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related