/// <summary> /// inserts a genre by name /// </summary> /// <param name="genreName">name of genre</param> /// <returns>id of genre</returns> public static int InsertGenre(string genreName) { return(DalHelper.InsertIfNotExist($"INSERT INTO Genres ([Genre Name]) VALUES ('{genreName}')", $"SELECT ID FROM Genres WHERE [Genre Name] LIKE '{genreName}'")); }