Chimney.Shared.UserControls.ChimneyServerUserControl.GetAlbumId C# (CSharp) Method

        async Task<int> GetAlbumId(string name)
        {
            int id = -1;
            while (id < 0)
            {
                if (string.IsNullOrEmpty(name)) name = string.Empty;

                var album = await Dbconnection.QueryAsync<Album>("SELECT * FROM Albums WHERE Name = \"" + name + "\"");

                if (album.Count > 0)
                {
                    id = album.First<Album>().AlbumId;
                }
                else
                {
                    Album newAlbum = new Album()
                    {
                        Name = name
                    };

                    await Dbconnection.InsertAsync(newAlbum);
                }
            }

            return id;
        }