OleDbSchemas Interface Summary

This is a creatable class, more than one is allowed. OleDbSchemas is the interface that exposes the read-only string representations of the Scantron provider-specific OleDb schema GUIDS.

The schemas themselves allow plug-n-play with ADO and ADO.Net object model. Use them with these:

• ADODB.Connection.OpenSchema
• System.Data.OleDb.OleDbConnection.GetOleDbSchemaTable

This class complements the generic (not provider specific) System.Data.OleDb.OleDbSchemaGuids class in the .Net framework. The class design favors scripting and automation clients, hence the string types instead of more .Net friendly GUID types.

The alphabetic list of properties and methods is provided below. For complete details, see the topic specific to each property. Sample implementations are shown below, including a connection string.

Visual Basic .NET Example: This is from the ScanTools Plus Link Data Editor sample program, which uses the OleDbSchemaClass.

Imports System.Data

Imports System.Data.OleDb

Imports ScanToolsPlusLink

‘Create a connection – got to specify the edit prfile if doing editprofile schema

dim cnStr as String =

"Provider=Scantron.Oledb;App File=z802.sds.StxAppDef;Edit Profile=802.$epStxEdtPrf;"

dim cn as OleDbConnection = new OleDbConnection(cnStr)

cn.Open()

Dim oldedbSchemas As New ScanToolsPlusLink.OleDbSchemasClass

' ------------------------------------------------------

'Get the ClipSchema for every document in the appdef

' ------------------------------------------------------

Dim EditSchemaGuid As New System.Guid(oldedbSchemas.EditProfile.ToString)

_schemaClips = cn.GetOleDbSchemaTable(EditSchemaGuid, New Object() {Nothing, Nothing, Nothing, Nothing, Nothing})

' ------------------------------------------------------

'Get the ClipSchema for every document in the appdef

' ------------------------------------------------------

Dim ClipSchemaGuid As New System.Guid(oldedbSchemas.Clips.ToString)

_schemaClips = cn.GetOleDbSchemaTable(ClipSchemaGuid, New Object() {Nothing, Nothing, Nothing, Nothing, Nothing, Nothing, Nothing, Nothing, Nothing})