/// <summary> /// Adding a new record to database via EF /// </summary> /// <param name="inputFileName"></param> /// <param name="inputFileContent"></param> /// <param name="outputFileName"></param> /// <param name="outputFileContent"></param> /// <param name="hashInput"></param> /// <param name="hashOutput"></param> /// <param name="trivia"></param> public static void AddNewRecord(string inputFileName, byte[] inputFileContent, string outputFileName, byte[] outputFileContent, string hashInput, string hashOutput, string trivia) { using (DESEDMEntities context = new DESEDMEntities()) { try { context.DESContents.AddObject(new DESContent() { InputFileName = inputFileName, InputFileContent = inputFileContent, OutputFileName = outputFileName, OutputFileContent = outputFileContent, HashInput = hashInput, HashOutput = hashOutput, Trivia = trivia }); context.SaveChanges(); } catch (Exception ex) { Console.WriteLine(ex.InnerException.Message); } } }
/// <summary> /// Print database content /// </summary> public static void PrintAllContent() { using (DESEDMEntities context = new DESEDMEntities()) { foreach (DESContent c in context.DESContents) Console.WriteLine(c.InputFileName); } }
/// <summary> /// Remove via link /// </summary> public static void RemoveRecordWithLINQ() { using (DESEDMEntities context = new DESEDMEntities()) { // Check whether we have it or not var contentToDelete = (from c in context.DESContents where c.Id == 2222 select c).FirstOrDefault(); } }
/// <summary> /// Update a row via id /// </summary> private static void UpdateRecord() { using (DESEDMEntities context = new DESEDMEntities()) { EntityKey key = new EntityKey("DESEDMEntities.DESContents", "Id", 2222); DESContent contentToUpdate = (DESContent)context.GetObjectByKey(key); Console.WriteLine(contentToUpdate.EntityState); if (contentToUpdate != null) { contentToUpdate.InputFileName = "Updated.txt"; context.SaveChanges(); } } }
/// <summary> /// Remove a row via id /// </summary> public static void RemoveRecord() { using (DESEDMEntities context = new DESEDMEntities()) { EntityKey key = new EntityKey("DESEDMEntities.DESContents", "Id", 2222); DESContent contentToDelete = (DESContent)context.GetObjectByKey(key); if (contentToDelete != null) { context.DeleteObject(contentToDelete); context.SaveChanges(); } } }