public int Create(PersonEntity personEntity) { PersonContext personContext = new PersonContext(); personContext.Persons.Add(personEntity); personContext.SaveChanges(); return(1); }
public PersonEntity Update(PersonEntity person) { lock (_personTable) { var old = Get(person.Id); old.Name = person.Name; return(old); } }
public PersonEntity Insert(PersonEntity person) { if (Exists(person.Id)) { throw new InvalidOperationException($"Key exists {person.Id}"); } person.Id = ++lastId; _personTable.Add(person); return(person); }
public PersonEntity Insert(PersonEntity person) { if (Exists(person.Id)) { throw new InvalidOperationException($"Key exists {person.Id}"); } lock (_personTable) { int lastId = _personTable.Max(m => m.Id); person.Id = ++lastId; _personTable.Add(person); } return(person); }
public bool Exists(int personId) { PersonContext db = new PersonContext(); PersonEntity personEntity = new PersonEntity(); var person = db.Persons.Where(p => p.Id == personId).FirstOrDefault(); if (person != null) // update { return(false); } else { return(true); } }
private ActorPersonDto InsertOrUpdate(ActorPersonDto dto) { using (var adapter = new DataAccessAdapter()) { var data = new LinqMetaData(adapter); var entity = data.Person.FirstOrDefault(ActorPersonDtoPersistence.CreatePkPredicate(dto)); if (entity == null) { entity = new PersonEntity(); } entity.UpdateFromActorPersonDto(dto); adapter.SaveEntity(entity, true); //We need to do this extra call as per https://www.llblgen.com/Documentation/5.3/Derived%20Models/dto_llblgen.htm#example-projection-on-database-query var result = data.Person.Where(x => x.Id == entity.Id).ProjectToActorPersonDto().ToList(); return(result[0]); } }