public static void SimpleQueryDB() { const string NAME = "Michael"; SchoolDBContext context = new SchoolDBContext(); try { var list = context.Student.Where(s => s.Nombres == NAME).ToList(); if (list != null) { Console.WriteLine(list.Find(s => s.Nombres == NAME).Nombres); } else { Console.WriteLine("No se encuentra el Estudiante!!"); } } catch (Exception) { throw; } finally { context.Dispose(); } }
public static void UpdatingData() { SchoolDBContext context = new SchoolDBContext(); try { var std = context.Student.First <Estudiantes>(); std.Nombres = "Mabel"; bool modified = context.SaveChanges() > 0; if (modified) { Console.WriteLine("Modificado.."); } else { Console.WriteLine("No se pudo Modificar"); } } catch (Exception) { throw; } finally { context.Dispose(); } }
public static void GuardarCurso() { SchoolDBContext context = new SchoolDBContext(); try { var auxCourse = new Cursos() { CursoId = 0, NombreCurso = "Sociales" }; context.Courses.Add(auxCourse); bool save = context.SaveChanges() > 0; if (save) { Console.WriteLine("Guardado !!"); } else { Console.WriteLine("No se pudo Guardar"); } } catch (Exception) { throw; } finally { context.Dispose(); } }
public static void DeletingData() { SchoolDBContext context = new SchoolDBContext(); try { var std = context.Student.First <Estudiantes>(); context.Student.Remove(std); bool deleted = context.SaveChanges() > 0; if (deleted) { Console.WriteLine("Ha Sido Eliminado"); } else { Console.WriteLine("No se Pudo Eliminar Error"); } } catch (Exception) { throw; } finally { context.Dispose(); } }
public static void QuerryUsingSql() { SchoolDBContext context = new SchoolDBContext(); List <Estudiantes> studentList = new List <Estudiantes>(); try { studentList = context.Student.FromSqlRaw("Select *from dbo.Students").ToList(); if (studentList != null) { Console.WriteLine(studentList.Find(s => s.Nombres == "Bill").Nombres); } else { Console.WriteLine("No se pudo Encontrar el Estudiante!!"); } } catch (Exception) { throw; } finally { context.Dispose(); } }
static void GuardarEstudiantesDB() { SchoolDBContext context = new SchoolDBContext(); try { var auxStudent = new Estudiantes() { EstudianteId = 0, Nombres = "Clarens", }; context.Student.Add(auxStudent); bool save = context.SaveChanges() > 0; if (save) { Console.WriteLine("guadado Correctamente"); } else { Console.WriteLine("No Se Pudo Guardar"); } } catch (Exception) { throw; } finally { context.Dispose(); } }
public static void DoubleQueryDB() { SchoolDBContext context = new SchoolDBContext(); try { var resultado = context.Courses.Where(c => c.NombreCurso == "Sociales").FirstOrDefault(); if (resultado != null) { Console.WriteLine(resultado.NombreCurso.ToString()); } else { Console.WriteLine("No se pudo Encontrar el Curso!!"); } } catch (Exception) { throw; } finally { context.Dispose(); } }
protected override void Dispose(bool disposing) { if (disposing) { db.Dispose(); } base.Dispose(disposing); }
protected virtual void Dispose(bool disposing) { if (!this.disposed) { if (disposing) { context.Dispose(); } } this.disposed = true; }
public static void UpdatingOnDisconnectedScenario() { SchoolDBContext context = new SchoolDBContext(); try { var modifiedStudent1 = new Estudiantes() { EstudianteId = 1, Nombres = "Jay", }; var modifiedStudent2 = new Estudiantes() { EstudianteId = 2, Nombres = "Juan", }; List <Estudiantes> modifiedStudents = new List <Estudiantes>() { modifiedStudent1, modifiedStudent2, }; context.UpdateRange(modifiedStudents); bool modified = context.SaveChanges() > 0; if (modified) { Console.WriteLine("Modificado"); } } catch (Exception) { throw; } finally { context.Dispose(); } }
public void Dispose() { _schoolDBContext.Dispose(); }