Skip to content

DevExpress-Examples/xaf-how-to-use-the-file-attachment-module-with-a-legacy-database

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

20 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

XAF - How to use the File Attachment Module with a legacy database

The File Attachments module ships with the capability to implement file upload and download functionality in your application. However, the built-in FileData class is persistent and therefore requires a separate table in the database to store file contents and names. This means you cannot use this class for XAF applications that work with a legacy database where a file is stored in a BLOB field of the table with other fields of the same object in a plain form - the same object may contain multiple BLOB fields for different files.

Implementation Details

To execute this and similar scenarios, you can create a non-persistent class that implements the IFileData interface. This example demonstrates a possible IFileData implementation in a non-persistent class that passes data to/from the owner persistent object where the BLOB (byte[]) property is declared.

Important notes:

  • Since the IFileData implementor class is not persistent, the object space cannot create its instances, and we create the only instance in the persistent class constructor.
  • The IFileData property must have a setter to allow uploading files in Blazor.
  • In this example, the file name is not stored in the object but is generated from the object key value. It is only used when the file is downloaded.

This example demonstrates only one possible solution. If you need to cover a different scenario, you can extend this solution or create your own.

Files to Review

Documenation

Does this example address your development requirements/objectives?

(you will be redirected to DevExpress.com to submit your response)