	Name	Description
	Connection	Get a reference to the database connection
	ConnectionString	The connection string
	DatabaseName	Returns database name
	DirtyReadClause	Get the clause to perform a dirty read after the table name. Typically (nolock)
	FriendlyProviderName	Get a friendly name for the provider
	IsConnectionOpen	True if the connection is open
	IsFileBasedDatabase	If true, the database is a single file based database such as MS Access, SQLite, VistaDB
	IsInTransaction	True if we are inside a transaction
	LicenseKey	The license key for the license
	ParameterPrefix	A character prefix for parameters such as @ for SQL Server
	SupportComments	Returns true if the provider supports comments
	Transaction	Get a reference to the current transaction
	UserName	The user name for the license

	Name	Description
	BeginTransaction	Begin a new transaction
	BuildDatabaseSpecificConnectionString	Build a connection string based on the passed in database
	ChangeDatabase	Change database.
	ClearLog	Overloaded. Clear the file log
	CloseConnection	Close the database connection
	CommitTransaction	Commit the current transaction
	ConnectionValid	Opens and closes the connection to ensure it is valid.
	CountRecordsInTable	Get the number of records in a table
	CreateDatabase	Create new database
	DatabaseExists	Check database existance
	DisableLogging	Disable all logging
	Dispose	Close the connection on Dispose
	DropTable	Drop (remove) a table from the database
	EnableLogging	Overloaded. Log to the console
	ExecuteNonQuery	Overloaded. Execute the passed query and return the number of affected records
	ExecuteScalar	Overloaded. Execute the passed query and return the first column of the first row
	FillDataTable	Overloaded. Fill a data table with the passed sql and parameters
	ForeignKeyExists	Returns true if the Foreign Key Exists
	GetAddColumnSql	Get the SQL for adding a column to an existing table
	GetAllForeignKeyConstraints	Get all constraints for the current database
	GetColumnDefinitionSql	Get portion of SQL used for the column definition for add column and create table sql
	GetCommentLine	Get sql comment using the given comment text
	GetCommentSeparatorLine	Get comment separator line
	GetCreateSequenceSql	Get the sql to create sequence
	GetCreateTableSql	Get the SQL for creating a table with the primary key
	GetCreateTableSqlWithCompositeKey	Get the SQL for creating a table with composite keys
	GetCreateTableSqlWithPrimaryKey	Get the SQL for creating a table with a primary key
	GetCreateTablesSql	Get the SQL to create the tables
	GetCreateTriggerSql	Get the sql to create trigger
	GetDatabaseNameFromConnectionString	Get database name from the connection string.
	GetDatabases	Get a list of databases for the current database server
	GetDatabaseServerDate	Get the date of the database server
	GetDatabaseTables	Get a list of tables in the current database
	GetDatabaseTypeForDbType	Get the database field type for the passed standard DbType
	GetDataTable	Overloaded. Get a datatable from the passed sql
	GetDbType	Get a DbType associated with a string from a database
	GetDbTypeForClrType	Get the DbType for provided ClrType
	GetDropSequenceSql	Get the sql to drop a sequence
	GetDropTableSql	Get the sql to drop a table
	GetDropTriggerSql	Get the sql to drop a trigger
	GetFieldType	Get a .NET type associated with a string from a database
	GetMaxPrimaryKey	Get the maximum value for the primary key
	GetMaxPrimaryKeySql	Get the SQL required to get the maximum value of the primary key
	GetServerNameFromConnectionString	Get the server name from the connection string
	GetTruncateSql	Get the sql to truncate a table.
	GetUpdateTablesSql	Get the SQL to update the tables
	Load	Overloaded. Get a list of records using the passed SQL
	LoadOne	Overloaded. Get a single record from a table with a parameterized where clause
	LoadPage	Get a page of records for a table
	LoadTop	Overloaded. Get a limited number of records for a table
	MarkForeignKeys	Mark foreign key columns by convention
	MarkPrimaryKey	Mark Primary Key in a table
	MarkPrimaryKeys	Mark primary key columns by convention
	OpenConnection	Open the database connection
	RecordExists	Overloaded. Returns true if the record exists
	RollbackTransaction	Perform a rollback of the current transaction
	TableExists	Returns true if the passed table exists in the database
	TruncateTable	Delete all the records from a table
	Wrap	Wrap a table name or field name in square brackets

	Name	Description
	AddConstraints	Add constraints.
	AddForeignKeyConstraints	Adds the foreign key constraints.
	AddOtherFieldsThanPrimaryKey	Build the sql for fields other than the primary key
	AddParameters	Adds parameters to the given command
	BuildTopRecordsSql	Builds the top records SQL.
	CreateCommand	Creates new command with the given command text
	CreateConnection	Creates new connection
	CreateDataAdapter	Creates data adapter using the given select command
	GetEndBatchSql	Get SQL for batch end
	GetPrimaryKeyColumnsForTable	Get the primary key columns for a table from the schema
	GetRecords	Gets records using the given command
	GetStartBatchSql	Get SQL for batch start
	InterceptSql	Intercept the SQL and change it with the passed parameters
	SetParameter	Sets parameter using the given parameter value

Reference