Re: [sqlite] SQLite data source in Visual Studio 2010

[Joe Mistachkin]

Agrawal, Manish wrote:
> 
> Since the 32-bit installer will install 32-bit assemblies, and VS2010
> is a 32-bit app, what is the benefit of installing 64-bit assemblies
> into the GAC.
> 

The 64-bit assemblies in the GAC could be used by any purely managed
application running on a 64-bit machine (since purely managed
applications always run with the native processor architecture of the
machine).

Having said that, the best practice would be to always deploy the
necessary assemblies (both native and managed) in the application
directory itself.

--
Joe Mistachkin

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

Re: [sqlite] SQLite data source in Visual Studio 2010

[Agrawal, Manish]

Thanks very much, hopefully my last question in the series:

Since the 32-bit installer will install 32-bit assemblies, and VS2010 is a 
32-bit app, what is the benefit of installing 64-bit assemblies into the GAC.

Thanks
Manish


>
> 2. If only the 32-bit setup files are useful, what is the use of the
64-bit setup
> files.
>

The 64-bit setups can do everything except install the design-time components, 
including putting 64-bit assemblies into the GAC.

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

Re: [sqlite] SQLite data source in Visual Studio 2010

[Joe Mistachkin]

Agrawal, Manish wrote:
>
> 1. To confirm, if I want data source and other visual support, I MUST
INSTALL the
> setups on my development machine. It is not adequate to just copy the dll
files
> to the project.
>

Basically, yes.  Otherwise you would have to manually run the design-time
component
installer tool, which is not recommended.

>
> 2. If only the 32-bit setup files are useful, what is the use of the
64-bit setup
> files.
>

The 64-bit setups can do everything except install the design-time
components,
including putting 64-bit assemblies into the GAC.

>
> 3. If I install the setups on my dev machine, when I distribute the app,
is it
> required to include the dll files and add references to them within the
project? 
>

When you deploy your application, the only additional files would be
"System.Data.SQLite.dll" (appropriate to the target processor since the
mixed-mode
assembly does contain native code) and optionally
"System.Data.SQLite.Linq.dll"
(if you use the LINQ support).  Also, if and only if you use the separate
managed
and native assemblies, you would need to include "SQLite.Interop.dll"
(appropriate
to the target processor).

--
Joe Mistachkin

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

Re: [sqlite] SQLite data source in Visual Studio 2010

[Brady Kelly]

On 21 February 2012 05:44, Joe Mistachkin  wrote:

>
>  NOTE #2: When installing the setup package, make sure that the option to
> install the assemblies into the GAC is checked if you plan on installing
> the design-time components.  In the next release, this box will be checked
> by default.
>

Thank you. This was what caused my problem, but I don't recall seeing it
the first time round.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite data source in Visual Studio 2010

[Agrawal, Manish]

Thanks very much, that is very helpful. I had three follow up questions:

1. To confirm, if I want data source and other visual support, I MUST INSTALL 
the setups on my development machine. It is not adequate to just copy the dll 
files to the project.

2. If only the 32-bit setup files are useful, what is the use of the 64-bit 
setup files.

3. If I install the setups on my dev machine, when I distribute the app, is it 
required to include the dll files and add references to them within the project?

Thanks
Manish 

-Original Message-
From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] 
On Behalf Of Joe Mistachkin
Sent: Monday, February 20, 2012 10:44 PM
To: 'General Discussion of SQLite Database'
Subject: Re: [sqlite] SQLite data source in Visual Studio 2010


As of System.Data.SQLite version 1.0.79.0, design-time installer support is 
included in the appropriate setup packages.  The instructions on the blog post 
you linked to should now be considered obsolete.

NOTE #1: Since Visual Studio itself is a 32-bit process, you will need to 
install the 32-bit setup package in order for the design-time components to 
install and work properly.

NOTE #2: When installing the setup package, make sure that the option to 
install the assemblies into the GAC is checked if you plan on installing the 
design-time components.  In the next release, this box will be checked by 
default.

--
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

Re: [sqlite] SQLite data source in Visual Studio 2010

[Joe Mistachkin]

As of System.Data.SQLite version 1.0.79.0, design-time installer support
is included in the appropriate setup packages.  The instructions on the
blog post you linked to should now be considered obsolete.

NOTE #1: Since Visual Studio itself is a 32-bit process, you will need
to install the 32-bit setup package in order for the design-time
components to install and work properly.

NOTE #2: When installing the setup package, make sure that the option to
install the assemblies into the GAC is checked if you plan on installing
the design-time components.  In the next release, this box will be checked
by default.

--
Joe Mistachkin

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

Re: [sqlite] SQLite data source in Visual Studio 2010

[Brady Kelly]

On 21 February 2012 04:45, Agrawal, Manish  wrote:

> I am still playing with the sqlite setup in Visual Studio. Previously I
> found success following the instructions at:
>
>
> http://www.tsjensen.com/blog/2011/06/04/SQLite+On+Visual+Studio+2010+Setup+Instructions.aspx
>
>  But I want to create the data source visually and I am not able to bring
> up the sqlite options in the data sources dialogs as I could when I had
> installed the binary.


How serendipitous! I have just joined this list minutes ago, in order to
ask about this very issue.

I first tried just using NuGet, which is supposed to cover everything, and
then I tried the full install package as well, still with no joy. I don't
want to speculate on whether your experience with the setup files will be
different though. I know I could create the connection manually but it not
being available in Server Explorer suggests something is wrong, and I am
not comfortable with that.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] SQLite data source in Visual Studio 2010

[Agrawal, Manish]

I am still playing with the sqlite setup in Visual Studio. Previously I found 
success following the instructions at:

http://www.tsjensen.com/blog/2011/06/04/SQLite+On+Visual+Studio+2010+Setup+Instructions.aspx

But this requires the sqlite packages to be "installed" on the local computer. 
Following the recommended procedure, I uninstalled all SQLite installations, 
and copied the dll files to a project folder and added references to the dll 
files:

http://magrawal.myweb.usf.edu/DataSourceProblem.JPG

I am sure that with these references, I could follow the instructions at the 
following site to write the app:

http://sqlite.phxsoftware.com/forums/p/76/266.aspx

But I want to create the data source visually and I am not able to bring up the 
sqlite options in the data sources dialogs as I could when I had installed the 
binary. My questions are:

1. Do I HAVE to use the setup files to "install" sqlite on the developer 
machine to get the data source dialog options?

2. What is the minimal procedure for installation? 

3. Why is the installation of 1.0.66.0 from SourceForge required to get the 
visual functionality? What changed after this version?

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