search

syncfusion / blazor-samples

Explore and learn Syncfusion Blazor components using large collection of demos, example applications and tutorial samples
https://blazor.syncfusion.com/
294 stars 151 forks source link

File manager db/table structure #97

Closed ozzioma closed 4 years ago

ozzioma commented 4 years ago

Hi,

Thanks for the awesome work! I have not been able to open the attached database file for the FileManager control (FileManager.mdf). Either using Visual Studio 2019 or SSMS, they both fail with incompatibility error messages. I'm talking about the source code from the ej2-sql provider repo.

Also there is no sql schema file or script included to recreate the table structure.

Could help with the sql schema script?

Thanks

SowmiyaPadmanaban commented 4 years ago

Hi Ozzioma,

We have checked your reported query on SQL file provider service application. Please, refer the below steps to open the MDF file in Visual Studio 2019.

  1. Download our SQL file provider for our FileManager component in this link.

  2. Open the project in Visual Studio 2019. And then click the View-> Server Explorer in the toolbar of Visual Studio 2019.

image1

  1. It shows the MDF file in the left side of your application then navigate to the products table inside the tables folder and then right click the product tables. Then, click on the show Table Data item. It will show the entire data (Files/ folder) used for rendering our FileManager component.

image2

  1. Refer the below screenshot.

image3

  1. Refer the following attached video for opening and editing the SQL table.

    https://www.syncfusion.com/downloads/support/directtrac/general/ze/ScreenCapture_7-3-2020_8.24.59_PM.mp4753638318.zip

You can add custom columns based on your requirement in SQL table of MDF file. But, the default columns specified in that table should not be modified. Because, all the columns must be necessary to render the FileManager component. We have prepared the table with specified columns to serve data to the client side based on the required JSON structure from File Manager. When modifying the default column value, FileManager functionalities will not working properly.

The following links will help you to understand in which JSON structure, the responses and requests of has to be send to the File Manager component.

https://blazor.syncfusion.com/documentation/file-manager/file-operations/

Refer the below sample link for File Manager sample with SQL file provider.

https://www.syncfusion.com/downloads/support/directtrac/general/ze/BlazorApp1-593718957.zip

Check out the following links to know more about FileManager component.

Documentation: https://blazor.syncfusion.com/documentation/file-manager/getting-started/

Demos: https://blazor.syncfusion.com/demos/file-manager/overview/

Please let us know, if you need any further assistance.

Regards, Sowmiya.P

thirukumaran-murugan commented 4 years ago

We are closing this issue since there is no recent activity. But feel free to re-open a closed issue if needed.