I have a base class (called SimpleManager) which does all the "easy" things for me.
Here a quick overview of some functions:
void Save(DataSet)
DataRow GetByID(int ID)
void Delete(int ID)
All i have to do now is to create a new instance of SimpleManager, set his TableName property to the name of the table I want to query and call GetByID to get a single row.
Because all of our PrimaryKeys are in the format "ID_"+tablename, it is very easy to search for a PK.
So in this situation all I know about the collection (also entity, view, a.s.o.) is its name (Tablename + "Collection").
I don't see a way to cast the collection to that specific type because I only know it's name.
This code did work now for over 2 years. So it's not the question why we do this. It's more the question "How can we do this with the new Version?"