Creating a database table with keys

As DNN is a database driven Content management system (CMS), it is likely your module will include one or more database Tables. A database table is used to hold information for your module. Similar to a spreadsheet, a table consists of columns called Fields and rows called Records. As we are creating a module called Employee, the fields in our table will hold employee information such as first and last name. Each record in the table will hold one employee.

One of the things that makes a database table more powerful than a simple spreadsheet is its ability to automatically validate the information in the records. For example, it is important that each employee record in the table has a unique value that identifies ...

Get DotNetNuke 5.4 Cookbook now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.