public void ReadImageDimensions() { HalloContext context = new HalloContext(); List<Image> list = context.Images.ToList(); foreach (Image i in list) { System.Drawing.Image jpgImage = System.Drawing.Image.FromFile(@"c:\Hallo\Hallo\Images\articleImages\images\img" + i.Id + ".jpg"); i.Width = jpgImage.Width; i.Height = jpgImage.Height; } context.SaveChanges(); }
// This method loads ArticleCategories from HK-online to a new Hallo-DB public void InitArticleCategories(HalloContext context) { if (context.Categories.Count() > 0) return; SqlConnection sourceConnection = GetSourceConnection(); SqlCommand catCmd = new SqlCommand( "SELECT * from HK_ARTICLE_CATEGORIES order BY CategoriID", sourceConnection ); SqlDataReader catReader = catCmd.ExecuteReader(); while (catReader.Read()) { context.Categories.Add(new ArticleCategory { Name = catReader["CategoriName"].ToString() }); } context.SaveChanges(); catReader.Close(); sourceConnection.Close(); }