The sections below will help guide you through using and configuring various Schema Providers that ship with CodeSmith Generator.
...
- If you're using the SqlSchemaProvider, connection strings follow the format used by the .NET SqlConnection.ConnectionString property.
- If you're using the ADOXSchemaProvider, connection strings follow the format used by the ADO ConnectionString property.
- If you're using the OracleSchemaProvider, please be sure to check out the link below for creating a connection string as well as the Connecting to an Oracle database section below.
- If you're using the PostgreSchemaProvider, please make sure the following statement is included in your ConnectionString: Preload Reader = true;
...
These settings can be configured in the Generator Options Schema Provider section as shown above.
...
If you are trying to use the
Oracle Schema Provider
...
Connecting to an Oracle database
...
The .NET Framework 4.0 machine.config's can be found here:
- %windir%\Microsoft.NET\Framework\v4.0.30319\Config\machine.config
- %windir%\Microsoft.NET\Framework64\v4.0.30319\Config\machine.config
Next, you will need to copy the 64bit or 32bit SQLite assemblies that were installed via the System.Data.SQLite installer to CodeSmith Generators bin folder. This bin folder can be found in the location that you installed CodeSmith Generator to.
| Info |
|---|
You should copy the 64bit SQLite assemblies if you are using 64 bit windows. |
Finally, you are ready to start using the SQLite Schema Provider!