SELECT statements will always retrieve data from the cache. DELETE/UPDATE/INSERT statements is not allowed and will throw an exception.
This connection string (Cached data only / Offline mode using OData Data Provider) can be used for connections to
Start over in the connection string reference index.
You can also get help in the Q&A forums where you can ask your own question.
The kb articles contains how-tos and instructions and you can search for anything if you're not sure were to look.