JetEntityFrameworkProvider icon indicating copy to clipboard operation
JetEntityFrameworkProvider copied to clipboard

AnyCPU build

Open channell opened this issue 4 years ago • 4 comments

I need to use a 64-bit version of the library for integration in a database synchronisation server, but the nuget package is x86 only. I've downloaded the code and compiled/tested with x64 using "Microsoft.ACE.OLEDB.16.0"; and works fine with the 64-bit OLEDB provider. There is no change other than targeting AnyCPU and referencing Microsoft.ACE.OLEDB.16.0 in JetEntityFrameworkProvider.Test.Helpers.GetJetConnectionString() I'm happy to checkin (if you like), but would need the nuget package updated.

Excellent libary

channell avatar Apr 25 '20 20:04 channell

The library is compiled for AnyCPU. The Jet OLEDB Provider version (32/64) depends on your installation of the Jet OLEDB Provider (you can have more than one). In my case I'm using the Microsoft.ACE.OLEDB.12.0 64 bit and the Microsoft.ACE.OLEDB.15.0 32 bits but it's my installation. Just specify your right provider in the connection string. About tests, they are related to my installation.

bubibubi avatar Apr 26 '20 07:04 bubibubi

Hi,

Running through my test-cases for x64 executable I hit an image problem exception, which you are correct in asserting would happen if a 32-bit OLEDB provider was loaded, but checking the JetEntityFrameworkProvider assembly with ILSpy reported a x86 target.. recompiling the source with anycpu fixed my issue. Maybe it is my environment, but thought it was worth flagging.

Steve

// C:\Users\steve\source\repos\EA.Gen\packages\JetEntityFrameworkProvider.6.1.4\lib\JetEntityFrameworkProvider.dll // JetEntityFrameworkProvider, Version=6.0.0.0, Culture=neutral, PublicKeyToken=756cf6beb8fe7b41 // Global type: <Module> // Architecture: x86 // Runtime: v4.0.30319 // This assembly is signed with a strong name key. // Hash algorithm: SHA1 // Public key: 0024000004800000940000000602000000240000525341310004000001000100978af4032839a4fb8eff310b6bcf98c19e17ac4e4f03555bf5131a26f326e7b5c10888b62bcb0e62ce55b88ddff9278a6ead913483dd0650d96819090241da543b9d9c81fef66a4c9179d64c0da8f813024bb754f57cfe671aadc78b51c3a55a5c833c9a2c51c5b2a90d25e247f1e0031210a3958ba1758d51d442980a6d5de6

// C:\Users\steve\source\repos\JetEntityFrameworkProvider\Release\JetEntityFrameworkProvider.dll // JetEntityFrameworkProvider, Version=6.0.0.0, Culture=neutral, PublicKeyToken=756cf6beb8fe7b41 // Global type: <Module> // Architecture: AnyCPU (64-bit preferred) // Runtime: v4.0.30319 // This assembly is signed with a strong name key. // Hash algorithm: SHA1 // Public key: 0024000004800000940000000602000000240000525341310004000001000100978af4032839a4fb8eff310b6bcf98c19e17ac4e4f03555bf5131a26f326e7b5c10888b62bcb0e62ce55b88ddff9278a6ead913483dd0650d96819090241da543b9d9c81fef66a4c9179d64c0da8f813024bb754f57cfe671aadc78b51c3a55a5c833c9a2c51c5b2a90d25e247f1e0031210a3958ba1758d51d442980a6d5de6 // Debug info: Loaded from PDB file: C:\Users\steve\source\repos\JetEntityFrameworkProvider\Release\JetEntityFrameworkProvider.pdb

Sent from Mailhttps://go.microsoft.com/fwlink/?LinkId=550986 for Windows 10

From: Bubimailto:[email protected] Sent: 26 April 2020 08:50 To: bubibubi/JetEntityFrameworkProvidermailto:[email protected] Cc: channellmailto:[email protected]; Authormailto:[email protected] Subject: Re: [bubibubi/JetEntityFrameworkProvider] AnyCPU build (#51)

The library is compiled for AnyCPU. The Jet OLEDB Provider version (32/64) depends on your installation of the Jet OLEDB Provider (you can have more than one). In my case I'm using the Microsoft.ACE.OLEDB.12.0 64 bit and the Microsoft.ACE.OLEDB.15.0 32 bits but it's my installation. Just specify your right provider in the connection string. About tests, they are related to my installation.

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHubhttps://github.com/bubibubi/JetEntityFrameworkProvider/issues/51#issuecomment-619503807, or unsubscribehttps://github.com/notifications/unsubscribe-auth/ABNPQ7ONED47NEA7RIHH3YTROPRSTANCNFSM4MQ4QQUQ.

channell avatar Apr 27 '20 08:04 channell

Did you enable "download previews" on NuGet? The latest version is 6.2.0-rc1

bubibubi avatar Apr 27 '20 08:04 bubibubi

No, I’ll do that.. thanks

channell avatar Apr 27 '20 08:04 channell