예제 #1
0
 public void UpdatePerson(PersonDbo person)
 {
     Execute(@"
      UPDATE p
         SET p.Name = @Name,
         p.Instagram = @Instagram,
         p.Vk = @Vk,
         p.Email = @Email,
         p.TimeUpdate = GETDATE()
         FROM Person p
         WHERE p.Id = @Id", person);
 }
예제 #2
0
        public void AddPerson(PersonDbo person)
        {
            Execute(@"
            INSERT Person 
  (Id, Name, Instagram, Vk, Email, TimeStamp)
  VALUES 
  (
  DEFAULT,
 @Name,
 @Instagram,
 @Vk,
 @Email,
 DEFAULT);", person);
        }