public void Insert(NpgsqlConnection connection, User[] users, string[] passwords)
{
var columns = new[]
{
DbStr.Id,
DbStr.Name,
DbStr.Description,
DbStr.Photo,
DbStr.Password,
DbStr.Enabled,
DbStr.CanChange,
DbStr.Privilege
};
var values = users.Select((u, i) => new object[]
{
u.Id,
u.Name,
u.Description,
u.Photo,
passwords[i],
u.Enabled,
u.CanChange,
u.Privilege
}).ToArray();
_npgHelper.ExecuteNonQuery(connection, _npgQueryHelper.Insert(DbStr.Users, columns, values));
}
