Does anyone know how to get SQLite to appear as a database provider source when adding an EDMX to a project?
In VS2010 on my old machine I installed SQLite 1.0.66 and by some magic it made SQLite appear as a provider to pick from when making a new DB connection. I have added SQLite 1.0.84 to my project via Nuget, then I installed 1.0.84 from a setup, but it doesn't appear as a provider. I've been searching and trying tricks for hours but I've found no answers either way. I see lots of confused people complaining about the same thing and conflicting or useless suggestions (as usual). My time is burning away so I thought I'd ask in here just in case. I tried modifying an existing SQL Server EDMX file manually to trick it into thinking it was using SQLite, but it won't open in the designer and thinks the provder is not found. Such tricks haven't worked. So how the hell do you use EF with SQLite 1.0.84? I'll just keep searching and searching ... Greg
