Sorry for my bad english, but i have problem in my project

I have a linq query like

var q = (from ulist in db.shop_list
                             where ulist.shop_user.username.Equals(username)
                             select new 
                             { 
                                shoplist = ulist,
                                listitem = ulist.shop_item.ToList(),
                             });

shop_list table relationship with shop_item table via PK key of shop_list table and listID field in shop_item table. shop_item table relationship with favorite(id,userid,shop_item_id) table via PK key

How i can get favorite for each shop_item with user loging??

i can't put 1 property for count it?. How to solution ?

Related posts

Recent Viewed