NET Caching Library Help
SqlServerDatabaseProvider Class Members
Properties  Methods 


KellermanSoftware.NetCachingLibrary.DatabaseProviders Namespace : SqlServerDatabaseProvider Class

The following tables list the members exposed by SqlServerDatabaseProvider.

Public Constructors
 NameDescription
Public ConstructorInitializes a new instance of the SqlServerDatabaseProvider class.  
Top
Public Properties
 NameDescription
Public Property Get a reference to the database connection (Inherited from KellermanSoftware.NetCachingLibrary.DatabaseProviders.BaseDatabaseProvider)
Public Property The connection string (Inherited from KellermanSoftware.NetCachingLibrary.DatabaseProviders.BaseDatabaseProvider)
Public PropertyOverridden.  A character prefix for parameters such as @ for SQL Server  
Top
Public Methods
 NameDescription
Public Method Begin a new transaction (Inherited from KellermanSoftware.NetCachingLibrary.DatabaseProviders.BaseDatabaseProvider)
Public Method Close the database connection (Inherited from KellermanSoftware.NetCachingLibrary.DatabaseProviders.BaseDatabaseProvider)
Public Method Commit the current transaction (Inherited from KellermanSoftware.NetCachingLibrary.DatabaseProviders.BaseDatabaseProvider)
Public MethodOverridden.  Create new database  
Public MethodOverridden.  Check database existance  
Public Method Close the connection on Dispose (Inherited from KellermanSoftware.NetCachingLibrary.DatabaseProviders.BaseDatabaseProvider)
Public MethodOverloaded.  Execute the passed query and return the number of affected records (Inherited from KellermanSoftware.NetCachingLibrary.DatabaseProviders.BaseDatabaseProvider)
Public MethodOverloaded.  Execute a query and return a single value (Inherited from KellermanSoftware.NetCachingLibrary.DatabaseProviders.BaseDatabaseProvider)
Public MethodOverridden.  Get the current date of the database server  
Public MethodOverridden.  Get the sql to truncate a table.  
Public Method Insert into a table (Inherited from KellermanSoftware.NetCachingLibrary.DatabaseProviders.BaseDatabaseProvider)
Public MethodOverloaded.  Get a list of records using the passed SQL (Inherited from KellermanSoftware.NetCachingLibrary.DatabaseProviders.BaseDatabaseProvider)
Public Method Open the database connection (Inherited from KellermanSoftware.NetCachingLibrary.DatabaseProviders.BaseDatabaseProvider)
Public MethodOverloaded.  Returns true if the record exists (Inherited from KellermanSoftware.NetCachingLibrary.DatabaseProviders.BaseDatabaseProvider)
Public Method Perform a rollback of the current transaction (Inherited from KellermanSoftware.NetCachingLibrary.DatabaseProviders.BaseDatabaseProvider)
Public MethodOverridden.  Returns true if the table exists  
Public Method Delete all the records from a table (Inherited from KellermanSoftware.NetCachingLibrary.DatabaseProviders.BaseDatabaseProvider)
Public Method Updates the specified table name. (Inherited from KellermanSoftware.NetCachingLibrary.DatabaseProviders.BaseDatabaseProvider)
Top
Protected Methods
 NameDescription
Protected Method Adds parameters to the given command (Inherited from KellermanSoftware.NetCachingLibrary.DatabaseProviders.BaseDatabaseProvider)
Protected Method Creates new command with the given sql (Inherited from KellermanSoftware.NetCachingLibrary.DatabaseProviders.BaseDatabaseProvider)
Protected Method Creates new connection (Inherited from KellermanSoftware.NetCachingLibrary.DatabaseProviders.BaseDatabaseProvider)
Protected Method Gets records using the given command (Inherited from KellermanSoftware.NetCachingLibrary.DatabaseProviders.BaseDatabaseProvider)
Protected Method 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