public Note GetNote(int No) { using (var db = new BbsDbContext(_configuration)) { var note = db.Notes.FirstOrDefault(x => x.No.Equals(No)); return(note); } }
public User GetUser(int Id) { using (var db = new BbsDbContext(_configuration)) { var user = db.Users.FirstOrDefault(x => x.Id.Equals(Id)); return(user); } }
public bool PostNote(Note note) { using (var db = new BbsDbContext(_configuration)) { db.Notes.Add(note); return((db.SaveChanges() > 0) ? true : false); } }
public List <Note> GetNoteList() { using (var db = new BbsDbContext(_configuration)) { // DB에서 연동하고 List 출력 return(db.Notes.Include(x => x.User) .OrderByDescending(n => n.No) .ToList()); } }