AnyCPU version of LINQpad v4/v5 cannot load Tx (LINQ to Logs and Traces) LINQpad driver

[Tuatan]

LINQpad v4 AnyCPU edition cannot load Tx (LINQ to Logs and Traces) LINQpad driver.

It will show the following error:

Error instantiating type Tx.LinqPad.TxDataContextDriver in C:\ProgramData\LINQPad\Drivers\DataContext\4.0\Tx.LinqPad (3d3a4b0768c9178e)\Tx.LinqPad.dll

• Could not load file or assembly 'file:///C:\ProgramData\LINQPad\Drivers\DataContext\4.0\Tx.LinqPad (3d3a4b0768c9178e)\Tx.SqlServer.dll' or one of its dependencies. An attempt was made to load a program with an incorrect format.

That is due to mismatch between the processor architecture of the Tx.SqlServer assembly and the processor architecture of the reference "LINQPad", the only workaround is to use x86 version of LINQpad v4 (default one).

[Tuatan]

To fix that we need to create a separate AnyCPU build of Tx LinqPad driver w/o dependencies on Tx.SqlServer library that is being the culprit.

[CIPop]

+1 /cc @abhipsaMisra @davilu @prmathur-microsoft