While your application is running and a connection has been made to a data source, what happens if you delete the data source from the file system while you are navigating records? What about inserting or deleting records?
Nothing happens. The database file is not locked, so you can delete it. You can add and delete records because you are just interfacing with a DataSet. However, once you attempt to update the data source with the new DataSet, an exception will be thrown because the file cannot be found.
Do you need a database to create datasets, tables, and records within the .NET Framework?
No, you can create an entire database during runtime using the .NET Framework classes.
What is a table relationship and how is it handled within a DataSet?
A table relationship is an association of two tables in a parent-child relationship. Table relationships are contained within the DataRelationCollection object in the DataSet.