Re: [sqlite] Reinstalling My Build Environment

2014-09-12 Thread Kees Nuyt
On Fri, 12 Sep 2014 23:23:39 +0100, Simon Slavin
 wrote:

>
>On 12 Sep 2014, at 10:33pm, Kees Nuyt  wrote:
>
>> Sure, it's all available at
>> https://system.data.sqlite.org/
>> 
>> I think the material there covers most of the questions.
>
>So the appropriate thing to do is post a pointer to
>
>
>
>?  That answers the questions about what to install, where to find it and how 
>to install it ?

Yes, and also
https://system.data.sqlite.org/index.html/doc/trunk/www/downloads.wiki

Actually, a pointer to https://system.data.sqlite.org/ will
usually suffice, they will find their way in the menu.

People asking about developing with, and deploying
System.Data.SQLite should be familiar with the wording, which is
quite specific for MS Windows .NET development and the Visual
Studio IDE.
Problem is, they sometimes aren't (and neither am I, so those
questions usually don't trigger me).

-- 
Groet,

Kees Nuyt

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


Re: [sqlite] Reinstalling My Build Environment

2014-09-12 Thread Joe Mistachkin

Simon Slavin wrote:
> 
> So the appropriate thing to do is post a pointer to
> 
>  
> 
> ?  That answers the questions about what to install, where to find it and
how to install it ?
> 

The FAQ (your link) and the download page (link below) are both good places
for people to look.


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


Re: [sqlite] Reinstalling My Build Environment

2014-09-12 Thread Simon Slavin

On 12 Sep 2014, at 10:33pm, Kees Nuyt  wrote:

> Sure, it's all available at
> https://system.data.sqlite.org/
> 
> I think the material there covers most of the questions.

So the appropriate thing to do is post a pointer to



?  That answers the questions about what to install, where to find it and how 
to install it ?

Simon.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


Re: [sqlite] Reinstalling My Build Environment

2014-09-12 Thread Kees Nuyt

On Fri, 12 Sep 2014 16:41:40 +0100, Simon Slavin
 wrote:

> On 12 Sep 2014, at 3:44pm, 
> Drago, William @ MWG - NARDAEAST 
> wrote:

> > It seems like a lot of people are unaware of
> > System.Data.Sqlite. This is understandable since most people on
> > this list are C programmers not .NET/C#/VB developers, but this
> > is the support list for System.Data.Sqlite as well as SQLite,
> > isn't it?

> All true.

> > Shouldn't we all be aware that anyone asking for help with
> > Visual Studio and/or EF6 and/or referencing file names like
> > sqlite-netFx451-setup-bundle-x86-2013-1.0.92.0.exe, is asking
> > about System.Data.Sqlite?

> How would I know that ?  I've never programmed for Visual Studio
> or for .NET.  I don't really know what they are (and don't need
> to).  I don't know what names like 'System.Data.Something' and
> 'netFx451' indicate.  For all I know they're something about
> Android.

Well, if it doesn't ring the bell on your front door, why
answer? 

Currently SQLite has created a very diverse landscape of
solutions, nobody expects we can cover them all by ourselves.
 
> There seems to be a confusing multiplicity of possible setups
> including things like Visual Studio and Entity Framework.  And
> they don't all end up needing the same SQLite
> package/library/executable/bundle from the same download site.
> While numerous people on this list can advise on PRAGMAs or a
> good way to phrase something in SQL, to answer questions like
> that you really need someone who actually uses that platform,
> and sometimes even someone who uses that version of that
> platform.
> 
> So people post questions like this, but their questions don't
> get answered as quickly as other questions posted on the same
> day.  And, reasonably, they think they're being ignored or their
> question didn't get posted properly or something.

They'll get used to the turn-around time of mailing lists soon
enough, if they are bothered to invest some time themselves.
If they really need immediate answers, they can buy a support
contract.

Eventually, when nobody else in the mailing list provides a
valid answer, Joe Mistachkin (member of the SQLite development
team) usually picks it up.
http://sqlite.org/crew.html

