Class SchemaCache

Inheritance

System.Object

CacheBase

ClarifyCacheBase

SchemaCache

Implements

ISchemaCache

Inherited Members

CacheBase.UpdateSyncRoot

CacheBase.OnCacheUpdated()

CacheBase.OnAnyCacheUpdated(CacheBase)

CacheBase.ReadCacheData(String)

CacheBase.PersistCacheData(Object, String)

CacheBase.GetCacheDataHash()

CacheBase.GenerateMD5Hash(String)

CacheBase.AllTablesExistInDataSet(DataSet, String[])

CacheBase.GetCacheFilePath(String)

CacheBase.AnyCacheUpdated

CacheBase.CacheUpdated

System.Object.ToString()

System.Object.Equals(System.Object)

System.Object.Equals(System.Object, System.Object)

System.Object.ReferenceEquals(System.Object, System.Object)

System.Object.GetHashCode()

System.Object.GetType()

System.Object.MemberwiseClone()

Namespace: FChoice.Foundation.Clarify

Assembly: fcSDK.dll

Syntax

public class SchemaCache : ClarifyCacheBase, ISchemaCache

Constructors

SchemaCache(Boolean)

Declaration

public SchemaCache(bool isSolo)

Parameters

Type	Name	Description
System.Boolean	isSolo

Fields

Amdocs65

Declaration

public const int Amdocs65 = 62

Field Value

Type	Description
System.Int32

Amdocs75

Declaration

public const int Amdocs75 = 6600

Field Value

Type	Description
System.Int32

CLARIFY_10

Declaration

public const int CLARIFY_10 = 55

Field Value

Type	Description
System.Int32

CLARIFY_11

Declaration

public const int CLARIFY_11 = 56

Field Value

Type	Description
System.Int32

CLARIFY_115

Declaration

public const int CLARIFY_115 = 58

Field Value

Type	Description
System.Int32

CLARIFY_12

Declaration

public const int CLARIFY_12 = 59

Field Value

Type	Description
System.Int32

CLARIFY_125

Declaration

public const int CLARIFY_125 = 60

Field Value

Type	Description
System.Int32

CLARIFY_13

Declaration

public const int CLARIFY_13 = 61

Field Value

Type	Description
System.Int32

CLARIFY_4

Declaration

public const int CLARIFY_4 = 42

Field Value

Type	Description
System.Int32

CLARIFY_45

Declaration

public const int CLARIFY_45 = 43

Field Value

Type	Description
System.Int32

CLARIFY_5

Declaration

public const int CLARIFY_5 = 44

Field Value

Type	Description
System.Int32

CLARIFY_6

Declaration

public const int CLARIFY_6 = 45

Field Value

Type	Description
System.Int32

CLARIFY_6X

Declaration

public const int CLARIFY_6X = 46

Field Value

Type	Description
System.Int32

CLARIFY_7

Declaration

public const int CLARIFY_7 = 51

Field Value

Type	Description
System.Int32

CLARIFY_8

Declaration

public const int CLARIFY_8 = 52

Field Value

Type	Description
System.Int32

CLARIFY_9

Declaration

public const int CLARIFY_9 = 54

Field Value

Type	Description
System.Int32

CLARIFY_CFO98

Declaration

public const int CLARIFY_CFO98 = 48

Field Value

Type	Description
System.Int32

Properties

CacheSetName

Declaration

public override string CacheSetName { get; }

Property Value

Type	Description
System.String

Overrides

CacheBase.CacheSetName

CacheType

Declaration

public override CacheType CacheType { get; }

Property Value

Type	Description
CacheType

Overrides

CacheBase.CacheType

CustomSchemaDate

Declaration

public DateTime CustomSchemaDate { get; }

Property Value

Type	Description
System.DateTime

DatabaseName

Declaration

public string DatabaseName { get; }

Property Value

Type	Description
System.String

DataRestrictionsEnabled

Declaration

public bool DataRestrictionsEnabled { get; }

Property Value

Type	Description
System.Boolean

Flags

Declaration

public int Flags { get; }

Property Value

Type	Description
System.Int32

IsDatabaseUnicode

Declaration

public bool IsDatabaseUnicode { get; }

Property Value

Type	Description
System.Boolean

LastModifiedDate

Declaration

public DateTime LastModifiedDate { get; }

Property Value

Type	Description
System.DateTime

RestrictionGroups

Declaration

public RestrictionGroupCollection RestrictionGroups { get; }

Property Value

Type	Description
RestrictionGroupCollection

SchemaRevision

Declaration

public string SchemaRevision { get; }

Property Value

Type	Description
System.String

SiteID

Declaration

public string SiteID { get; }

Property Value

Type	Description
System.String

Tables

Declaration

