.NET 6 + EF-Core
Mark
I'm trying to migrate a project to .NET 6 and at the same time add EF Core support, however when I try and access any entities via the context object I get the following error:
System.PlatformNotSupportedException: 'Strings.PlatformNotSupported_DataSqlClient'
Clearly I'm missing something or doing something stupid. I also know the code / EF works fine via my desktop application consuming the same EF Core project.
Are there any documentation / examples I can follow to help me consume an Entity Framework project within my Excel DNA project?
Govert van Drimmelen
--------------------------------------------------
Excel-DNA is now registered on GitHub Sponsors.
With a small monthly contribution you encourage further development and support.
--------------------------------------------------
Hi Mark,
I presume you are running into an issue where the SqlClient is not locating and loading the right additional .dll libraries it requires.
Then it falls back to am implementation that throws this exception.
See
Frequently Asked Questions · dotnet/SqlClient Wiki (github.com)
You might want to see how a net6.0-windows console application ends up looking in the output directory (or directories under it).
If you have the right libraries in the Excel-DNA add-in’s output directory, but still get this error, then maybe you need to locate and preload some library yourself.
If you’re still stuck, it would help to put a little self-contained sample add-in on GitHub that exhibits the problem and we can use as a starting point.
-Govert
--
You received this message because you are subscribed to the Google Groups "Excel-DNA" group.
To unsubscribe from this group and stop receiving emails from it, send an email to exceldna+u...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/exceldna/c8cf6d06-bffc-4a15-8609-31dd020976a2n%40googlegroups.com.
Mark
You might have to bare with me here for a bit .. chances are I'm being an idiot as I try and learn new tech, however:
I created a new console app - Everything worked as expected I was able to query my database without issue. After using NuGet to install Excel DNA and running the code within the plugin / ribbon it reverts to the error reported earlier.
So it appears some part of installing Excel DNA is causing the issues. I'll check the DLLs next but feel something might be happening during the Excel DNA process that is causing these issues.
Henrik Teneberg
I have a similar problem with .NET6 and System.Data.OleDb. I get the same kind of behavior (OleDb stops working when inside an Excel DNA Addin, but works fine on its own). I have tried pointing directly to the .NET6 dll instead of going through the Nuget smartness, without success.
Sample code which returns "System.Data.OleDb is not supported on this platform.":
using System.Data.OleDb;
namespace TestExcelDNAAndSystemDataOleDb
{
public static class MyFunctions
{
[ExcelFunction(Description = "My first .NET function")]
public static string HelloDna(string name)
{
try
{
var myConn = new OleDbConnection("dummy");
return "Hello " + name;
}
catch (Exception ex)
{
return ex.Message;
}
}
}
}
<PropertyGroup>
<TargetFramework>net6.0-windows</TargetFramework>
<ImplicitUsings>enable</ImplicitUsings>
<Nullable>enable</Nullable>
</PropertyGroup>
<ItemGroup>
<PackageReference Include="ExcelDna.AddIn" Version="1.6.0-preview5" />
<PackageReference Include="System.Data.OleDb" Version="6.0.0" />
</ItemGroup>
</Project>
Govert van Drimmelen
Hi Henrik,
Can you try by copying the 6 files under
bin\debug\net6.0-windows\runtimes\win\lib\net6.0
into the directory
bin\debug\net6.0-windows
This will overwrite the default implementation of EFCore (which is giving you the problematic message) with the windows version of the files that you need.
After that I get a new error message:
Format of the initialization string does not conform to specification starting at index 0.
This makes sense given your test and should allow you to get a bit further.
To view this discussion on the web visit https://groups.google.com/d/msgid/exceldna/e1422854-b197-4f85-9db0-972db7d7b628n%40googlegroups.com.
Henrik Teneberg
Glayson Patricio
Govert van Drimmelen
Hi Glayson,
After building, you need to copy these two files into your output directory (which would be something like bin\debug\net6.0-windows\)
- Microsoft.Data.SqlClient.dll from bin\debug\net6.0-windows\runtimes\win\lib\newcoreapp3.1\
- Microsoft.Data.SqlClient.SNI.dll from bin\debug\net6.0-windows\runtimes\win-x64\native\
Every time you rebuild, the first one will be overwritten, so you’ll have to make some post-build plan to automate this.
To view this discussion on the web visit https://groups.google.com/d/msgid/exceldna/99263d3d-b4e9-4207-9958-81fa1aaa548bn%40googlegroups.com.
Glayson Patricio
<Exec Command="copy $(OutDir)\runtimes\win-x64\native\Microsoft.Data.SqlClient.SNI.dll $(OutDir)" />
<Exec Command="copy $(OutDir)\runtimes\win\lib\netcoreapp3.1\Microsoft.Data.SqlClient.dll $(OutDir)" />
</Target>
Enver TOLEUOV
public class ApplicationContext : DbContext
{
public DbSet<User> Users { get; set; } = null!;
protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
{
optionsBuilder.UseSqlite("Data Source=test.db");
}
}
public class User
{
public int Id { get; set; }
public string? Name { get; set; }
public int Age { get; set; }
}
using ExcelDna.Integration.CustomUI;
namespace Ribbon
{
[ComVisible(true)]
public class RibbonController : ExcelRibbon
{
public override string GetCustomUI(string RibbonID)
{
return @"
<customUI xmlns='http://schemas.microsoft.com/office/2009/07/customui'>
<ribbon>
<tabs>
<tab id='tab1' label='PlannerTools'>
<group id='parse_XER' label='Parse XER'>
<button imageMso='CostResourceInsert'
id='button_parse_XER_sqlite'
label='Parse XER SQLite'
onAction='OnButtonPressed_Parse_XER_SQLite'
supertip='Parses content of XER file'
/>
</group>
</tab>
</tabs>
</ribbon>
</customUI>";
}
public void OnButtonPressed_Parse_XER_SQLite(IRibbonControl control)
{
// Not working, throwing Exceptions;
using (ApplicationContext db = new ApplicationContext())
{
User tom = new User { Name = "Tom", Age = 33 };
User alice = new User { Name = "Alice", Age = 26 };
db.Users.Add(tom);
db.Users.Add(alice);
db.SaveChanges();
}
return;
}
}
}