Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>The similar problem exists with Oracle's ODP.NET vis-a-vis native 32/64-bit OCI DLLs.</p> <p>We have solved it by crating both 'x86' and 'x64' platform for our project and then manually editing our project file to use the conditional references:</p> <pre><code>&lt;Choose&gt; &lt;When Condition="'$(Platform)' == 'x64'"&gt; &lt;ItemGroup&gt; &lt;Reference Include="Oracle.DataAccess, processorArchitecture=x64"&gt; &lt;SpecificVersion&gt;False&lt;/SpecificVersion&gt; &lt;HintPath&gt;..\ThirdParty\ODP.NET\x64\Oracle.DataAccess.dll&lt;/HintPath&gt; &lt;/Reference&gt; &lt;Content Include="..\ThirdParty\ODP.NET\x64\oci.dll"&gt; &lt;Link&gt;oci.dll&lt;/Link&gt; &lt;CopyToOutputDirectory&gt;PreserveNewest&lt;/CopyToOutputDirectory&gt; &lt;/Content&gt; &lt;Content Include="..\ThirdParty\ODP.NET\x64\orannzsbb11.dll"&gt; &lt;Link&gt;orannzsbb11.dll&lt;/Link&gt; &lt;CopyToOutputDirectory&gt;PreserveNewest&lt;/CopyToOutputDirectory&gt; &lt;/Content&gt; &lt;Content Include="..\ThirdParty\ODP.NET\x64\oraociei11.dll"&gt; &lt;Link&gt;oraociei11.dll&lt;/Link&gt; &lt;CopyToOutputDirectory&gt;PreserveNewest&lt;/CopyToOutputDirectory&gt; &lt;/Content&gt; &lt;Content Include="..\ThirdParty\ODP.NET\x64\OraOps11w.dll"&gt; &lt;Link&gt;OraOps11w.dll&lt;/Link&gt; &lt;CopyToOutputDirectory&gt;PreserveNewest&lt;/CopyToOutputDirectory&gt; &lt;/Content&gt; &lt;/ItemGroup&gt; &lt;/When&gt; &lt;When Condition="'$(Platform)' == 'x86'"&gt; &lt;ItemGroup&gt; &lt;Reference Include="Oracle.DataAccess, processorArchitecture=x86"&gt; &lt;SpecificVersion&gt;False&lt;/SpecificVersion&gt; &lt;HintPath&gt;..\ThirdParty\ODP.NET\x86\Oracle.DataAccess.dll&lt;/HintPath&gt; &lt;/Reference&gt; &lt;Content Include="..\ThirdParty\ODP.NET\x86\oci.dll"&gt; &lt;Link&gt;oci.dll&lt;/Link&gt; &lt;CopyToOutputDirectory&gt;PreserveNewest&lt;/CopyToOutputDirectory&gt; &lt;/Content&gt; &lt;Content Include="..\ThirdParty\ODP.NET\x86\orannzsbb11.dll"&gt; &lt;Link&gt;orannzsbb11.dll&lt;/Link&gt; &lt;CopyToOutputDirectory&gt;PreserveNewest&lt;/CopyToOutputDirectory&gt; &lt;/Content&gt; &lt;Content Include="..\ThirdParty\ODP.NET\x86\oraociei11.dll"&gt; &lt;Link&gt;oraociei11.dll&lt;/Link&gt; &lt;CopyToOutputDirectory&gt;PreserveNewest&lt;/CopyToOutputDirectory&gt; &lt;/Content&gt; &lt;Content Include="..\ThirdParty\ODP.NET\x86\OraOps11w.dll"&gt; &lt;Link&gt;OraOps11w.dll&lt;/Link&gt; &lt;CopyToOutputDirectory&gt;PreserveNewest&lt;/CopyToOutputDirectory&gt; &lt;/Content&gt; &lt;/ItemGroup&gt; &lt;/When&gt; &lt;/Choose&gt; </code></pre> <p>This enabled us to avoid using 2 different projects. I'm sure you can do something similar for SQLite.</p>
    singulars
    1. This table or related slice is empty.
    1. POOptions for using System.Data.SQLite in a 32bit and 64bit C# world
      singulars
      1. PTQuestion
    1. PTAnswer
    1. This table or related slice is empty.
    1. USBranko Dimitrijevic
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COYeah that is a much more difficult to maintain solution because manually hacking the project files create hidden information that not all developers that come along will be aware of, that is why we have opt'd for the dual projects to accomplish this over hacking a file. Also still has a two DLL's to manage as the output.
      singulars
      1. PO
      1. USRodney S. Foley
    2. COThis is just a variation of Option 3 with the same results. The goal of the question was finding NEW option with NEW results that gets you an ANY CPU platform target build that works with SQLite as a dependency.
      singulars
      1. PO
      1. USRodney S. Foley
    3. CO@Rodney The goal of this solution is to avoid 2 projects, and in that sense it is "new". I never claimed it will be able to achieve "Any CPU". BTW, this is not really "hacking" - this is well-documented MSBuild syntax. If your project is at the root of project hierarchy then having 2 projects may well be a cleaner solution. If however, it is under the 10 or so levels of dependencies (as it is in our case), then I believe it is well worth avoiding to have to duplicate all the dependencies.
      singulars
      1. PO
      1. USBranko Dimitrijevic
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload