This Schema Provider is based on the Schema Provider provided by Adam Nelson (anelson@apocryph.org) which can be found at http://community.codesmithtools.com/files/folders/schemaproviders/entry18263.aspx. If you have any questions or comments regarding this Schema Provider, contact me, Joseph Guadagno, at jguadagno@hotmail.com.
Improvements Made
- Added a resource file for string constants, and messages.
- Name property changed to use Reflection to return the name of the provider.
- Description property changed to use a string from the resource file.
- GetCommandParameters, GetCommandResultSchemas, and GetCommandText methods were changed to use the resource file for its string values.
- GetTableColumns: This method was modified to return additional properties to the column, namely size, numeric scale, and precision.
- GetTableKeys: This method was modified to return the ForeignKeys for the table as well as the tables that have a reference to the specified table. This is required by the SchemaExplorer interface to properly populate the PrimaryKey and ForiegnKey properties.
- New File: SchemaColumns.cs: This file contains constants for all of the columns available for GetSchema calls.
- Included a test client which provides an interface to test the provider.
Requirements for this SchemaProvider
SchemaExplorer.DLL version 3.2.7.955
System.Data.SQLite ADO.NET provider found at http://sourceforge.net/projects/sqlite-dotnet2