Hide

YetaWF.DataProvider.SQLGeneric Package Documentation

YetaWF.DataProvider.SQLGeneric.SQLGenericManager<TYPE> Class

Used to retrieve information about databases, tables, columns.

To minimize startup time, we collect table names and column names as they are accessed the first time (lazy loading).

Some of this could be made async, but often this is called in a context that is not async. As this is all cached and most of it is only used during model install/uninstall, using non-async is just easier. The SQL queries used for model install/uninstall (like GetColumnInfo) are not very efficient. Simplicity over perfection.

Namespace: YetaWF.DataProvider.SQLGeneric
Assembly: YetaWF.DataProvider.SQLGeneric

Inheritance

System.Object

YetaWF.DataProvider.SQLGeneric.SQLGenericManager<TYPE>

Syntax

public abstract class SQLGenericManager<TYPE>;

Constructors

This class cannot be instantiated.

Fields

DBFIRST_PREFIX

When using a "Database First" approach, any index or foreign key whose name starts with this prefix will be ignored and remain untouched/unaltered by model updates.

Methods

	Equals	Determines whether the specified object is equal to the current object.
	Finalize	Allows an object to try to free resources and perform other cleanup operations before it is reclaimed by garbage collection.
	GetColumn	Returns column information for the specified column.
	GetColumnNames	Returns the column names given the SQL-specific connection information, database and table name. The contents are dependent on the SQL dataprovider used.
	GetColumns	Returns column information for all columns in the specified database table.
	GetColumnsCond	Returns column information for all columns in the specified database table.
	GetDatabase	Returns database information given a database name.
	GetDatabaseCond	Returns database information given a database name.
	GetDataBaseNames	Returns the database names given the SQL-specific connection information. The contents are dependent on the SQL dataprovider used.
	GetDataSource	Returns the data source. The contents are dependent on the SQL dataprovider used.
	GetHashCode	Serves as the default hash function.
	GetTable	Returns table information for the specified table.
	GetTableNames	Returns the table names given the SQL-specific connection information and database name. The contents are dependent on the SQL dataprovider used.
	GetTables	Returns table information for all tables in the specified database.
	GetType	Gets the Type of the current instance.
	HasTable	Returns whether the specified table exists.
	MemberwiseClone	Creates a shallow copy of the current Object.
	ReferenceEquals	Determines whether the specified Object instances are the same instance.
	ToString	Returns a string that represents the current object.