SQLite and Entity Framework in Visual Studio 2019 ??

emeyerriecks

New member
Joined
Sep 25, 2019
Messages
1
Programming Experience
10+
Hey all,

I've been scratching my head on this for the past few days...

I'm trying to get SQLite to work with Entity Framework in Visual Studio 2019. I've downloaded the correct 32 and 64 setups from sqlite.org, installed SQLite compact toolbar.

I'm using the Entity Model wizard, Database first method:
When I try to create a new data connection using the SQLite Providers (by EricEJ) it seems to work. When I click on Next to start selecting tables to use it gives me a Sqlite TypeCast error message box. I'm just plain stumped.


Any ideas how to get SQLite to work with Entity Framework in Visual Studio 2019?

Thanks for any help!
Evan
 

NoUserHere

Well-known member
Joined
Sep 5, 2018
Messages
2,138
Programming Experience
10+
Before you go down the road of headaches, bugs, memory leak issues and constant troubleshooting problems, I am advising you to look for a different ORM. Why not try the one created by Stackoverflow; Dapper is also free and probably better. I should also warn you that there are compatibility issues with EF and SQLite. But sure, if you want to ignore the red flags you can follow these steps which should resolve this issue Problems using Entity Framework 6 and SQLite
 

cRo

New member
Joined
Nov 19, 2020
Messages
1
Location
Germany
Programming Experience
3-5
Hi,

I know I am new and the question was not mine, but that is exactly what I was searching for.
Many thanks!

BR
cRo
 
Top Bottom