Table of Contents

Class SqlCache

Namespace
Tripous.Data
Assembly
Tripous.Data.dll

A cache of DataTable instances, containing schema of a named sql statement, per connection.

public static class SqlCache
Inheritance
SqlCache
Inherited Members

Methods

Add(string, string, DataTable)

Adds a schema DataTable to the cache.

public static void Add(string ConnectionName, string StatementName, DataTable SchemaTable)

Parameters

ConnectionName string
StatementName string
SchemaTable DataTable

Clear()

Clears the entire cache.

public static void Clear()

Contains(string, string)

Returns true if there is a DataTable with schema information of a Sql statement specified by a name, under a connection specified by name.

public static bool Contains(string ConnectionName, string StatementName)

Parameters

ConnectionName string
StatementName string

Returns

bool

Find(string, string)

Finds and returns a schema DataTable if any, else null.

public static DataTable Find(string ConnectionName, string StatementName)

Parameters

ConnectionName string
StatementName string

Returns

DataTable