The System.Diagnostics.EventLog class allows you to programmatically read and write to the Windows Event log.  This functionality allows you to read and write your application logs to the Windows Event Log rather than writing these log entries to a text-based file.  This logging methodology provides a quick, easy, and performance friendly way to log any type of event.  The EventLog class extends beyond simply writing log entries (reading from logs, creating/deleting event sources, deleting logs, etc.) but this article is geared specifically toward writing to the Windows Event Log.

[Read more...]

The DNN Event Viewer and its hooks provide functionality that are extremely extensible allowing developers to quickly incorporate event logging into their application (custom modules) by utilizing the DNN Core Framework.  Writing to the DNN Event Log provides portal administrators with a friendly and unified interface to track trival, minor, and major events of all varieties (success or failure).

[Read more...]

Essentially a foreign key means that values in one table must also appear in another table. Generally the referenced table is called the parent table while the table with the foreign key is called the child table. The foreign key in the child table will generally reference a primary key in the parent table. To expand this concept a foreign key with a cascade delete means that if a record in the parent table is deleted, then the corresponding record or records in the child table with automatically be deleted. This is referred to as a cascade delete. A foreign key with a cascade delete can be defined in one of two ways either with a CREATE TABLE statement or with an ALTER TABLE statement.

[Read more...]

Introduced in SQL Server 2005 , a Common Table Expressions (CTE) is a "temporary result set" that exists only within the scope of a single SQL statement. It allows access to functionality within that single SQL statement that was previously only available through use of functions, temporary tables, and cursors.

[Read more...]

Encrypting sections of your applications web.config file helps to improve the security of your application by replacing plain text sections of your application configuration with encrypted ones. You can use aspnet_regiis.exe to encrypt sections of the web.config file and ASP.NET can natively decrypt theses sections and process the file normally, all occuring without the need to write additional lines of code.

[Read more...]