![](bmp/CLASSHEADER.gif)
Log adapter that writes to a SQL Server Database
Westwind.Utilities.Logging.SqlLogAdapter
public class SqlLogAdapter : object, ILogAdapter
Class Members
Member | Description | |
---|---|---|
![]() |
Constructor |
Must pass in a SQL Server connection string or config ConnectionString Id. |
![]() ![]() |
STR_ApplicationWebLogCreateStatement |
|
![]() |
Clear |
Clears all the records of the log table public sealed bool Clear() public sealed bool Clear(int countToLeave) public sealed bool Clear(decimal daysToDelete) |
![]() |
CreateLog |
Creates a new log table in the current database. If the table exists already it is dropped and recreated. public sealed bool CreateLog() |
![]() |
DeleteLog |
Deletes the Sql Log Table public sealed bool DeleteLog() |
![]() |
GetEntries |
Returns entries for a given error level, and date range public sealed IDataReader GetEntries(ErrorLevels errorLevel, int count, DateTime? dateFrom, DateTime? dateTo, string fieldList) |
![]() |
GetEntry |
Returns an individual Web log entry from the log table public sealed WebLogEntry GetEntry(int id) |
![]() |
GetEntryCount |
Returns the number of total log entries public sealed int GetEntryCount(ErrorLevels errorLevel) |
![]() |
GetEntryList |
public sealed IEnumerable |
![]() |
WriteEntry |
Writes a new Web specific entry into the log file public sealed bool WriteEntry(WebLogEntry entry) |
![]() |
ConnectionString |
|
![]() |
LogFilename |
The name of the table that data in SQL Server is written to |
Requirements
Namespace: Westwind.Utilities.LoggingAssembly: westwind.utilities.dll
© West Wind Technologies, 1996-2016 • Updated: 12/12/15
Comment or report problem with topic