public SchemaTableCollection Tables { get; }

Property Value

Type	Description
SchemaTableCollection

VendorSchemaDate

Declaration

public DateTime VendorSchemaDate { get; }

Property Value

Type	Description
System.DateTime

Views

Declaration

public SchemaViewCollection Views { get; }

Property Value

Type	Description
SchemaViewCollection

Methods

GetChangeDateField(String)

Declaration

public SchemaTableField GetChangeDateField(string tableName)

Parameters

Type	Name	Description
System.String	tableName

Returns

Type	Description
SchemaTableField

GetDateFields(String)

Declaration

public SchemaFieldBase[] GetDateFields(string objectName)

Parameters

Type	Name	Description
System.String	objectName

Returns

Type	Description
SchemaFieldBase[]

GetField(String, String)

Declaration

public SchemaFieldBase GetField(string objectName, string fieldName)

Parameters

Type	Name	Description
System.String	objectName
System.String	fieldName

Returns

Type	Description
SchemaFieldBase

GetRelation(String, String)

Declaration

public SchemaRelation GetRelation(string tableName, string relationName)

Parameters

Type	Name	Description
System.String	tableName
System.String	relationName

Returns

Type	Description
SchemaRelation

GetTableField(String, String)

Declaration

public SchemaTableField GetTableField(string tableName, string fieldName)

Parameters

Type	Name	Description
System.String	tableName
System.String	fieldName

Returns

Type	Description
SchemaTableField

GetTableID(String)

Declaration

public int GetTableID(string tableName)

Parameters

Type	Name	Description
System.String	tableName

Returns

Type	Description
System.Int32

GetTableName(Int32)

Declaration

public string GetTableName(int tableID)

Parameters

Type	Name	Description
System.Int32	tableID

Returns

Type	Description
System.String

GetTableOrView(String)

Declaration

public SchemaTableBase GetTableOrView(string tableName)

Parameters

Type	Name	Description
System.String	tableName

Returns

Type	Description
SchemaTableBase

GetTableOrViewByID(Int32)

Declaration

public SchemaTableBase GetTableOrViewByID(int typeID)

Parameters

Type	Name	Description
System.Int32	typeID

Returns

Type	Description
SchemaTableBase

GetTableOrViewID(String)

Declaration

public int GetTableOrViewID(string objectName)

Parameters

Type	Name	Description
System.String	objectName

Returns

Type	Description
System.Int32

GetTypeForSchemaType(SchemaFieldBase)

Declaration

public Type GetTypeForSchemaType(SchemaFieldBase field)

Parameters

Type	Name	Description
SchemaFieldBase	field

Returns

Type	Description
System.Type

GetTypeForSchemaType(SchemaFieldBase, DbProvider)

Declaration

public Type GetTypeForSchemaType(SchemaFieldBase field, DbProvider provider)

Parameters

Type	Name	Description
SchemaFieldBase	field
DbProvider	provider

Returns

Type	Description
System.Type

GetViewField(String, String)

Declaration

public SchemaViewField GetViewField(string viewName, string fieldName)

Parameters

Type	Name	Description
System.String	viewName
System.String	fieldName

Returns

Type	Description
SchemaViewField

GetViewID(String)

Declaration

public int GetViewID(string viewName)

Parameters

Type	Name	Description
System.String	viewName

Returns

Type	Description
System.Int32

InitCacheData()

Declaration

protected override object InitCacheData()

Returns

Type	Description
System.Object

Overrides

CacheBase.InitCacheData()

IsCacheOutOfDate(DateTime)

Declaration

protected override bool IsCacheOutOfDate(DateTime testDate)

Parameters

Type	Name	Description
System.DateTime	testDate

Returns

Type	Description
System.Boolean

Overrides

ClarifyCacheBase.IsCacheOutOfDate(DateTime)

IsChangeField(String, String)

Declaration

public bool IsChangeField(string tableName, string fieldName)

Parameters

Type	Name	Description
System.String	tableName
System.String	fieldName

Returns

Type	Description
System.Boolean

IsDateField(String, String)

Declaration

public bool IsDateField(string tableName, string fieldName)

Parameters

Type	Name	Description
System.String	tableName
System.String	fieldName

Returns

Type	Description
System.Boolean

IsFieldSearchable(String, String)

Declaration

public bool IsFieldSearchable(string tableName, string fieldName)

Parameters

Type	Name	Description
System.String	tableName
System.String	fieldName

Returns

Type	Description
System.Boolean

IsFieldUnicode(String, String)

Declaration

public bool IsFieldUnicode(string tableName, string fieldName)

Parameters

Type	Name	Description
System.String	tableName
System.String	fieldName

Returns

Type	Description
System.Boolean

IsIntegerField(String, String)

