CacheProvider
The namespace of an ADO.NET provider. The specified provider is used as the target database for all caching operations.
Data Type
string
Default Value
""
Remarks
You can cache to ADO.NET providers saved in your ADO.NET global assembly cache (GAC).
CData ADO.NET providers automatically register themselves with the GAC during installation, so you don't need to do so manually.
Third-party ADO.NET providers may or may not automatically register themselves with the GAC during installation. If you want to cache to a third-party ADO.NET provider, consult the documentation for that provider to determine what steps (if any) you must take to register them with the GAC. Once they have been registered, you can supply their namespace in this connection property.
You must also set the CacheConnection connection property to provide a connection string for the specified ADO.NET provider.
The following sections show connection examples and address other requirements for several popular database providers. Refer to CacheConnection for more information on typical connection properties.
SQLite
You can use the Microsoft ADO.NET Provider for SQLite to cache to SQLite databases.
CacheProvider=Microsoft.Data.Sqlite;CacheConnection='DataSource=C:\\Users\\Public\\cache.db;'OAuthClientId=MyConsumerKey;OAuthClientSecret=MyConsumerSecret;CallbackURL=http://localhost:portNumber
MySQL
To cache to MySQL, you can use the CData ADO.NET Provider for MySQL:Cache Provider=System.Data.CData.MySQL;Cache Connection='Server=localhost;Port=3306;Database=cache;User=root;Password=123456';User=myUser;Password=myPassword;Security Token=myToken;
SQL Server
You can use the Microsoft .NET Framework Provider for SQL Server, included in the .NET Framework, to cache to SQL Server:
Cache Provider=System.Data.SqlClient;Cache Connection="Server=MyMACHINE\MyInstance;Database=SQLCACHE;User Id=root;Password=admin";OAuthClientId=MyConsumerKey;OAuthClientSecret=MyConsumerSecret;CallbackURL=http://localhost:portNumber
Oracle
To cache to Oracle, you can use the Oracle Data Provider for .NET, as shown in the following example:
Cache Provider=Oracle.DataAccess.Client;Cache Connection='User Id=scott;Password=tiger;Data Source=ORCL';OAuthClientId=MyConsumerKey;OAuthClientSecret=MyConsumerSecret;CallbackURL=http://localhost:portNumber
The Oracle Data Provider for .NET also requires the Oracle Database Client. When you download the Oracle Database Client, ensure that its bitness matches the bitness of your machine. When you install, select either the Runtime or Administrator installation type. The Instant Client is not sufficient.
PostgreSQL
To cache to PostgreSQL, you can use the CData ADO.NET Provider for PostgreSQL:Cache Provider=System.Data.CData.PostgreSQL;Cache Connection='Server=localhost;Port=5432;Database=cache;User=postgres;Password=123456';User=myUser;Password=myPassword;Security Token=myToken;