| Name | Description | |
|---|---|---|
 | MySqlTarget Constructor | Default constructor |
The following tables list the members exposed by MySqlTarget.
Public Constructors
Public Properties
| Name | Description | |
|---|---|---|
 | AnyFilters | Used internally for performance. Returns true if there is any filter defined for this target. (Inherited from KellermanSoftware.NetLoggingLibrary.Targets.BaseTarget) |
| AssemblyNameFilter | If specified, only log for a specific assembly name It is possible to use multiple assemblies delimited by a comma and the asterisk wildcard. (Inherited from KellermanSoftware.NetLoggingLibrary.Targets.BaseTarget) |
| AutoCreateStoredProcedure | If true, the stored procedure for logging will be created if it does not exist for the first logging message. The default is true. |
| AutoCreateTable | If true, the logging table will be automatically created if it does not exist when the first message is logged. The default is true. |
| BufferSize | When a logging target is wrapped by a BufferedWrapper, this is how often messages are committed (Inherited from KellermanSoftware.NetLoggingLibrary.Targets.BaseTarget) |
| ClassNameFilter | If specified, only log for a specific class name It is possible to use multiple classes delimited by a comma and the asterisk wildcard. (Inherited from KellermanSoftware.NetLoggingLibrary.Targets.BaseTarget) |
| Connection | Overridden. Get or set the connection for the database |
| ConnectionString | Get or set the connection string (Inherited from KellermanSoftware.NetLoggingLibrary.Targets.BaseDatabaseTarget) |
| DateFormat | The date format for the LogTime variable. See the Date Format topic in the Basic Tasks Section of the Help File (Inherited from KellermanSoftware.NetLoggingLibrary.Targets.BaseTarget) |
| LogCount | The number of messages that have been logged for this logger (Inherited from KellermanSoftware.NetLoggingLibrary.Targets.BaseTarget) |
| MachineNameFilter | If specified, logging will only occur for the specific machine name It is possible to use multiple machines delimited by a comma and the asterisk wildcard. (Inherited from KellermanSoftware.NetLoggingLibrary.Targets.BaseTarget) |
| MaxEntries | Get or set the maximum number of entries before discarding of oldest entries occurs. Set to zero to disable. (Inherited from KellermanSoftware.NetLoggingLibrary.Targets.BaseDatabaseTarget) |
| MessageFormat | What to output in the log. See the Message Format topic in the Basic Tasks Section of the Help File (Inherited from KellermanSoftware.NetLoggingLibrary.Targets.BaseTarget) |
| MethodNameFilter | If specified, only log for a specific method name It is possible to use multiple methods delimited by a comma and the asterisk wildcard. (Inherited from KellermanSoftware.NetLoggingLibrary.Targets.BaseTarget) |
| MinimumLevel | The minimum logging level to log a message (Inherited from KellermanSoftware.NetLoggingLibrary.Targets.BaseTarget) |
| Mode | Defines which mode to use for the target; Synchronous, Buffered, or Asynchronous. The default is Synchronous. (Inherited from KellermanSoftware.NetLoggingLibrary.Targets.BaseTarget) |
| Name | The name of the logger (Inherited from KellermanSoftware.NetLoggingLibrary.Targets.BaseTarget) |
| NamespaceFilter | If specified, only log for a specific namespace. It is possible to use multiple namespaces delimited by a comma and the asterisk wildcard. (Inherited from KellermanSoftware.NetLoggingLibrary.Targets.BaseTarget) |
| StoredProcedureName | The name of the stored procedure. The default is SPINSERTTBLLOG |
| TableName | Overridden. Get or set the table name. Defaults to tblLog |
| ThreadNameFilter | If specified, logging will only occur for the thread id or thread name specified It is possible to use multiple thread names delimited by a comma and the asterisk wildcard. (Inherited from KellermanSoftware.NetLoggingLibrary.Targets.BaseTarget) |
| UserNameFilter | If specified, logging will only occur for the specific user name It is possible to use multiple users delimited by a comma and the asterisk wildcard. (Inherited from KellermanSoftware.NetLoggingLibrary.Targets.BaseTarget) |
Public Methods
| Name | Description | |
|---|---|---|
 | ClearLog | Delete all the records in the logging table (Inherited from KellermanSoftware.NetLoggingLibrary.Targets.BaseDatabaseTarget) |
| ClearTable | Overridden. Clear the database table |
| CloseConnection | Close the connection to the database if it is open (Inherited from KellermanSoftware.NetLoggingLibrary.Targets.BaseDatabaseTarget) |
| CreateStoredProcedure | Create a stored procedure to perform logging |
| CreateTable | Create a logging table |
| Dispose | Overloaded. Clear asynchronous queue and close connections (Inherited from KellermanSoftware.NetLoggingLibrary.Targets.BaseDatabaseTarget) |
| Flush | Wait to write out buffered and asynchronous targets (Inherited from KellermanSoftware.NetLoggingLibrary.Targets.BaseTarget) |
| FormatMessage | Format a message with all selected options for the target (Inherited from KellermanSoftware.NetLoggingLibrary.Targets.BaseTarget) |
| GetIdentity | Get the last identity inserted for the current connection |
| GetIdentitySql | Get the SQL used to get the last identity inserted |
| InsertLogRecord | Overridden. Log a message to the database table |
| LogMessage | Log a message to a database table (Inherited from KellermanSoftware.NetLoggingLibrary.Targets.BaseDatabaseTarget) |
| OpenConnection | Overridden. Open the database connection |
| StoredProcedureExists | Returns true if the stored procedure exists |
| TableExists | Returns true if the table exists |
Protected Methods
| Name | Description | |
|---|---|---|
 | Initialize | Verify that the connection string and table name is set (Inherited from KellermanSoftware.NetLoggingLibrary.Targets.BaseDatabaseTarget) |
| ProcessField | Post processing of formatting a message for each field (Inherited from KellermanSoftware.NetLoggingLibrary.Targets.BaseTarget) |
See Also