> Would it be possible to write a document for people looking for
> the right thing to download and install for their version of
> .NET or the Visual IDE or whatever it is ?  Perhaps with a text-
> based decision table to let readers figure out which one they
> want ?  And an explanation like the one I keep seeing about
> whether you just need runtime support or whether you also want
> setup/viewing integrated into the IDE.  Then if a question
> includes the words 'Visual Studio' or .NET, anyone can respond
> with a pointer to that document as a first approximation to an
> answer, whether they understand the question or not.
> 
> If such document already exists, could someone post a pointer ?

Sure, it's all available at
https://system.data.sqlite.org/

I think the material there covers most of the questions.

-- 
Groet,

Kees Nuyt

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


Re: [sqlite] Reinstalling My Build Environment

2014-09-12 Thread Simon Slavin

On 12 Sep 2014, at 3:44pm, Drago, William @ MWG - NARDAEAST 
 wrote:

> It seems like a lot of people are unaware of System.Data.Sqlite. This is 
> understandable since most people on this list are C programmers not 
> .NET/C#/VB developers, but this is the support list for System.Data.Sqlite as 
> well as SQLite, isn't it?

All true.

>  Shouldn't we all be aware that anyone asking for help with Visual Studio 
> and/or EF6 and/or referencing file names like 
> sqlite-netFx451-setup-bundle-x86-2013-1.0.92.0.exe, is asking about 
> System.Data.Sqlite?

How would I know that ?  I've never programmed for Visual Studio or for .NET.  
I don't really know what they are (and don't need to).  I don't know what names 
like 'System.Data.Something' and 'netFx451' indicate.  For all I know they're 
something about Android.

There seems to be a confusing multiplicity of possible setups including things 
like Visual Studio and Entity Framework.  And they don't all end up needing the 
same SQLite package/library/executable/bundle from the same download site.  
While numerous people on this list can advise on PRAGMAs or a good way to 
phrase something in SQL, to answer questions like that you really need someone 
who actually uses that platform, and sometimes even someone who uses that 
version of that platform.

So people post questions like this, but their questions don't get answered as 
quickly as other questions posted on the same day.  And, reasonably, they think 
they're being ignored or their question didn't get posted properly or something.

Would it be possible to write a document for people looking for the right thing 
to download and install for their version of .NET or the Visual IDE or whatever 
it is ?  Perhaps with a text-based decision table to let readers figure out 
which one they want ?  And an explanation like the one I keep seeing about 
whether you just need runtime support or whether you also want setup/viewing 
integrated into the IDE.  Then if a question includes the words 'Visual Studio' 
or .NET, anyone can respond with a pointer to that document as a first 
approximation to an answer, whether they understand the question or not.

If such document already exists, could someone post a pointer ?

Simon.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


Re: [sqlite] Reinstalling My Build Environment

2014-09-12 Thread Drago, William @ MWG - NARDAEAST
That was an excellent response, Joe. I think Paul Bainter gave up way too 
quickly and his conclusion that System.Data.SQLite is unsupported is 
unwarranted, but I can understand if he felt alienated by comments like:

"You may have found a library built on SQLite...Whatever you found isn't 
SQLite."

And:

"Whatever package you are attempting to install...SQLite has no direct 
responsibilities to your IDE."

It seems like a lot of people are unaware of System.Data.Sqlite. This is 
understandable since most people on this list are C programmers not .NET/C#/VB 
developers, but this is the support list for System.Data.Sqlite as well as 
SQLite, isn't it? Shouldn't we all be aware that anyone asking for help with 
Visual Studio and/or EF6 and/or referencing file names like 
sqlite-netFx451-setup-bundle-x86-2013-1.0.92.0.exe, is asking about 
System.Data.Sqlite?

Regards,
--
Bill Drago
Senior Engineer
L3 Communications / Narda Microwave East
435 Moreland Road
Hauppauge, NY 11788
631-272-5947 / william.dr...@l-3com.com