Declaration

public bool IsIntegerField(string tableName, string fieldName)

Parameters

Type	Name	Description
System.String	tableName
System.String	fieldName

Returns

Type	Description
System.Boolean

IsNumericField(String, String)

Declaration

public bool IsNumericField(string tableName, string fieldName)

Parameters

Type	Name	Description
System.String	tableName
System.String	fieldName

Returns

Type	Description
System.Boolean

IsRelationExclusive(String, String, out SchemaTableField, out SchemaTableField)

Declaration

public bool IsRelationExclusive(string tableName, string relationName, out SchemaTableField objIDField, out SchemaTableField tableField)

Parameters

Type	Name	Description
System.String	tableName
System.String	relationName
SchemaTableField	objIDField
SchemaTableField	tableField

Returns

Type	Description
System.Boolean

IsRelationMandatory(String, String)

Declaration

public bool IsRelationMandatory(string tableName, string relationName)

Parameters

Type	Name	Description
System.String	tableName
System.String	relationName

Returns

Type	Description
System.Boolean

IsStringField(String, String)

Declaration

public bool IsStringField(string tableName, string fieldName)

Parameters

Type	Name	Description
System.String	tableName
System.String	fieldName

Returns

Type	Description
System.Boolean

IsStringOrDateField(String, String)

Declaration

public bool IsStringOrDateField(string tableName, string fieldName)

Parameters

Type	Name	Description
System.String	tableName
System.String	fieldName

Returns

Type	Description
System.Boolean

IsValidField(String, String)

Declaration

public bool IsValidField(string objectName, string fieldName)

Parameters

Type	Name	Description
System.String	objectName
System.String	fieldName

Returns

Type	Description
System.Boolean

IsValidField(String, String, out Boolean)

Declaration

public bool IsValidField(string objectName, string fieldName, out bool isRelation)

Parameters

Type	Name	Description
System.String	objectName
System.String	fieldName
System.Boolean	isRelation

Returns

Type	Description
System.Boolean

IsValidRelation(String, String)

Declaration

public bool IsValidRelation(string tableName, string relName)

Parameters

Type	Name	Description
System.String	tableName
System.String	relName

Returns

Type	Description
System.Boolean

IsValidTable(String)

Declaration

public bool IsValidTable(string tableName)

Parameters

Type	Name	Description
System.String	tableName

Returns

Type	Description
System.Boolean

IsValidTableOrView(Int32)

Declaration

public bool IsValidTableOrView(int typeID)

Parameters

Type	Name	Description
System.Int32	typeID

Returns

Type	Description
System.Boolean

IsValidTableOrView(String)

Declaration

public bool IsValidTableOrView(string objectName)

Parameters

Type	Name	Description
System.String	objectName

Returns

Type	Description
System.Boolean

IsValidView(String)

Declaration

public bool IsValidView(string viewName)

Parameters

Type	Name	Description
System.String	viewName

Returns

Type	Description
System.Boolean

LoadCacheData(Object)

Declaration

protected override void LoadCacheData(object cacheData)

Parameters

Type	Name	Description
System.Object	cacheData

Overrides

CacheBase.LoadCacheData(Object)

SetNameAndParameters(String, String)

Declaration

protected override void SetNameAndParameters(string name, string parameters)

Parameters

Type	Name	Description
System.String	name
System.String	parameters

Overrides

CacheBase.SetNameAndParameters(String, String)

TryGetField(String, String)

Declaration

public SchemaFieldBase TryGetField(string objectName, string fieldName)

Parameters

Type	Name	Description
System.String	objectName
System.String	fieldName

Returns

Type	Description
SchemaFieldBase

TryIsFieldSearchable(String, String)

Declaration

public bool TryIsFieldSearchable(string tableName, string fieldName)

Parameters

Type	Name	Description
System.String	tableName
System.String	fieldName

Returns

Type	Description
System.Boolean

TryIsStringField(String, String)

Declaration

public bool TryIsStringField(string tableName, string fieldName)

Parameters

Type	Name	Description
System.String	tableName
System.String	fieldName

Returns

Type	Description
System.Boolean

UpdateCache()

Declaration

public override void UpdateCache()

Overrides

CacheBase.UpdateCache()

Events

SchemaLoadStatusChanged

Declaration

public event SchemaLoadStatusEventHandler SchemaLoadStatusChanged

Event Type

Type	Description
SchemaLoadStatusEventHandler

Explicit Interface Implementations

ISchemaCache.GetChangeDateField(String)

Declaration

ISchemaField ISchemaCache.GetChangeDateField(string tableName)

Parameters

Type	Name	Description
System.String	tableName

Returns

Type	Description
ISchemaField

ISchemaCache.GetDateFields(String)

Declaration

