IDbCommand cmd = conn.CreateCommand (); cmd.CommandText = @" SELECT devices.lastmountpoint, tags.url, tags.title, artist.name, genre.name, album.name, year.name, tags.track, tags.length FROM tags, devices, artist, album, genre, year WHERE tags.deviceid = devices.id AND tags.artist = artist.id AND tags.album = album.id AND tags.genre = genre.id AND tags.year = year.id"; IDataReader reader = cmd.ExecuteReader ();