> -Original Message-
> From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-
> boun...@sqlite.org] On Behalf Of Joe Mistachkin
> Sent: Thursday, September 11, 2014 11:19 PM
> To: 'General Discussion of SQLite Database'
> Subject: Re: [sqlite] Reinstalling My Build Environment
>
>
> I assume that you did not see the response I sent earlier?
>
>   http://www.mail-archive.com/sqlite-
> users%40sqlite.org/msg85999.html
>
> --
> Joe Mistachkin
>
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
CONFIDENTIALITY, EXPORT CONTROL AND DISCLAIMER NOTE:This e-mail and any 
attachments are solely for the use of the addressee and may contain information 
that is privileged or confidential. Any disclosure, use or distribution of the 
information contained herein is prohibited. In the event this e-mail contains 
technical data within the definition of the International Traffic in Arms 
Regulations or Export Administration Regulations, it is subject to the export 
control laws of the U.S.Government. The recipient should check this e-mail and 
any attachments for the presence of viruses as L-3 does not accept any 
liability associated with the transmission of this e-mail. If you have received 
this communication in error, please notify the sender by reply e-mail and 
immediately delete this message and any attachments.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


Re: [sqlite] Reinstalling My Build Environment

2014-09-11 Thread Joe Mistachkin

I assume that you did not see the response I sent earlier?

http://www.mail-archive.com/sqlite-users%40sqlite.org/msg85999.html

--
Joe Mistachkin

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


[sqlite] Reinstalling My Build Environment

2014-09-11 Thread Paul Bainter
I appreciate the information that SQLite is not the same as other vendors
that possibly supply packages that enable the use of SQLite for environments
such as .NET.  This is good information to know.

 

Up to this point the only package that I've used and the one that I
referenced in my previous email was downloaded from System.Data.SQLite.  If
that site is not affiliated with SQLite, then you may want to pursue them
taking off the link to this support email group.

 

I had assumed that they were affiliated and therefore I felt ok with using
their package. Since they are not affiliated and they are hijacking your
support email group, it's obvious that the developers on System.Data.SQLite
are not supporting their own products, so I will not pursue this any
further.

 

Please forgive the intrusion,

Paul

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


Re: [sqlite] Reinstalling My Build Environment

2014-09-11 Thread Drago, William @ MWG - NARDAEAST
> Please help me.  At this point, I'm desperate for an installation where
> I can copy the compiled files from the bin directory to a clean machine
> and have it run.


I use VS2013, but I don't use EF6, so this may not work for you, but maybe it 
will help in some way anyway.

Based on what you describe (targeting .NET 4.51 and not having the C++ runtime 
installed) I imagine that the folder structure and content on your target 
machines should look like this:

\yourApp.exe
\System.Data.SQLite.dll  (From 
sqlite-netFx451-static-binary-Win32-2013-1.0.93.0.zip)
\System.Data.SQLite.EF6.dll  (From 
sqlite-netFx451-static-binary-Win32-2013-1.0.93.0.zip)
\System.Data.SQLite.Linq.dll (From 
sqlite-netFx451-static-binary-Win32-2013-1.0.93.0.zip)
\x86\SQLite.Interop.dll  (From 
sqlite-netFx451-static-binary-Win32-2013-1.0.93.0.zip)
\x64\SQLite.Interop.dll  (From 
sqlite-netFx451-static-binary-x64-2013-1.0.93.0.zip)

(Note that the last file above comes from a different .zip file than the 
others.)

***Do NOT run any installers or setups, just take the needed files from the 
.zips***

Get .zip files here: 
https://system.data.sqlite.org/index.html/doc/trunk/www/downloads.wiki


Try that on a clean machine and see what happens.

BTW, my folder structure/content is exactly the same only without EF6 and Linq, 
and it works fine for me.

Good luck,
--
Bill Drago
Senior Engineer

L3 Communications / Narda Microwave East
435 Moreland Road
Hauppauge, NY 11788
631-272-5947 / william.dr...@l-3com.com
CONFIDENTIALITY, EXPORT CONTROL AND DISCLAIMER NOTE:This e-mail and any 
attachments are solely for the use of the addressee and may contain information 
that is privileged or confidential. Any disclosure, use or distribution of the 
information contained herein is prohibited. In the event this e-mail contains 
technical data within the definition of the International Traffic in Arms 
Regulations or Export Administration Regulations, it is subject to the export 
control laws of the U.S.Government. The recipient should check this e-mail and 
any attachments for the presence of viruses as L-3 does not accept any 
liability associated with the transmission of this e-mail. If you have received 
this communication in error, please notify the sender by reply e-mail and 
immediately delete this message and any attachments.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


