I got two entities:
public class User : Entity
{
public virtual string Username { get; set; }
public virtual string Email { get; set; }
public virtual string PasswordHash { get; set; }
public virtual List<Photo> Photos { get; set; }
}
and
public class Photo : Entity
{
public virtual string FileName { get; set; }
public virtual string Thumbnail { get; set; }
public virtual string Description { get; set; }
public virtual int UserId { get; set; }
public virtual User User { get; set; }
}
When I try to delete the photo it works fine for the DB (record gets romoved from the table) but it doesnt for the Photos collection in the User entity (I can still see that photo in user.Photos).
This is my code. What I'm doing wrong here? Changing entity properties works fine. When I change photo FileName for example it gets updated in DB and in user.Photos.
var photo = SelectById(id);
Context.DeleteObject(photo);
Context.SaveChanges();
var user = GetUser(userName);
// the photo I have just deleted is still in user.Photos
also tried this but getting same results:
var photo = user.Photos.First();
Context.DeleteObject(photo);
Context.SaveChanges();