IEnumerable ISchemaCache.GetDateFields(string tableName)

Parameters

Type	Name	Description
System.String	tableName

Returns

Type	Description
System.Collections.IEnumerable

ISchemaCache.GetField(String, String)

Declaration

ISchemaField ISchemaCache.GetField(string objectName, string fieldName)

Parameters

Type	Name	Description
System.String	objectName
System.String	fieldName

Returns

Type	Description
ISchemaField

ISchemaCache.GetRelation(String, String)

Declaration

ISchemaRelation ISchemaCache.GetRelation(string tableName, string relationName)

Parameters

Type	Name	Description
System.String	tableName
System.String	relationName

Returns

Type	Description
ISchemaRelation

ISchemaCache.GetTableName(Int32)

Declaration

string ISchemaCache.GetTableName(int tableNum)

Parameters

Type	Name	Description
System.Int32	tableNum

Returns

Type	Description
System.String

ISchemaCache.GetTableNumber(String)

Declaration

int ISchemaCache.GetTableNumber(string tableName)

Parameters

Type	Name	Description
System.String	tableName

Returns

Type	Description
System.Int32

ISchemaCache.IsChangeField(String, String)

Declaration

bool ISchemaCache.IsChangeField(string tableName, string fieldName)

Parameters

Type	Name	Description
System.String	tableName
System.String	fieldName

Returns

Type	Description
System.Boolean

ISchemaCache.IsDateField(String, String)

Declaration

bool ISchemaCache.IsDateField(string tableName, string fieldName)

Parameters

Type	Name	Description
System.String	tableName
System.String	fieldName

Returns

Type	Description
System.Boolean

ISchemaCache.IsFieldSearchable(String, String)

Declaration

bool ISchemaCache.IsFieldSearchable(string tableName, string fieldName)

Parameters

Type	Name	Description
System.String	tableName
System.String	fieldName

Returns

Type	Description
System.Boolean

ISchemaCache.IsFieldUnicode(String, String)

Declaration

bool ISchemaCache.IsFieldUnicode(string tableName, string fieldName)

Parameters

Type	Name	Description
System.String	tableName
System.String	fieldName

Returns

Type	Description
System.Boolean

ISchemaCache.IsIntegerField(String, String)

Declaration

bool ISchemaCache.IsIntegerField(string tableName, string fieldName)

Parameters

Type	Name	Description
System.String	tableName
System.String	fieldName

Returns

Type	Description
System.Boolean

ISchemaCache.IsNumericField(String, String)

Declaration

bool ISchemaCache.IsNumericField(string tableName, string fieldName)

Parameters

Type	Name	Description
System.String	tableName
System.String	fieldName

Returns

Type	Description
System.Boolean

ISchemaCache.IsRelationExclusive(String, String)

Declaration

bool ISchemaCache.IsRelationExclusive(string tableName, string relationName)

Parameters

Type	Name	Description
System.String	tableName
System.String	relationName

Returns

Type	Description
System.Boolean

ISchemaCache.IsStringField(String, String)

Declaration

bool ISchemaCache.IsStringField(string tableName, string fieldName)

Parameters

Type	Name	Description
System.String	tableName
System.String	fieldName

Returns

Type	Description
System.Boolean

ISchemaCache.IsStringOrDateField(String, String)

Declaration

bool ISchemaCache.IsStringOrDateField(string tableName, string fieldName)

Parameters

Type	Name	Description
System.String	tableName
System.String	fieldName

Returns

Type	Description
System.Boolean

ISchemaCache.IsValidField(String, String)

Declaration

bool ISchemaCache.IsValidField(string objectName, string fieldName)

Parameters

Type	Name	Description
System.String	objectName
System.String	fieldName

Returns

Type	Description
System.Boolean

ISchemaCache.IsValidTable(String)

Declaration

bool ISchemaCache.IsValidTable(string tableName)

Parameters

Type	Name	Description
System.String	tableName

Returns

Type	Description
System.Boolean

ISchemaCache.IsValidTableOrView(String)

Declaration

bool ISchemaCache.IsValidTableOrView(string objectName)

Parameters

Type	Name	Description
System.String	objectName

Returns

Type	Description
System.Boolean

ISchemaCache.IsValidView(String)

Declaration

bool ISchemaCache.IsValidView(string viewName)

Parameters

Type	Name	Description
System.String	viewName

Returns

Type	Description
System.Boolean

ISchemaCache.Tables

Declaration

ISchemaTableCollection ISchemaCache.Tables { get; }

Returns

Type	Description
ISchemaTableCollection

ISchemaCache.Views

Declaration

ISchemaViewCollection ISchemaCache.Views { get; }

Returns

Type	Description
ISchemaViewCollection

Implements

ISchemaCache