Database schema and table structure?

[ozzioma]

Hi,

Thanks for the awesome work!
I have not been able to open the attached database file (FileManager.mdf).
Either using Visual Studio 2019 or SSMS, they both fail with incompatibility error messages.

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

Could help with the sql schema script?

Thanks

[npirlot]

Hi,

If this can be of help, here's the structure I found opening the mdf file:

Note the table is named "Product"...

Bonne journée :)

[ozzioma]

Thanks man.

I figured that out after digging through the web.
Apparently was a LocalDb issue.

Were you able to get it working?
Dunno why EF Core was not chosen for this feature.

[npirlot]

I did get it working, in a project using EF core but had to do quite a bit of adaptation. A clean EF core version of the controller would be better. I encountered an issue (raised on this repo #11 ) when there is no data in the table at all, more specifically if there is no root folder. My work-around hack was to automatically create a root directory in the GetList method if there is none.

[npirlot]

Hi @ozzioma I realised some fairly risky inconsistencies in the mixed use of SQL data & temp dir on host - see new issue #12 I have created.

[ozzioma]

@npirlot
I wasted or rather spent lots of productive days and weeks poring over the DB file provider, local File provider and Azure Storage provider.
Dunno if it's ok to comment on products that a commercial vendor has provided for free (for which I'm grateful!)....but the quality could be better.
I'm sure the Syncfusion devs are working hard to make their code samples simpler and more bug free for adopters.
Made a decision to skip the FileManager component for now, time constraints won't let me get down to making it work as expected.

Pity tho.