Re: [sqlite] Reinstalling My Build Environment

2014-09-11 Thread Joe Mistachkin

Paul Bainter wrote:
>
> SQLite is a great database, but I've had nothing but problems deploying it
> to a clean machine. There is supposed to be nothing extra to do when
moving
> the files from the bin directory to the target machine, but then I hear
> rumblings about an unknown missing C++ redistribution package that may
need
> to be added.   
> 

Are you deploying the pre-built binaries?  For the native (and mixed-mode)
binaries, the MSVC runtime is required.  It can either be linked statically
(which is the case for the native binaries in the System.Data.SQLite NuGet
packages) or dynamically, which is the case for the other System.Data.SQLite
packages.  However, the MSVC runtime library, in one form or another, is
always required when dealing with native C/C++ binaries produced via MSVC.

> 
> All my deployment problems must be something that I'm doing or not doing. 
> 

How exactly are you deploying System.Data.SQLite?

>
> Since I need to use Entity Framework, I started off by installing
> sqlite-netFx451-setup-bundle-x86-2013-1.0.92.0.exe.  
>

The setup package is only required if you need design-time support for the
Entity Framework (wizard) or the other design-time components (e.g. the
table designer).  Also, I do not think that release 1.0.92.0 supports EF6
at design-time due to several integration issues that were recently fixed.

>
> Since the deployment has been such a nightmare, I looked around and saw
> some instructions on using the NuGet package.  
>

I've tried very hard to make the deployment as easy as possible.  If there
are specific issues with it, I would love to address them.  Please tell me
how I can improve it.

> 
> I installed the Nuget package, and that pretty much corrupted my project
> and maybe my Visual Studio installation, so I've decided to start fresh.
> 

I honestly have no idea how such corruption could occur.  I've installed
both
the NuGet packages and the setup packages on several different machines
here,
including ones running Windows XP, Windows 7, and Windows 8, without any
issues.
In particular, the setup packages go to extraordinary lengths to prevent
exactly
the type of corruption you are referring to.  Can you provide any further
detail
on this?  Do you have the setup log files?  They are quite extensive and
could
provide some valuable clues.

> 
> It would be tremendously helpful if you could point me in the correct
> direction for installing SQLite into my Visual Studio 2013 installation.
> 

First, you should consider using the 1.0.94.0 pre-release package, as the
EF6
design-time integration issues should be corrected by it.

> 
> There seems to be so many pieces and different instructions that I'm
confused.  
> 

The official guidelines and instructions are on the System.Data.SQLite web
site, primarily on the download page:

https://system.data.sqlite.org/index.html/doc/trunk/www/downloads.wiki

For design-time support for EF6 in Visual Studio 2013, you will want to
install
the setup package for Visual Studio 2013 follwed by the "System.Data.SQLite"
NuGet package.  The 1.0.94.0 version is undergoing final testing and is
about
to be released.  Pre-release downloads for it are available at:

https://system.data.sqlite.org/index.html/doc/preRelease/www/downloads.wiki

In your case, you will probably want the following files:

1. sqlite-netFx451-setup-bundle-x86-2013-1.0.94.0.exe -- VS 2013 setup
package

2. http://nuget.org/api/v2/package/System.Data.SQLite.Test/1.0.94.1 -- NuGet
package

The above package is the "System.Data.SQLite.Test" package because it is a
pre-release.  Normally, you should use the "System.Data.SQLite" package.

