(Notes) Notes (2021)

Prepare to using VS2019 (SQLite, MSI-Installer and so on)

My old Windows has been dead and I was forced to reinstall all my windows working environment. Beginning of this process I have described in page Optimize windows performance by Junction and this is continue with Visual Studio.

MSI-installer

There are many new windows installers

but historically main windows installer is MSI-installer. I have a lot of programs what need only updates and can not opportunity to change installer. And of course stupid Microsoft dude does not include MSI-installer to Visual Studio 2019. Therefore first task to prepare Visual Studio to practical use is adding MSI-installer (vdproj).

There are two way to add VDPROJ support

SQLite and SQLite EF support

I use SQLite and have a lot of page how to use it, for example

but if you open SQLite project in VS2019 you will failed even if you previously installed SQLite in your system from here SQLite Download Page - (best choice in most case is sqlite-netFx46-setup-bundle-x64-2015-1.0.113.0.exe).



This issue even can not be solve by installing this packages SQLite/SQL Server Compact Toolbox



Because Visual Studion is 32bit-program in 64bit common windows environment, you need to install also a 32-bit version (specially for Visual Studio).



And this is not all. Need to install Entity Framework 6 Power Tools Community Edition

Of course, this is globally installed packages, to GAC, machine config and Visual Studio config. Also need to add SQLite packages to project.



Only after that EF for SQLite will be working fine.




MySQL

Unfortunately EF don't working with MySQL, any my attempt was filed, it looks as restriction from Microsoft to use MySQL.



Therefore we need to install two program MySQL for Visual studio and MySQL Connector NET and this allow us see MySQL data in SQL Explorer and allow us working with MySQL by ADO.NET.







... to be continue ...





Comments ( )
<00>  <01>  <02>  <03>  <04>  <05>  <06>  <07>  <08>  <09>  <10>  <11>  <12>  <13>  <14>  <15>  <16>  <17>  <18>  <19>  <20>  <21
Link to this page: http://www.vb-net.com/Vs2019/Index.htm
<SITEMAP>  <MVC>  <ASP>  <NET>  <DATA>  <KIOSK>  <FLEX>  <SQL>  <NOTES>  <LINUX>  <MONO>  <FREEWARE>  <DOCS>  <ENG>  <MAIL ME>  <ABOUT ME>  < THANKS ME>