Загрузка данных


public ICommand AddCommand => new Command(async () => await Add());
        async Task Add()
        {
            using var conn = new NpgsqlConnection(connString);
            await conn.OpenAsync();

            var cmd = new NpgsqlCommand("INSERT INTO users (username,password) VALUES (@username, @password)", conn);
            cmd.Parameters.AddWithValue("password",Password);
            cmd.Parameters.AddWithValue("username", Login);

            await cmd.ExecuteNonQueryAsync();
            int id = await InfoIdent();
            await Application.Current.MainPage.DisplayAlert("Successful!", $"Create Account!\nWelcome {Login}\nYour ID:{id}", "Ok");
        }

        async Task<int> InfoIdent()
        {
            using var conn = new NpgsqlConnection(connString);
            await conn.OpenAsync();

            var cmd = new NpgsqlCommand(
                "SELECT id FROM users WHERE username = @username",
                conn);

            cmd.Parameters.AddWithValue("username", Login);

            var result = await cmd.ExecuteScalarAsync();

            return Convert.ToInt32(result);
        }