-
Notifications
You must be signed in to change notification settings - Fork 0
/
UsingMicrosoftDataSqliteSdkStyle.csproj
57 lines (43 loc) · 2.23 KB
/
UsingMicrosoftDataSqliteSdkStyle.csproj
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
<Project Sdk="Microsoft.NET.Sdk">
<PropertyGroup>
<TargetFramework>net6.0-windows</TargetFramework>
<!-- Optionally set this according to the Excel bitness that the add-in will run under.
This can help the right native assemblies to be copied to a runtime-specific output directory,
Note that multiple RuntimeIdentifiers, as specified like
<RuntimerIdentiers>win-x64;win-x86</RuntimeIdentifiers>
is not supported by the .NET SDK build system, unlike the 'TargetFrameworks' which works great.
See https://github.com/dotnet/sdk/issues/9795 and https://github.com/dotnet/sdk/issues/1017
So I use the Solution file's Platform configuration (changed from AnyCPU) to set the RuntimeIdentifier and Excel-DNA output.
-->
<RuntimeIdentifier>win-x64</RuntimeIdentifier>
<!--<RuntimeIdentifier>win-x86</RuntimeIdentifier>-->
<!-- We don't need the extra 'ref' directory and reference assemblies for the Excel add-in -->
<ProduceReferenceAssembly>false</ProduceReferenceAssembly>
<!-- We need all dependencies to be copied to the output directory, as-if we are an 'application' and not a 'library'.
This property also sets the CopyLockFileAssemblies property to true.
-->
<EnableDynamicLoading>true</EnableDynamicLoading>
<!-- I'm commenting these out from the default Class Library template to make the code clearer,
but that's just a personal preference
-->
<!--<ImplicitUsings>enable</ImplicitUsings>-->
<!--<Nullable>enable</Nullable>-->
</PropertyGroup>
<PropertyGroup Condition="'$(RuntimeIdentifier)' == 'win-x64'">
<ExcelDnaCreate32BitAddIn>false</ExcelDnaCreate32BitAddIn>
<ExcelDnaCreate64BitAddIn>true</ExcelDnaCreate64BitAddIn>
</PropertyGroup>
<PropertyGroup Condition="'$(RuntimeIdentifier)' == 'win-x86'">
<ExcelDnaCreate32BitAddIn>true</ExcelDnaCreate32BitAddIn>
<ExcelDnaCreate64BitAddIn>false</ExcelDnaCreate64BitAddIn>
</PropertyGroup>
<ItemGroup>
<PackageReference Include="ExcelDna.AddIn" Version="1.6.0-preview1" />
<PackageReference Include="Microsoft.Data.SQLite" Version="6.0.1" />
</ItemGroup>
<ItemGroup>
<None Update="Data\Northwind.db">
<CopyToOutputDirectory>PreserveNewest</CopyToOutputDirectory>
</None>
</ItemGroup>
</Project>