[sqlite] Cannot load DLLs using NUnit with SQLite
Hello, My situation is that I am setting up our testing project for unit tests using NUnit. The requirements are developers must be able to run the tests from within visual studio and through the nunit exe, and also our continuous integration server must be able to run the unit tests after a check in. I found 4 versions of the binaries available for .net 4.0 These would be: mixed mode x86, non mixed mode x86, mixed mode x64, non mixed mode x64 No matter which one I use, I always get the same error: Could not find any resources appropriate for the specified culture or the neutral culture. Make sure "System.Data.SQLite.SR.resources" was correctly embedded or linked into assembly "System.Data.SQLite" at compile time, or that all the satellite assemblies required are loadable and fully signed. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Cannot add interop assembly
So many replies! Hard to reply to them all, but I understand the issue now. I didn't know it was native. >> Their beliefs do not impact how the code needs to be deployed in order to function properly. It does because it's my director. For us to deploy DLLs they "have to be added as a reference". They do not allow for deploy scripts to push DLLs to folders unless part of the project. But since it is an unmanaged DLL, I'll just tell them "either drop SQLite or let me copy as content". I'm sure they'll let me keep SQLite =) >> So the company does not use any purely native DLLs in their .NET apps? Correct, the company has absolutely 0 DLLs required to copy as content. >> Adding the non-mixed mode assembly to the GAC is problematic and not recommended. Okay, I won't add it to the GAC then. I'll just argue for my point of having it in a Lib folder and copy as content. Thank you for your help! I'll now be signing off. Brad -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Joe Mistachkin Sent: Thursday, July 21, 2011 7:30 PM To: 'General Discussion of SQLite Database' Subject: Re: [sqlite] Cannot add interop assembly Corr > > Yeah that is what I did in the interim to get it to work. > Ok, good. > > The issue being my company does not believe in the DLLs being in a lib folder inside a project. > Their beliefs do not impact how the code needs to be deployed in order to function properly. > > Instead they have a Library folder at the same level of the solution file, and everything is added by ref. > That will work for managed DLLs; however, the SQLite.Interop.dll is a purely native DLL. It cannot be added as a managed reference because it does not contain any managed code or metadata. > > So unless I add it by ref I have to break company coding standards. > So the company does not use any purely native DLLs in their .NET apps? > > Unless it is in the bin, SQLite errors saying it cannot find the interop. > Yes, this is why I suggested that it be added to the project as a "content" file and copied into the "bin" folder for deployment purposes. > > Guess I could add it to the GAC but that also breaks my companys coding standards. > Adding the non-mixed mode assembly to the GAC is problematic and not recommended. > > Isn't it odd that I cannot just add it as a ref? > No, it's not odd, it's a pure native DLL. Adding a reference requires the DLL to be a managed assembly. -- 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] Cannot add interop assembly
Hello, Yeah that is what I did in the interim to get it to work. The issue being my company does not believe in the DLLs being in a lib folder inside a project. Instead they have a Library folder at the same level of the solution file, and everything is added by ref. So unless I add it by ref I have to break company coding standards. Unless it is in the bin, SQLite errors saying it cannot find the interop. Guess I could add it to the GAC but that also breaks my companys coding standards. Isn't it odd that I cannot just add it as a ref? A reference to 'C:\...\SQLite.Interop.dll' could not be added. Please make sure that the file is accessible, and that it is a valid assembly or COM component. Permissions are also ok, user has access to modify/read/etc. Thanks, Brad -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Joe Mistachkin Sent: Thursday, July 21, 2011 6:29 PM To: 'General Discussion of SQLite Database' Subject: Re: [sqlite] Cannot add interop assembly You should not need to add the interop assembly (i.e. SQLite.Interop.dll) as an actual "reference"; however, you may want to add it as a "content" file to your project and set it to be copied to the project output directory. You will want to add a reference to the [managed] "System.Data.SQLite" assembly instead. -- 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] Cannot add interop assembly
Hey, So I am running .Net 4.0 so I downloaded the binarys for 64 bit .Net 4.0, the non-mixed mode ones. If I try adding a reference to the interop visual studio says it can't add it as a reference. Anyone know of a way I can fix this? Thanks, Brad ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users