Background to question:
I am developing an app using MFC that needs embeded database. Initially I started using SQL server compact, but I had issues with creating passworded new database programatically, so I dumped it.
Next, I decided to use SQLite, but discovered it doesn't support passwording, at least not with native C/C++, so I wrote codes to encrypt strings values before writing them into database and codes for decrypting them after reading from database.
Now my concern is that , although the string content of my database cannot be determined anybody with appropriate software can access the database base and see all tables and fields in them and value of integer fields. More disturbing is the belief that such person can follow the design of the software by studying the databases' fields' and tables. In short, I dont want people to access my database again.
On noticing that .NET allows passwording of SQLite database using system.data.sqlite3.dll I decided to quickly learn C++/CLI.
I have seen sample c# codes for passwording, changing passwords and removing passwords; and I believe that with a little effort I can write the C++/CLI equivalent( although I have never written such programs before ).
The goal is to use .NET to password the database, open the database and close the database, while retaining the old native C++ code lines that I have already invested so much time in.
I believe I can rewrite all the database access codes in C++/CLI but that will almost be the same as starting the project all over again.
End of background
According to
[
^] system.data.sqlite3.dll can be used with C/C++. Please how can these be done.
1. Does it mean that if I replace the Sqlite3.dll developed for C/C++ from
[
^] with system.data.sqlite3.dll from
[
^], my c++ code will still run seamlessly.
2. If the answer to above question is YES, if I use system.data.sqlite3.dll, since normal C/C++ #includes header files, how do I include these file with my code.
3. Is it possible for me, using system.data.sqlite3.dl, to use .Net to simply open the data base file, then continue the database access program in normal c++. (Problem is : I have already gone far with this project using natve C/C++.