Is it possible to access .DBC (VFP) databases through xSharp?

Jáder E. Souza · Post by **Jáder E. Souza** » Thu Aug 08, 2019 11:52 am

139/5000
Is it possible to access .DBC (VFP) databases through xSharp?
Is there any provider to access DBFs through Entity Framework Core?

robert · Post by **robert** » Thu Aug 08, 2019 1:09 pm

Jáder,

In the current RC (FOX subscribers only) and the upcoming public release you can open a DBC file as a normal DBF file using the DBFVP RDD.
This does not mean that all the relations etc. will be automatically maintained.
More support for DBC files will be added later.

Robert

Jáder E. Souza · Post by **Jáder E. Souza** » Thu Aug 08, 2019 2:36 pm

Robert, thank you!
Is there any provider to access DBFs through Entity Framework Core?

robert · Post by **robert** » Thu Aug 08, 2019 3:31 pm

Jáder,
There is not. At this moment we are focusing on making the product ready to support existing code.
We have looked into this and when there is enough demand for such a provider then we will add one later.

Robert

FoxProMatt · Post by **FoxProMatt** » Fri Aug 09, 2019 4:36 pm

...and the upcoming public release you can open a DBC file as a normal DBF file using the DBFVP RDD.

Once the release is publicly available, it would be nice to have a code sample (maybe a new blog post) that shows the exact lines of code that are required to open a DBF and loop over it to print or display a few of the fields the screen or in a simple dialog. Just a simple code example that VFP users can see the X# code and even copy-paste it onto a project and see it run.

I know you were just giving basic feedback, but the "using the DBFVFP RDD" will be a mystery to VFP folks, so I hope we can get a concrete "Getting Starting with X# and FoxPro DBF" document or example to tease VFPers into giving X# a test run.

robert · Post by **robert** » Fri Aug 09, 2019 8:31 pm

Matt,

That is a very good idea. I am also considering to do a small video to show how to do this and to explain the concept of RDDs in relation to the various DBF formats.

Robert

NEE4NEE · Post by **NEE4NEE** » Sat Aug 10, 2019 7:27 am

... and if possible please add the Password protection in dbf (like ms access and others)

robert · Post by **robert** » Sat Aug 10, 2019 9:20 am

Neeraj,
Do you mean that you want us to extend the DBF format to add password protection?
Or should we support an existing password protection system such as can be found in Harbour or as found in Successware's Six driver ?

Robert

NEE4NEE · Post by **NEE4NEE** » Mon Aug 12, 2019 9:04 am

Do you mean that you want us to extend the DBF format to add password protection?

YES

alanbourke · Post by **alanbourke** » Fri Aug 23, 2019 9:22 am

Adding password support to DBF files is a bad idea. It works (sort of) with Access because Access databases are monolithic, all the tables are in one MDB file.

An application using DBF files tends to have tens or hundreds of them. So how do you maintain the same password across all of them? What if there is a DBC involved, do you implement the password at DBC level?

If you need this sort of security then you should really be looking at a database server (Postgres, MSSQL, MYSQL, whatever).

Main menu