I want to send a list of names contained in a Database using asp.net

These are my two objects:

public class Shop
{
    public int ID { get; set; }
    public string Country { get; set; }
    public List<Item> Items{ get; set; }
}

public class Item
{
    public int ID { get; set; }
    public string Name { get; set; }
}

I want to set a get controller in order to retrieve a list of items. I did something like this:

 public IEnumerable<Item> Get(int id)
    {

        var items= new List<Item>();
        var shop= new Shop();

        using (var systemDB = new ShopsDB())
        {
                            it = systemDB.Shops.Where(s => s.ID == id).FirstOrDefault<Shop>();
                            items = it.Items;
        }   

            return items;

    }

This return <ArrayOfItem i:nil="true"/>. I want to get the complete list of Items for one shop (e.g. shop with ID=1)

Related posts

Recent Viewed