c# - FIltering data in entity using two other entities -

c# - FIltering data in entity using two other entities -

i have next 3 info tables:

public partial class category { public category() { this.subcategory = new hashset<subcategory>(); } public int category_id { get; set; } public string description { get; set; } public virtual icollection<subcategory> subcategory { get; set; } }

second entity

public partial class subcategory { public subcategory() { this.tracked_item = new hashset<item>(); } public int subcategory_id { get; set; } public int category_id { get; set; } public string description { get; set; } public virtual icollection<item> item { get; set; } public virtual category category { get; set; } }

third entity

public partial class item { public int item_id { get; set; } public string serial_number { get; set; } public string inventory_number { get; set; } public int subcategory_id { get; set; } public nullable<int> manu_id { get; set; }} public virtual subcategory subcategory { get; set; } public virtual manu manu { get; set; } }

i trying write method in web api want filter info using 3 parameters using item context

public ienumerable<filtereditems> getfilteritem(int category_id, int subcategory_id, int manu_id) { homecoming dbset.where(c=>c.category_id=category_id && c.subcategory_id && subcategory_id && c.manu_id =manu_d).select(d=> new filtereditems() { ---- }:

problem have on .where(c=>c.category_id=category_id && c.subcategory_id && subcategory_id && c.manu_id =manu_d) intellisense wont go pass category_id not able go subcategory_id , manu_id

please allow me know how write query can filter info based on 3 variables.

2 things:

== show equivalence. = assigning. so c.category_id=category_id should c.category_id==category_id c.subcategory_id && subcategory_id looks typo. should utilize == instead of &&

so code be:

public ienumerable<filtereditems> getfilteritem(int category_id, int subcategory_id, int manu_id) { homecoming dbset.where(c=>c.category_id == category_id && c.subcategory_id == subcategory_id && c.manu_id == manu_d) .select(d=> new filtereditems { ---- }); }

c# linq entity-framework asp.net-web-api entity-framework-4