Search code examples
dotnetnukednn9

Is there a specific DNN Table which can be used to store Product Reviews or third party data?

I want to know if there is a specific DNN table in which I can store Product Reviews or any additional information?

Correct me if I am wrong, but I think at the moment you can only use ModuleSettings and TabSettings to achieve this?

Solution

  • I ended up using the SQLDataProvider from DNN to create a new Database table on the DNN database. I could've used our ERP database but this would've taken longer as I have to consult with other backend developers.

    IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'{databaseOwner}[{objectQualifier}ProductReviews]') AND type in (N'U'))
BEGIN
    CREATE TABLE {databaseOwner}[{objectQualifier}ProductReviews](
        ReviewID int IDENTITY(1,1) PRIMARY KEY,     
        SKU varchar(255),
        ReviewText varchar(255),
        DatePosted DATETIME,        
        RatingValue int,
        Author varchar(255),
        Show int
) 
END