private void PrintData3() { using (var context = new ModelPhotograph()) { foreach (var photo in context.Photo) { var data = String.Format("Photo: {0}, ThumbnailSize {1} bytes\n", photo.Title, photo.ThumbnailBits.Length); textBox1.Text += data; Console.WriteLine("Photo: {0}, ThumbnailSize {1} bytes", photo.Title, photo.ThumbnailBits.Length); // explicitly load the "expensive" entity, context.Entry(photo).Reference(p => p.PhotographFullImage).Load(); Console.WriteLine("Full Image Size: {0} bytes", photo.PhotographFullImage.HighResolutionBits.Length); data = String.Format("Full Image Size: {0} bytes", photo.PhotographFullImage.HighResolutionBits.Length); textBox1.Text += data; } } }
private void InsertData3() { byte[] thumbBits = new byte[100]; byte[] fullBits = new byte[2000]; using (var context = new ModelPhotograph()) { var photo = new Photograph { Title = "My Dog", ThumbnailBits = thumbBits }; var fullImage = new PhotographFullImage { HighResolutionBits = fullBits }; photo.PhotographFullImage = fullImage; context.Photo.Add(photo); context.SaveChanges(); } }