c# - Visual Studio 2012 SQLite Install Not Appearing -


i have downloaded , installed sqlite-netfx45-setup-bundle-x86-2012-1.0.88.0.exe, despite following various instructions have not been able see in way within visual studio 2012. understand, x86 install package shown above install visualizer vs2012. have opened choose data source dialog server explorer, , not see sqlite database file option shown. additionally, have tried adding sqlite project , installing via nuget system, appeared install correctly, still see nothing anywhere. have read various tutorials , seems following instruction correctly, except not see sqlite listed anywhere in lists of data sources. have tried doing new project, , after restarting machine, same result, nothing. doing wrong, or can reset or try differently? obvious step missing assumes? thanks.

just found this info, check out:

install provider
in order connect sqlite databases, need install appropriate ado.net , entity framework provider. luckily, provider we're using available via nuget.

  1. inside pmc, run install-package system.data.sqlite.x86

we need register provider. open app.config, , anywhere inside configuration element, add following fragment.

<system.data>   <dbproviderfactories>     <add name="sqlite data provider"           invariant="system.data.sqlite"           description="data provider sqlite"           type="system.data.sqlite.sqlitefactory, system.data.sqlite" />   </dbproviderfactories> </system.data> 

Comments

Popular posts from this blog

java.util.scanner - How to read and add only numbers to array from a text file -

rewrite - Trouble with Wordpress multiple custom querystrings -