>
> Do I use the sqlite-net bundle (maybe I'm using the wrong one) to install,
> or do I use NuGet or perhaps both?   
> 

The "sqlite-net" bundle is a third-party package.  I have no idea what it
contains.  The complete list of System.Data.SQLite packages (including those
available via NuGet) is listed at:

https://system.data.sqlite.org/index.html/doc/trunk/www/downloads.wiki

> 
> It would seem that using the NuGet package would be best, but when I
install
> the NuGet package into a clean environment (yes I've done this several
times),
> it's never compatible with Entity Framework, or maybe I'm implementing it
> incorrectly. 
> 

The Entity Framework project has released several versions during the course
of the System.Data.SQLite support for it.  Apparently, for the design-time
components to work, the versions may need to match up exactly?  I'm not 100%
sure about this.  Anyhow, the runtime support for EF6 does not appear to be
impacted by this issue.

>
> When using the NuGet package SQLite never comes up as a database option
for
> the ADO.net Entity Data Model.
>

Yes, this is some kind of issue with the design-time support for EF6.
Either
the System.Data.SQLite setup package is not installed or it is not matching
up with the version of the Entity Framework.  Hopefully, release 1.0.94.0
should work with Visual Studio 

Re: [sqlite] Reinstalling My Build Environment

2014-09-10 Thread Stephen Chrzanowski
I've run into this kind of issue with another IDE, not dealing with
SQLite.  The issue came down to package/code/something-or-other that was
once upon a time on an old installation of the IDE that I ported in then,
but now, after a fresh install of the same IDE, it wouldn't work.  My only
resolution was, since I had the source code, was rebuild the projects links
together by including the source code, crossing my fingers, toes, put my
finger over the enter key, and close my eyes and hope no smoke and fire
happened when I hit the "GO" key.

But as Simon mentions, and as a bit of a clarification, SQLite does come
with source code.  Whatever package you are attempting to install might
state that it 'installs sqlite' but that might be just something pre-built
for whatever the package may be, and allow your code to build without
requiring the SQLite[2/3/4].dll, or it might be something specifically for
your IDE.  SQLite has no direct responsibilities to your IDE, but whatever
that package is, relies on some kind of SQLite code or provided binaries.

On Wed, Sep 10, 2014 at 7:47 PM, Simon Slavin  wrote:

>
> On 11 Sep 2014, at 12:36am, Paul Bainter  wrote:
>
> > SQLite is a great database, but I've had nothing but problems deploying
> it
> > to a clean machine.
>
> Maybe I can help a little by explaining something.   SQLite is C source
> code.  It's available most conveniently as one .h file and one .c file and
> you can include them both in any application you're writing.  No installers
> are needed, you download both text files from the SQLite website and put
> them wherever you want them.  Any programming environment which lets your
> code call C functions should work fine with it.  If not, please let us know.
>
> You may have found a library built on SQLite.  You may have found an
> installer somewhere which purports to 'install' SQLite.  That isn't how it
> works.  SQLite doesn't need installation.  There's no fixed place on a
> computer it has to be.  It is not object code.  It is not a library.  It is
> not a framework.  It is not a subversion package or a git package or any
> other kind of package.  Whatever you found isn't SQLite.
>
> That doesn't mean you shouldn't post about it here.  Some other user of
> whatever you found might be able to help you.  It just means you should be
> complaining about the thing you found, not SQLite itself.
>
> I hope someone can point you at a way to let you use SQLite as an Entity
> Framework for Visual Studio 2013.  Sorry, it's not a platform I'm familiar
> with.
>
> Simon.
> ___
> 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] Reinstalling My Build Environment

2014-09-10 Thread Teg
Hello Paul,

What programming language are you using to devel with?

Using C++, I "deploy" sqlite by building the lib and static linking it
into  my  program.  No  DLL's or install is needed. Sounds like you're
doing something significantly more complicated than that though. 

C

Wednesday, September 10, 2014, 7:36:35 PM, you wrote:

PB> SQLite is a great database, but I've had nothing but problems deploying it
PB> to a clean machine. There is supposed to be nothing extra to do when moving
PB> the files from the bin directory to the target machine, but then I hear
PB> rumblings about an unknown missing C++ redistribution package that may need
PB> to be added.   All my deployment problems must be something that I'm doing
PB> or not doing. Since I need to use Entity Framework, I started off by
PB> installing sqlite-netFx451-setup-bundle-x86-2013-1.0.92.0.exe.  Since the
PB> deployment has been such a nightmare, I looked around and saw some
PB> instructions on using the NuGet package.  I installed the Nuget package, and
PB> that pretty much corrupted my project and maybe my Visual Studio
PB> installation, so I've decided to start fresh.

PB>  

