The main characters that "die" in Final Fantasy XIII are Vanille and Fang but you would have to view the ending for yourself to decide if they are really "dead". It is implied that Cid dies, I say...
Final Fantasy 13-2 is a direct sequel of Final Fantasy 13. It was created to improve the wrongs made in the first game and add a whole new story with new features.