AttachDBFileName fails if the value includes |DataDirectory|

[mikeHag]

I have a WPF Prism application working with Entity Framework Core 2.26. The OnConfiguring method optionsBuilder.UseSqlServer call includes the following in the connect string:
AttachDBFileName=|DataDirectory|\dbfiles\my.mdf;

I created a new project that uses .Net Core 3.0 Preview 9 and Entity Framework Core 3.0 Preview 9. At runtime the same connection string fails. I get a System.ArgumentException with the message "Invalid value for key 'attachdbfilename'."

"|DataDirectory|" appears to be the problem. AttachDBFileName with the full path works fine. If I build up the full path using the value AppDomain.CurrentDomain.BaseDirectory the attach will also work.

[ErikEJ]

.NET Core SqlClient does not expand DataDirectory?

[mikeHag]

Yes, if I use "|DataDirectory|" the connection fails.

[bricelam]

Duplicate of dotnet/SqlClient#16

[mikeHag]

Do not understand the reason for the closure. Code that worked with .Net, EF Core 2.26 and WPF does not work with .Net Core 3.0 Preview 9, EF Core 3.0 Preview 9 and Wpf. Oh well ...

[bricelam]

This is not an issue with EF, but with SqlClient the issue dotnet/SqlClient#16 is tracking the work that needs to be done to fix it.

[bricelam]

Please upvote it and subscribe to it for updates.

[ErikEJ]

My PR to fix this has just been merged, and wil be part of the 1.1 release

[ajcvickers]

@ErikEJ Awesome! Really appreciate your perseverance!