private void AddProfile(string userId, Profile profile) { var sql = $@"INSERT INTO Profiles (Age, Sex, Location) VALUES (@{nameof(Profile.Age)}, @{nameof(Profile.Sex)}, @{nameof(Profile.Location)}); INSERT INTO UserProfileMap (UserId, ProfileId) VALUES (@{nameof(userId)}, LAST_INSERT_ID());"; UnitOfWork.AddOperation(profile, async connection => await connection.ExecuteAsync(sql, new { profile.Age, profile.Sex, profile.Location, userId })); }
private void UpdateProfile(Profile profile) { var sql = $@"UPDATE Profiles SET Age = @{nameof(Profile.Age)}, Sex = @{nameof(Profile.Sex)}, Location = @{nameof(Profile.Location)} WHERE Profiles.Id = @{nameof(profile.Id)}"; UnitOfWork.AddOperation(profile, async connection => await connection.ExecuteAsync(sql, new { profile.Age, profile.Sex, profile.Location, profile.Id })); }