PB> It would be tremendously helpful if you could point me in the correct
PB> direction for installing SQLite into my Visual Studio 2013 installation.
PB> There seems to be so many pieces and different instructions that I'm
PB> confused.  Do I use the sqlite-net bundle (maybe I'm using the wrong one) to
PB> install, or do I use NuGet or perhaps both?   It would seem that using the
PB> NuGet package would be best, but when I install the NuGet package into a
PB> clean environment (yes I've done this several times), it's never compatible
PB> with Entity Framework, or maybe I'm implementing it incorrectly. When using
PB> the NuGet package SQLite never comes up as a database option for the ADO.net
PB> Entity Data Model.

PB>  

PB> Please help me.  At this point, I'm desperate for an installation where I
PB> can copy the compiled files from the bin directory to a clean machine and
PB> have it run.

PB>  

PB> I'm running: Windows 7 - 64 bit and Visual Studio 2013 Ultimate. My target
PB> machines could be either 32 bit or 64 bit Windows 7 machines.

PB>  

PB> Your help is tremendously appreciated,

PB> PDB

PB> 

PB> ___
PB> sqlite-users mailing list
PB> sqlite-users@sqlite.org
PB> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users



-- 
Best regards,
 Tegmailto:t...@djii.com

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


Re: [sqlite] Reinstalling My Build Environment

2014-09-10 Thread Simon Slavin

On 11 Sep 2014, at 12:36am, Paul Bainter  wrote:

> SQLite is a great database, but I've had nothing but problems deploying it
> to a clean machine.

Maybe I can help a little by explaining something.   SQLite is C source code.  
It's available most conveniently as one .h file and one .c file and you can 
include them both in any application you're writing.  No installers are needed, 
you download both text files from the SQLite website and put them wherever you 
want them.  Any programming environment which lets your code call C functions 
should work fine with it.  If not, please let us know.

You may have found a library built on SQLite.  You may have found an installer 
somewhere which purports to 'install' SQLite.  That isn't how it works.  SQLite 
doesn't need installation.  There's no fixed place on a computer it has to be.  
It is not object code.  It is not a library.  It is not a framework.  It is not 
a subversion package or a git package or any other kind of package.  Whatever 
you found isn't SQLite.

That doesn't mean you shouldn't post about it here.  Some other user of 
whatever you found might be able to help you.  It just means you should be 
complaining about the thing you found, not SQLite itself.

I hope someone can point you at a way to let you use SQLite as an Entity 
Framework for Visual Studio 2013.  Sorry, it's not a platform I'm familiar with.

Simon.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


[sqlite] Reinstalling My Build Environment

2014-09-10 Thread Paul Bainter
SQLite is a great database, but I've had nothing but problems deploying it
to a clean machine. There is supposed to be nothing extra to do when moving
the files from the bin directory to the target machine, but then I hear
rumblings about an unknown missing C++ redistribution package that may need
to be added.   All my deployment problems must be something that I'm doing
or not doing. Since I need to use Entity Framework, I started off by
installing sqlite-netFx451-setup-bundle-x86-2013-1.0.92.0.exe.  Since the
deployment has been such a nightmare, I looked around and saw some
instructions on using the NuGet package.  I installed the Nuget package, and
that pretty much corrupted my project and maybe my Visual Studio
installation, so I've decided to start fresh.

 

It would be tremendously helpful if you could point me in the correct
direction for installing SQLite into my Visual Studio 2013 installation.
There seems to be so many pieces and different instructions that I'm
confused.  Do I use the sqlite-net bundle (maybe I'm using the wrong one) to
install, or do I use NuGet or perhaps both?   It would seem that using the
NuGet package would be best, but when I install the NuGet package into a
clean environment (yes I've done this several times), it's never compatible
with Entity Framework, or maybe I'm implementing it incorrectly. When using
the NuGet package SQLite never comes up as a database option for the ADO.net
Entity Data Model.

 

Please help me.  At this point, I'm desperate for an installation where I
can copy the compiled files from the bin directory to a clean machine and
have it run.

 

I'm running: Windows 7 - 64 bit and Visual Studio 2013 Ultimate. My target
machines could be either 32 bit or 64 bit Windows 7 machines.

 

Your help is tremendously appreciated,

PDB



___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users