D 2016-04-26T14:31:47.537
J foundin 1.0.101
J icomment I\sam\strying\sto\sget\s‘EF\sDesigner\sfrom\sDatabase’\sto\swork\sin\sVisual\sStudio\sCommunity\s2015\swith\sa\sSQLite\sdatabase.\s\sBut\sI'm\snot\sable\sto\ssee\sthe\sSQLite\sProvider\sor\smy\sexisting\sSQLite\sdatabase\swhen\strying\sto\schoose\sa\snew\sconnection.\s\s\r\n\r\nMy\sVS\sproject\sproperties\starget\s.Net\sFramework\s4.5.1\sand\sAny\sCPU\s|\sPrefer\s32-bit.\s\sI’m\son\sWindows\s8.1\son\sa\s64-bit\scomputer\sif\sany\sof\sthat\smatters.\r\n\r\nI\sused\sNuGet\sPackage\sManager\sto\sinstall\sEntity\sFramework\s6.1.3\sand\sSQLite\s1.0.101\s(which\sinstalled\sSystem.Data.SQLite,\sSystem.Data.SQLite.Core,\sSystem.Data.SQLite.EF6,\sand\sSystem.Data.SQLite.Linq)\sin\sa\snew\sWinForms\sapp.\r\n\r\nThe\sonly\sData\sSources\sand\sData\sProvider\sI’m\sseeing\sin\sthe\sChoose\sData\sSource\sdialog\sbox\sare\sMS\sSQL\sServer.\s\s\r\n\r\nMy\sapp.config\sfile\sseems\sto\sme\sto\slook\sOK\s(below),\sthough\sI've\sseen\snumerous\sposts\sabout\sprevious\sversions\sof\sSQLite\sand\sVS\sthat\ssuggested\sdifferent\ssettings,\smany\sof\swhich\sI've\stried\swithout\ssuccess:\r\n\r\n<entityFramework>\r\n\s\s\s\s<defaultConnectionFactory\stype="System.Data.Entity.Infrastructure.LocalDbConnectionFactory,\sEntityFramework">\r\n\s\s\s\s\s\s<parameters>\r\n\s\s\s\s\s\s\s\s<parameter\svalue="mssqllocaldb"/>\r\n\s\s\s\s\s\s</parameters>\r\n\s\s\s\s</defaultConnectionFactory>\r\n\s\s\s\s<providers>\r\n\s\s\s\s\s\s<provider\sinvariantName="System.Data.SqlClient"\stype="System.Data.Entity.SqlServer.SqlProviderServices,\sEntityFramework.SqlServer"/>\r\n\s\s\s\s\s\s<provider\sinvariantName="System.Data.SQLite.EF6"\stype="System.Data.SQLite.EF6.SQLiteProviderServices,\sSystem.Data.SQLite.EF6"/>\r\n\s\s\s\s</providers>\r\n\s\s</entityFramework>\r\n\s\s<system.data>\r\n\s\s\s\s<DbProviderFactories>\r\n\s\s\s\s\s\s<remove\sinvariant="System.Data.SQLite.EF6"/>\r\n\s\s\s\s\s\s<add\sname="SQLite\sData\sProvider\s(Entity\sFramework\s6)"\sinvariant="System.Data.SQLite.EF6"\sdescription=".NET\sFramework\sData\sProvider\sfor\sSQLite\s(Entity\sFramework\s6)"\stype="System.Data.SQLite.EF6.SQLiteProviderFactory,\sSystem.Data.SQLite.EF6"/>\r\n\s\s\s\s\s\s<remove\sinvariant="System.Data.SQLite"/>\r\n\s\s\s\s\s\s<add\sname="SQLite\sData\sProvider"\sinvariant="System.Data.SQLite"\sdescription=".NET\sFramework\sData\sProvider\sfor\sSQLite"\stype="System.Data.SQLite.EF6.SQLiteProviderFactory,\sSystem.Data.SQLite.EF6"/>\r\n\s\s\s\s</DbProviderFactories>\r\n\s\s</system.data>
J login anonymous
J mimetype text/x-fossil-plain
J private_contact d0d70ab965d130efba02478a74fe781f8b75f0a7
J severity Critical
J status Open
J title EF6\sDesigner\sSupport\sin\sVisual\sStudio\sCommunity\s2015
J type Question
K b86ebd5bbd37d253fffb8e40992c6f8dd5328c3d
U anonymous
Z 206a52ade40b03b022fb9d12c5d16454