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

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

                var artist = await Dbconnection.QueryAsync<Artist>("SELECT * FROM Artists WHERE Name = \"" + name + "\"");

                if (artist.Count > 0)
                {
                    id = artist.First<Artist>().ArtistId;
                }
                else
                {
                    Artist newArtist = new Artist()
                    {
                        Name = name
                    };

                    await Dbconnection.InsertAsync(newArtist);
                }
            }

            return id;
        }