Re: [sqlite] Working with SQLite-Net in Framework 2.0
On 7/11/2014 1:02 AM, Joe Mistachkin wrote: Steve Rogers wrote: Can the two versions exist in a VS 2010 development environment on the same machine? I hope I have clarified that important detail. I'm not sure as I've never tested that setup. I do know that only the setup package for Visual Studio 2010 (which uses the .NET Framework 4) will allow it to actually make use of the design-time components for System.Data.SQLite. For your particular situation, quite a lot depends on whether or not you need the design-time support for SQLite. I do not need design-time support for SQLite in VS2010, even though I have installed it. I have been using SQLite Expert Personal 3 instead of the design-time support in VS2010 because it does more than the design -time support. https://system.data.sqlite.org/index.html/doc/trunk/www/downloads.wiki On the above linked page, the "Using Native Library Pre-Loading" and "Deployment Guidelines" sections merit special attention. I'll check it out. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users - No virus found in this message. Checked by AVG - www.avg.com Version: 2014.0.4716 / Virus Database: 3986/7832 - Release Date: 07/10/14 ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Working with SQLite-Net in Framework 2.0
Steve Rogers wrote: > > So I just want to build one input screen for the saw in .NET 2.0 and the > rest of the complex operation gets done in programs on the computers > that run .NET 4.0. > > So my question is only a development machine question. > Ok. So, on the development machine, do you need to make use of the Visual Studio design-time components (e.g. the visual table designer, etc)? If not, there is [basically] no need to install the setup package. > > Can the two versions exist in a VS 2010 development environment on the > same machine? > I hope I have clarified that important detail. > I'm not sure as I've never tested that setup. I do know that only the setup package for Visual Studio 2010 (which uses the .NET Framework 4) will allow it to actually make use of the design-time components for System.Data.SQLite. For your particular situation, quite a lot depends on whether or not you need the design-time support for SQLite. If you don't, you gain a lot more flexibility for testing and deployment (i.e. you can use the .NET Framework 2.0 version of System.Data.SQLite application locally with any version of the framework). It is somewhat more complex to accomplish this if you need design-time support. More details on the best practices for application local deployment can be found here: https://system.data.sqlite.org/index.html/doc/trunk/www/downloads.wiki On the above linked page, the "Using Native Library Pre-Loading" and "Deployment Guidelines" sections merit special attention. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Working with SQLite-Net in Framework 2.0
On 7/10/2014 10:28 PM, Joe Mistachkin wrote: Steve Rogers wrote: If I install the .NET 2.0 version of SQLite-Net on top of the .NET 4.0 version will that version install in different locations so that I can manage which version of the components I need to use? Why are you installing the System.Data.SQLite setup package instead of deploying application locally? Are you actually going to use the Visual Studio designer support? I think you misinterpreted my question. For deployment I will only deploy the necessary DLL, and only the correct ones for the OS and its .NET Framework limitations. My question concerns only my development environment. This application is an inventory control program for pieces of laminated compositions that are left over at a computerized saw. The compositions have a top laminate and a bottom laminate and a core material ((thickness, plywood, particle board, Fiberex). The saw has the a Windows 2000 system. All the user of the saw needs to do is to input leftover scraps from the saw into the database. In engineering, where designs are made, they have a database of scraps that could save them a lot of buck if they could quickly locate s scrap that fits into an existing design so that a new 4x8 or 4x10 sheed of laminated material would not be needed for just a small pat. So all the correction of editing errors at the sae, and all usage of inventory takes place in engineeering where they have .Net 4.0 capable systems. So I just want to build one input screen for the saw in .NET 2.0 and the rest of the complex operation gets done in programs on the computers that run .NET 4.0. So my question is only a development machine question. Can the two versions co-exist, or will there be problems? In theory, yes; however, that configuration has *NOT* been tested. Can the two versions exist in a VS 2010 development environment on the same machine? I hope I have clarified that important detail. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users - No virus found in this message. Checked by AVG - www.avg.com Version: 2014.0.4716 / Virus Database: 3986/7832 - Release Date: 07/10/14 ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Working with SQLite-Net in Framework 2.0
Steve Rogers wrote: > > If I install the .NET 2.0 version of SQLite-Net on top of the .NET 4.0 > version will that version install in different locations so that I can > manage which version of the components I need to use? > Why are you installing the System.Data.SQLite setup package instead of deploying application locally? Are you actually going to use the Visual Studio designer support? > > Can the two versions co-exist, or will there be problems? > In theory, yes; however, that configuration has *NOT* been tested. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] Working with SQLite-Net in Framework 2.0
I have started some SQLite-Net development and it is progressing beautifully. I am using the version for .NET 4.0 installed with: sqlite-netFx40-setup-bundle-x86-2010-1.0.93.0.exe I now learn that one (and only one) of my deployment targets will be a machine using Windows 2000 as a dedicated controller for an industrial machine. I cannot install .NET 4.0 on that machine, but I can manage .NET 2.0 on Windows 2000. There is a possibility that I could upgrade the OS on the industrial machine to Win 7, but that is problematic because the manufacturers of the industrial machine want to sell a new computer and OS rather that to help their users convert from Win2000 to Win7 and they are not being all that helpful. I note that there are also a version of SQLite-Net for .NET 2.0 that can be installed with: sqlite-netFx20-setup-bundle-x86-2005-1.0.93.0.exe On my system, the .NET 40 version of the SQLite-Net installation installed on Windows 7 in: C:\Program Files (x86)\System.Data.SQLite\2010\bin My plan is to compile a special stripped-down version of my database application for that odd Windows 2000 installation (which only requires a very few parts of the entire application). That application will need to be compiled for a .NET 2.0 framework target. The majority of the application will continue to be developed using .NET 4.0. If I install the .NET 2.0 version of SQLite-Net on top of the .NET 4.0 version will that version install in different locations so that I can manage which version of the components I need to use? Can the two versions co-exist, or will there be problems? I really don't relish losing all the .NET 4.0 development and the loss of certain more modern features of C# by maintaining one common application compiled for .NET 2.0. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users