• Which the release of FS2020 we see an explosition of activity on the forun and of course we are very happy to see this. But having all questions about FS2020 in one forum becomes a bit messy. So therefore we would like to ask you all to use the following guidelines when posting your questions:

    • Tag FS2020 specific questions with the MSFS2020 tag.
    • Questions about making 3D assets can be posted in the 3D asset design forum. Either post them in the subforum of the modelling tool you use or in the general forum if they are general.
    • Questions about aircraft design can be posted in the Aircraft design forum
    • Questions about airport design can be posted in the FS2020 airport design forum. Once airport development tools have been updated for FS2020 you can post tool speciifc questions in the subforums of those tools as well of course.
    • Questions about terrain design can be posted in the FS2020 terrain design forum.
    • Questions about SimConnect can be posted in the SimConnect forum.

    Any other question that is not specific to an aspect of development or tool can be posted in the General chat forum.

    By following these guidelines we make sure that the forums remain easy to read for everybody and also that the right people can find your post to answer it.

Tools DB

Why not get the compiled library?

ScreenShot00136.png
 
Thanks for the tip John. I didn't know that was the one to use, I thought they would have a 64-bit version that I couldn't see anywhere.
 
Well 32 bit will work in both 32 bit and 64 bit environments. So unless you are creating your application entirely for 64 bit users then you would use a 32 bit library.
 
I'm just about ready to give up on that DB all together. I spent yesterday and some time today on it and I'm getting nowhere.
I got the DLL, installed SqliteAdmin, all that is cake. I created my DB with one table.

Then came the nightmare...installing a data provider and run time tools for VS2012.
After much reading I got and installed "sqlite-netFx45-setup-bundle-x86-2012-1.0.84.0.exe". I then added references to the DLL's in my project then I added a 'LINQ to Entities' item, the Sqlite provider was available. However after the process was finished the context.vb file was empty, only showing up an error in the file and I ended up with a bunch of errors regarding conflict between DB field names and implicit property names (underscore _PropName).

I did more research and found a newer version of the provider that I installed, "sqlite-netFx45-setup-bundle-x86-2012-1.0.94.0.exe" at http://system.data.sqlite.org/index.html/doc/trunk/www/downloads.wiki. It's the only file that mentions, "This is the only setup package that is capable of installing the design-time components for Visual Studio 2012."
With this one I could add a new a database connection in the VS Server Explorer but not a LINQ to Entities since the provider was not present in the list.
I also tried the file "sqlite-netFx45-setup-x86-2012-1.0.94.0.exe" from the same link to no avail.

My Packages.Config file show, "<package id="EntityFramework" version="6.1.1" targetFramework="net45" />"

I am out of solutions to try. Maybe it's something I'm missing like a reference although I have tried to reference all available DLL's.
Anyway, I really need help on this one as I am lost and about to give up.

Thanks
 
I don't use SQL databases for anything so I am not really able to offer advice.
 
You must log in or register to reply here.
Back
Top