How do I refresh the relationships in a dataset?

Question

I a working in VisualStudio 2005. I have a dataset with sevaral datatables in it already. I had to modify the database to add a new foreign key that I forgot about. How do I get visual studio to recognize the new relationship?

Answer 1

.Net does not load FK relationships into your DataSet automatically - however, you can add them yourself with a DataRelation*.

*this may not be true if you are using LINQ - if you are, I am unsure.