Sorry, I was not clear. What was working is: VS 2010 and Sqlite.net 1.0.66.0 Apr 18, 2010. I contruct my application on these versions Note: My VS 2010 is in french, so I must retranslate the error messages in english in my explanation so they are probably not the english messages you have
After that I install thSP1 of VS 2010 And now, I want to modify my application to add a new table and a new Association between this new table and an existing one in the Entity Framework. The XML code genrated is always wrong, there always miss a definition. I have an error 3004 most of the time and later I have an error 11004. When I open the Edmx file with an XML editor, I can see that the association was not correctly created, and in VS 2010 SP1, I can' modify it because "Association Mapping to exposed foreign keys are not allowed"... After I modify the XML file manualy, all is correct. So I thought that there is some incompatibility beteween SQlLite 1.0.66 and VS 2010 SP1, and I try to use the latest version. First of all I don't uninstall the V1.0.66 and I install above the version 1.0.74 and from there, the Sqlite data provider was never seen in VS 2010. I try to install all the version x32 and x64, bundle or not. I try to uninstall the V1.0.66 and reinstall probably the V1.0.74 x64 Bundle. After that I try to register manualy in the GAC the Dllwith GACUtil but nothing works. Now, I understand that it is because, today, the editor was not ported in the latest version of Sqlite.net. For runtime problem, I suppose I don't have correctly copy the Dll files. So today,I'll continue to use the legacy version,with manual changes in the xml file when necessary. Many Thanks 2011/7/14 Joe Mistachkin <sql...@mistachkin.com> > > > > > I'm not sure but after the SP1 upgrade, the previous version of > Sqlite.net > > stops to works. > > > > I assume you mean SP1 of Visual Studio 2010. I am not aware of any issues > with the > legacy System.Data.SQLite code on Visual Studio 2010. Was there a specific > error > message or was the provider simply missing? > > > > > My dev machine is a x64, but if I install a x64 version, are the Dll > > continue to work under a x32 system? > > > > The x86 packages only include the native binaries required for an x86 > system > and > the x64 packages only include the native binaries required for an x64 > system. > > > > > What are the differnces between the "Bundle" installa nd the other ??? > > > > The "bundle" packages include a mixed-mode System.Data.SQLite assembly that > contains > all the native code for the SQLite core and the managed code for > System.Data.SQLite. > Since the bundle includes native code, the one for the appropriate > architecture must > be selected. > > > > > So I try the 4 versions my dev machine and... NONE of them are working > > fine.I always have the error 175 indicating that the Sql.lite provider is > > not installed, either during sedign time and at the runtime, which is > never > > appear with the Legacy version. > > > > The VS designer support has not yet been migrated from the legacy version > (1.0.66) of > System.Data.SQLite. > > > > > For runtime, I added the 2 lines in the "DbProviderFactories" part of the > > app.config config file. > > > > When you add the entries for System.Data.SQLite, please be sure the version > number > matches the DLL you are trying to use. > > > > > When I try to add a reference in the project to Sqlite.netDll, I can't > find > > it in the .net list of Dll... > > > > The assemblies listed in the "Add Reference" dialog are not based on the > "app.config" > file. They are based on the AssemblyFolders[Ex] keys in the registry. The > legacy > installer for the VS designer modified these registry settings as well. > > In theory, you could manually add all the necessary registry settings; > however, it > might be best to temporarily use the legacy version of the > System.Data.SQLite assembly > if you require the VS designer components (if the VS2010 SP1 issue can be > figured out). > > -- > Joe Mistachkin > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
