Caching data using OData Data Provider
Connection string
This CData ADO.NET Provider for OData connection string can be used for connections to OData.
URL=http://dataService;Cache Location=C:\cache.db;Auto Cache=true;Offline=false;
This CData ADO.NET Provider for OData connection string can be used for connections to OData.
URL=http://dataService;Cache Location=C:\cache.db;Auto Cache=true;Offline=false;
To retrieve data from the cache, use table name "table#Cache" in sql query. Example, "SELECT * FROM [Table#Cache]".