Log In
Home
Support
Demos
Documentation
Blogs
Training
Webinars
[Expand]General Information
[Expand]WinForms Controls
[Collapse]ASP.NET Controls and MVC Extensions
 [Expand]Prerequisites
 [Expand]What's Installed
 [Expand]Common Concepts
 [Collapse]ASP.NET WebForms Controls
  [Expand]Reporting
  [Expand]Chart Control
  [Expand]Grid View
  [Expand]Card View
  [Expand]Vertical Grid
  [Expand]Spreadsheet
  [Expand]Rich Text Editor
  [Expand]Image and Data Browsing
  [Expand]Docking and Popups
  [Expand]Site Navigation and Layout
  [Collapse]File Management
   [Expand]Product Information
   [Collapse]File Manager
     ASPxFileManager Overview
    [Expand]Concepts
    [Expand]Visual Elements
    [Expand]Member Tables
    [Collapse]Examples
      How to: Implement a LINQ to SQL Based File System Provider
      How to: Specify the File Manager Root Folder
   [Expand]File Upload
  [Expand]Multi-Use Site Controls
  [Expand]Scheduler
  [Expand]HTML Editor
  [Expand]Pivot Grid
  [Expand]Tree List
  [Expand]Gauges
  [Expand]Data Editors
  [Expand]Spell Checker
  [Expand]Query Builder
 [Expand]ASP.NET MVC Extensions
 [Expand]Localization
 [Expand]Redistribution and Deployment
  Get More Help
 [Expand]API Reference
[Expand]ASP.NET Bootstrap Controls
[Expand]ASP.NET Core Bootstrap Controls
[Expand]WPF Controls
[Expand]Xamarin Controls
[Expand]Windows 10 App Controls
[Expand]Document Server
[Expand]Reporting
[Expand]Report Server
[Expand]Dashboard
[Expand]eXpressApp Framework
[Expand]CodeRush
[Expand]CodeRush Classic
[Expand]Cross-Platform Core Libraries
[Expand]Tools and Utilities
 End-User Documentation

How to: Implement a LINQ to SQL Based File System Provider

Show Me

A complete sample project is available in the DevExpress Code Examples database at http://www.devexpress.com/example=E2900.

This example shows how to create a LINQ to SQL based file system provider for the ASPxFileManager. The provider retrieves data from DataContext connected to a database containing file/folder structure and contents. To improve performance, we do the following:

- Cache a folder list in memory to decrease the number of recursive LINQ to SQL queries made to a database (see the FolderCache property and the RefreshFolderCache method).

- Use delayed loading for the Data property mapped to a database field that stores file contents (the Delay Loaded property is set to True for this property in the DbFileSystemItem entity class).

See also:

E5024: ASPxFileManager - How to implement a List data bound custom file system provider

How would you rate this topic?​​​​​​​