public void UpdatePhotoUrls()
{
using (InstagramEntities db = new InstagramEntities())
{
for (int i = 0; i < 257; i++)
{
photos photo = db.photos.Where(s => s.id == i + 1).FirstOrDefault();
photo.image_url = "https://picsum.photos/id/" + i + "/500/580";
db.SaveChanges();
}
}
}
private void Form1_Load(object sender, EventArgs e)
{
using (InstagramEntities db = new InstagramEntities())
{
var qury = from st in db.users
select st;
List <users> allUsers = qury.ToList <users>();
foreach (var v in allUsers)
{
UserNameListBox.Items.Add(v.username);
}
UserNameListBox.SetSelected(0, true);
//Added in order to update Photos table image_url values:
DBUpdater updater = new DBUpdater();
updater.UpdatePhotoUrls();
}
}