NET Caching Library Help
SqlServerDatabaseProvider Class Methods


KellermanSoftware.NetCachingLibrary.DatabaseProviders Namespace : SqlServerDatabaseProvider Class

For a list of all members of this type, see SqlServerDatabaseProvider members.

Public Methods
 NameDescription
Public MethodBeginTransaction Begin a new transaction (Inherited from KellermanSoftware.NetCachingLibrary.DatabaseProviders.BaseDatabaseProvider)
Public MethodCloseConnection Close the database connection (Inherited from KellermanSoftware.NetCachingLibrary.DatabaseProviders.BaseDatabaseProvider)
Public MethodCommitTransaction Commit the current transaction (Inherited from KellermanSoftware.NetCachingLibrary.DatabaseProviders.BaseDatabaseProvider)
Public MethodCreateDatabaseOverridden.  Create new database  
Public MethodDatabaseExistsOverridden.  Check database existance  
Public MethodDispose Close the connection on Dispose (Inherited from KellermanSoftware.NetCachingLibrary.DatabaseProviders.BaseDatabaseProvider)
Public MethodExecuteNonQueryOverloaded.  Execute the passed query and return the number of affected records (Inherited from KellermanSoftware.NetCachingLibrary.DatabaseProviders.BaseDatabaseProvider)
Public MethodExecuteScalarOverloaded.  Execute a query and return a single value (Inherited from KellermanSoftware.NetCachingLibrary.DatabaseProviders.BaseDatabaseProvider)
Public MethodGetDatabaseServerDateOverridden.  Get the current date of the database server  
Public MethodGetTruncateSqlOverridden.  Get the sql to truncate a table.  
Public MethodInsert Insert into a table (Inherited from KellermanSoftware.NetCachingLibrary.DatabaseProviders.BaseDatabaseProvider)
Public MethodLoadOverloaded.  Get a list of records using the passed SQL (Inherited from KellermanSoftware.NetCachingLibrary.DatabaseProviders.BaseDatabaseProvider)
Public MethodOpenConnection Open the database connection (Inherited from KellermanSoftware.NetCachingLibrary.DatabaseProviders.BaseDatabaseProvider)
Public MethodRecordExistsOverloaded.  Returns true if the record exists (Inherited from KellermanSoftware.NetCachingLibrary.DatabaseProviders.BaseDatabaseProvider)
Public MethodRollbackTransaction Perform a rollback of the current transaction (Inherited from KellermanSoftware.NetCachingLibrary.DatabaseProviders.BaseDatabaseProvider)
Public MethodTableExistsOverridden.  Returns true if the table exists  
Public MethodTruncateTable Delete all the records from a table (Inherited from KellermanSoftware.NetCachingLibrary.DatabaseProviders.BaseDatabaseProvider)
Public MethodUpdate Updates the specified table name. (Inherited from KellermanSoftware.NetCachingLibrary.DatabaseProviders.BaseDatabaseProvider)
Top
Protected Methods
 NameDescription
Protected MethodAddParameters Adds parameters to the given command (Inherited from KellermanSoftware.NetCachingLibrary.DatabaseProviders.BaseDatabaseProvider)
Protected MethodCreateCommand Creates new command with the given sql (Inherited from KellermanSoftware.NetCachingLibrary.DatabaseProviders.BaseDatabaseProvider)
Protected MethodCreateConnection Creates new connection (Inherited from KellermanSoftware.NetCachingLibrary.DatabaseProviders.BaseDatabaseProvider)
Protected MethodGetRecords Gets records using the given command (Inherited from KellermanSoftware.NetCachingLibrary.DatabaseProviders.BaseDatabaseProvider)
Protected MethodSetParameter Sets parameter using the given parameter value (Inherited from KellermanSoftware.NetCachingLibrary.DatabaseProviders.BaseDatabaseProvider)
Top
See Also

Reference

SqlServerDatabaseProvider Class
KellermanSoftware.NetCachingLibrary.DatabaseProviders Namespace
BaseDatabaseProvider Class

 

 

©2021. Kellerman Software. All Rights Reserved.

Product Website