ADO.NET at its most basic level was designed to help developers work efficiently with multi tier databases, across intranet or Internet scenarios. This is a tall order for a single framework, but I think they managed to pull it off quite well.
It's helpful to view the object model as being split into two parts - A connected and a disconnected side of the model. Even though there is no distinction between the two "sides", it helps me to visualize how the data object was intended to be used.
See the specific topics below for more information:
ADO.NET 3.5 SP1 added a new higher-level data access strategy called Entity Framework. VistaDB supports Entity Framework 4.0 at later through a separate provider assembly that works with the VistaDB engine. Depending on the version of Entity Framework that you are employing in your application you'll need to pick the appropriate configuration and provider assembly. For more information see Using VistaDB with Entity Framework - Registering the Provider.