I am trying to select a specific record from the db using entity, but can't figure out how.
This is what is going on. I'm trying to pass the record item_NumberID in to the query from a label control named lbQueryValue then put the record values into variables.
// This is the select query
nlaCatalog ctlog = new nlaCatalog();
// this line doesn't work
nlaCatalog ctlog = ctlog.ToList().Where(x => x.Item_NumberID == int.Parse(lbQueryValue.Text.ToString())).First();
string itImage = ctlog.Item_Image.ToString();
string itName = ctlog.Item_Name.ToString();
string itDiscription = ctlog.Description.ToString();
string itPrice = ctlog.Price.ToString();
One other thing: because the table nlaCatalog does not have a relationship to any other table, it has no Navigation Properties.