[sqlite] EF6 Issue (2)
So, after some debugging, I found a way to attach to a given database by code. See the sample project at http://www.terwoord.nl/SQLiteEF6Test.zip The project starts with retrieving a temporary file. It then saves a sample entity MyMessageObj. Next it retrieves it in a new DbContext. In a nested DbContext, it also retrieves the entity, but changes it and saves it to the database. After flushing the changes, it reloads the entity in the outer DbContext. Here's what's going wrong (The sample throws an exception). It loads the old value. What am I doing wrong here? Thanks in advance! Regards, Matthijs ter Woord ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] Entity Framewoork 6 and Connection String question
Hi, I'm trying to have my DbContext connect to a sqlite database specified by the end user. The end user is given a File Open dialog, and then the application should connect to it. The DbContext has a constructor taking a connection string, but I cannot get it to work. Is this a situation that's yet unsupported? Regards, Matthijs ter Woord ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] SQLITE For Windows phone
See http://developer.nokia.com/Community/Wiki/How_to_use_SQLite_in_Windows_Phone On Wed, Aug 7, 2013 at 2:23 AM, Cadu . wrote: > Hello I wonder if you could send me a tutorial on how to add the SQLITE > project in Visual Studio 2012, since not found any material regarding this > project, I thank the collaboration > ___ > 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
Re: [sqlite] sqlite on ESXI hypervisor
SQLite on normal guest operating systems works fine.. On Tue, Jul 23, 2013 at 4:15 PM, Rob Willett wrote: > Hi, > > Apologies for jumping in here. > > I was interested in your question as I have some development going on > which will eventually go into production on a VMWare ESXI server, which > could be either Linux or Windows. > > When you say you are running sqlite3 on esxi5 do you mean that you are > running sqlite3 on a host system on top of Esxi 5 (e.g. Linux or Windows > Server) or actually in the hypervisor itself? > > I know you say "esxi 5.0 (VMware hypervisor)" in your original email but > wanted to check the details. > > Thanks, > > Rob. > > On 23 Jul 2013, at 15:04, Clemens Ladisch wrote: > > > 1 1 wrote: > >> I've tried to run the latest version of sqlite3 on esxi 5.0 (VMware > >> hypervisor), but unsuccessfully. Strace shows "fcntl function not > >> implemended". > > > > Apparently, VMFS does not implement file locking. > > > > Try using the unix-dotfile VFS, or unix-none if you can guarantee that > > the database will never be accessed concurrently. > > > > > > Regards, > > Clemens > > ___ > > 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 > ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Unattended install
Problem comes however with the registration of the provider (Entity Framework mostly). Add to that that my product/project runs as a VS extension, and I really dont want to change the devenv.exe.config file to include a registration.. Is the installation MSI based? If so, how do I obtain the actual MSI file, so i can use msiexec to do an unattended install? On Sat, May 25, 2013 at 2:13 PM, Joe Mistachkin wrote: > > Matthijs ter Woord wrote: > > > > I'm looking for a way to install System.Data.SQLite unattended, as part > of > > the installation procedure of my product. > > How can this be achieved? > > > > Normally, there is nothing that requires installation on an end-user > machine. > Simply deploy the System.Data.SQLite managed and interop assemblies along > with > your application binaries. The section that talks about the native library > pre-loading feature shows the "ideal" file deployment layout: > > * \YourApp.exe > * \YourLib.dll > * \System.Data.SQLite.dll (required, managed-only core assembly) > * \System.Data.SQLite.Linq.dll (optional, managed-only LINQ > assembly) > * \x86\SQLite.Interop.dll (required, x86 native interop assembly) > * \x64\SQLite.Interop.dll (required, x64 native interop assembly) > > For further information, see: > > > https://system.data.sqlite.org/index.html/doc/trunk/www/downloads.wiki > > -- > 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
[sqlite] Unattended install
Hi, I'm looking for a way to install System.Data.SQLite unattended, as part of the installation procedure of my product. How can this be achieved? Regards, Matthijs ter Woord ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] [SQLite.NET] DbProviderServices DB* methods implementation
It's great to see SQLite to have a decent entityframework provider. One area that's missing is the DB* methods of the DbProviderServivices (used to check for and create/update databases). I want to implement that (almost have it working already). What's the best road to follow to get that implementation contributed? ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users