Home > Mobile >  Windows Forms with Entity Framework crashes on .theninclude() only on published version, not in debu
Windows Forms with Entity Framework crashes on .theninclude() only on published version, not in debu

Time:10-06

Issue: I think the title sums it up, but in more detail, I'm trying to use Entity Framework in a Windows Forms application. It works for all "selects" but not when I try to use .ThenInclude() and to make it even more weird, it only crashes on the published version of it. When I'm debugging, it works perfectly fine. Once I publish it, it crashes on the .ThenInclude()

The error code is the following:

DeepLoadProjects The type initializer for 'Microsoft.Data.SqlClient.TdsParser' threw an exception.System.TypeInitializationException: The type initializer for 'Microsoft.Data.SqlClient.SNILoadHandle' threw an exception. ---> System.TypeInitializationException: The type initializer for 'Microsoft.Data.SqlClient.SNINativeMethodWrapper' threw an exception.

System.ComponentModel.Win32Exception: Failed to load C:\Users\Scott\AppData\Local\Apps\2.0\KD9YXEPJ.DKY\5QCR3OCQ.WRY\vent..tion_098ef6a925fa6387_0001.0009_35951381a6b516d2\x86\SNI.dll

System.ComponentModel.Win32Exception: The specified module could not be found
--- End of inner exception stack trace ---
at Microsoft.Data.SqlClient.SNINativeMethodWrapper..cctor()
--- End of inner exception stack trace ---
at Microsoft.Data.SqlClient.SNINativeMethodWrapper.SNIInitialize()
at Microsoft.Data.SqlClient.SNILoadHandle..ctor()
at Microsoft.Data.SqlClient.SNILoadHandle..cctor()
--- End of inner exception stack trace ---
at Microsoft.Data.SqlClient.TdsParser..cctor()

Here's the method that is crashing ONLY ON PUBLISHED:

public Tprojects DeepLoadProject(int intProjectID)
{
    Tprojects objTiers = new Tprojects();

    try
    {
        RefreshAll();
        objTiers = context.Tprojects
                          .Include(x => x.TprojectItems)
                          .ThenInclude(x => x.IntItem)
                          .Include(x => x.TprojectCustomerCompanies)
                          .ThenInclude(x => x.IntCustomerCompany)
                          .Include(x => x.TprojectCustomerCompanies)
                          .ThenInclude(x => x.TprojectCustomerCompanyContacts)
                          .ThenInclude(x => x.IntContact)
                          .Include(x => x.TprojectItems)
                          .ThenInclude(x => x.TprojectItemCompanyPrices)
                          .ThenInclude(x => x.IntProjectCustomerCompany)
                          .Where(x => x.IntProjectId == intProjectID)
                          .FirstOrDefault();
    }
    catch (Exception ex)
    {
        Show("There was an issue trying to connect to the server, please try again. If this error keeps showing please call an admin for further assistance.");
        SaveErrorLog("DeepLoadProjects "   ex.Message   ex.InnerException, "Hollywood");
    }

    return objTiers;
}

Here's my assembly info and the full error:

See the end of this message for details on invoking 
just-in-time (JIT) debugging instead of this dialog box.

************** Exception Text **************
System.TypeInitializationException: The type initializer for 'Microsoft.Data.SqlClient.TdsParser' threw an exception. ---> System.TypeInitializationException: The type initializer for 'Microsoft.Data.SqlClient.SNILoadHandle' threw an exception. ---> System.TypeInitializationException: The type initializer for 'Microsoft.Data.SqlClient.SNINativeMethodWrapper' threw an exception. ---> System.ComponentModel.Win32Exception: Failed to load C:\Users\Scott\AppData\Local\Apps\2.0\KD9YXEPJ.DKY\5QCR3OCQ.WRY\vent..tion_098ef6a925fa6387_0001.0009_35951381a6b516d2\x86\SNI.dll ---> System.ComponentModel.Win32Exception: The specified module could not be found
   --- End of inner exception stack trace ---
   at Microsoft.Data.SqlClient.SNINativeMethodWrapper..cctor()
   --- End of inner exception stack trace ---
   at Microsoft.Data.SqlClient.SNINativeMethodWrapper.SNIInitialize()
   at Microsoft.Data.SqlClient.SNILoadHandle..ctor()
   at Microsoft.Data.SqlClient.SNILoadHandle..cctor()
   --- End of inner exception stack trace ---
   at Microsoft.Data.SqlClient.TdsParser..cctor()
   --- End of inner exception stack trace ---
   at Microsoft.Data.SqlClient.TdsParser..ctor(Boolean MARS, Boolean fAsynchronous)
   at Microsoft.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(ServerInfo serverInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString connectionOptions, SqlCredential credential, TimeoutTimer timeout)
   at Microsoft.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(TimeoutTimer timeout, SqlConnectionString connectionOptions, SqlCredential credential, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance)
   at Microsoft.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, SqlCredential credential, Object providerInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString userConnectionOptions, SessionData reconnectSessionData, ServerCertificateValidationCallback serverCallback, ClientCertificateRetrievalCallback clientCallback, DbConnectionPool pool, String accessToken, SqlClientOriginalNetworkAddressInfo originalNetworkAddressInfo, Boolean applyTransientFaultHandling, SqlAuthenticationProviderManager sqlAuthProviderManager)
   at Microsoft.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions)
   at Microsoft.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnectionPool pool, DbConnection owningObject, DbConnectionOptions options, DbConnectionPoolKey poolKey, DbConnectionOptions userOptions)
   at Microsoft.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection)
   at Microsoft.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection)
   at Microsoft.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection)
   at Microsoft.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection)
   at Microsoft.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
   at Microsoft.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
   at Microsoft.Data.ProviderBase.DbConnectionClosed.TryOpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
   at Microsoft.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry)
   at Microsoft.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry)
   at Microsoft.Data.SqlClient.SqlConnection.Open()
   at Microsoft.EntityFrameworkCore.Storage.RelationalConnection.OpenDbConnection(Boolean errorsExpected)
   at Microsoft.EntityFrameworkCore.Storage.RelationalConnection.Open(Boolean errorsExpected)
   at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReader(RelationalCommandParameterObject parameterObject)
   at Microsoft.EntityFrameworkCore.Query.Internal.QueryingEnumerable`1.Enumerator.InitializeReader(DbContext _, Boolean result)
   at Microsoft.EntityFrameworkCore.SqlServer.Storage.Internal.SqlServerExecutionStrategy.Execute[TState,TResult](TState state, Func`3 operation, Func`3 verifySucceeded)
   at Microsoft.EntityFrameworkCore.Query.Internal.QueryingEnumerable`1.Enumerator.MoveNext()
   at System.Linq.Enumerable.SingleOrDefault[TSource](IEnumerable`1 source)
   at lambda_method(Closure , QueryContext )
   at Microsoft.EntityFrameworkCore.Query.Internal.QueryCompiler.Execute[TResult](Expression query)
   at Microsoft.EntityFrameworkCore.Query.Internal.EntityQueryProvider.Execute[TResult](Expression expression)
   at System.Linq.Queryable.FirstOrDefault[TSource](IQueryable`1 source)
   at Vents_US_Inventory.modDatabaseUtilities.DeepLoadProject(Int32 intProjectID)
   at Vents_US_Inventory.CRMS_Forms.Projects.ProjectInfo.LoadProjectInfo()
   at Vents_US_Inventory.CRMS_Forms.Projects.ProjectInfo.ProjectInfo_Load(Object sender, EventArgs e)
   at System.Windows.Forms.Form.OnLoad(EventArgs e)
   at System.Windows.Forms.Form.OnCreateControl()
   at System.Windows.Forms.Control.CreateControl(Boolean fIgnoreVisible)
   at System.Windows.Forms.Control.CreateControl()
   at System.Windows.Forms.Control.WmShowWindow(Message& m)
   at System.Windows.Forms.Control.WndProc(Message& m)
   at System.Windows.Forms.ScrollableControl.WndProc(Message& m)
   at System.Windows.Forms.Form.WmShowWindow(Message& m)
   at System.Windows.Forms.Form.WndProc(Message& m)
   at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
   at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
   at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)


************** Loaded Assemblies **************
mscorlib
    Assembly Version: 4.0.0.0
    Win32 Version: 4.8.4515.0 built by: NET48REL1LAST_C
    CodeBase: file:///C:/Windows/Microsoft.NET/Framework/v4.0.30319/mscorlib.dll
----------------------------------------
Vents-US Inventory
    Assembly Version: 1.0.0.0
    Win32 Version: 1.0.0.0
    CodeBase: file:///C:/Users/Scott/AppData/Local/Apps/2.0/KD9YXEPJ.DKY/5QCR3OCQ.WRY/vent..tion_098ef6a925fa6387_0001.0009_35951381a6b516d2/Vents-US Inventory.exe
----------------------------------------
System.Windows.Forms
    Assembly Version: 4.0.0.0
    Win32 Version: 4.8.4550.0 built by: NET48REL1LAST_C
    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Windows.Forms/v4.0_4.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
----------------------------------------
System
    Assembly Version: 4.0.0.0
    Win32 Version: 4.8.4536.0 built by: NET48REL1LAST_C
    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System/v4.0_4.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
System.Drawing
    Assembly Version: 4.0.0.0
    Win32 Version: 4.8.4390.0 built by: NET48REL1LAST_C
    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Drawing/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
----------------------------------------
System.Data
    Assembly Version: 4.0.0.0
    Win32 Version: 4.8.4536.0 built by: NET48REL1LAST_C
    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_32/System.Data/v4.0_4.0.0.0__b77a5c561934e089/System.Data.dll
----------------------------------------
System.Core
    Assembly Version: 4.0.0.0
    Win32 Version: 4.8.4536.0 built by: NET48REL1LAST_C
    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Core/v4.0_4.0.0.0__b77a5c561934e089/System.Core.dll
----------------------------------------
Microsoft.EntityFrameworkCore
    Assembly Version: 3.1.28.0
    Win32 Version: 3.100.2822.36309
    CodeBase: file:///C:/Users/Scott/AppData/Local/Apps/2.0/KD9YXEPJ.DKY/5QCR3OCQ.WRY/vent..tion_098ef6a925fa6387_0001.0009_35951381a6b516d2/Microsoft.EntityFrameworkCore.DLL
----------------------------------------
netstandard
    Assembly Version: 2.0.0.0
    Win32 Version: 4.8.4084.0
    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/netstandard/v4.0_2.0.0.0__cc7b13ffcd2ddd51/netstandard.dll
----------------------------------------
Microsoft.Bcl.AsyncInterfaces
    Assembly Version: 1.0.0.0
    Win32 Version: 4.700.20.21406
    CodeBase: file:///C:/Users/Scott/AppData/Local/Apps/2.0/KD9YXEPJ.DKY/5QCR3OCQ.WRY/vent..tion_098ef6a925fa6387_0001.0009_35951381a6b516d2/Microsoft.Bcl.AsyncInterfaces.DLL
----------------------------------------
System.Threading.Tasks.Extensions
    Assembly Version: 4.2.0.1
    Win32 Version: 4.6.28619.01
    CodeBase: file:///C:/Users/Scott/AppData/Local/Apps/2.0/KD9YXEPJ.DKY/5QCR3OCQ.WRY/vent..tion_098ef6a925fa6387_0001.0009_35951381a6b516d2/System.Threading.Tasks.Extensions.DLL
----------------------------------------
Microsoft.EntityFrameworkCore.SqlServer
    Assembly Version: 3.1.28.0
    Win32 Version: 3.100.2822.36309
    CodeBase: file:///C:/Users/Scott/AppData/Local/Apps/2.0/KD9YXEPJ.DKY/5QCR3OCQ.WRY/vent..tion_098ef6a925fa6387_0001.0009_35951381a6b516d2/Microsoft.EntityFrameworkCore.SqlServer.DLL
----------------------------------------
Microsoft.EntityFrameworkCore.Relational
    Assembly Version: 3.1.28.0
    Win32 Version: 3.100.2822.36309
    CodeBase: file:///C:/Users/Scott/AppData/Local/Apps/2.0/KD9YXEPJ.DKY/5QCR3OCQ.WRY/vent..tion_098ef6a925fa6387_0001.0009_35951381a6b516d2/Microsoft.EntityFrameworkCore.Relational.DLL
----------------------------------------
Microsoft.Extensions.DependencyInjection.Abstractions
    Assembly Version: 3.1.28.0
    Win32 Version: 3.100.2822.36305
    CodeBase: file:///C:/Users/Scott/AppData/Local/Apps/2.0/KD9YXEPJ.DKY/5QCR3OCQ.WRY/vent..tion_098ef6a925fa6387_0001.0009_35951381a6b516d2/Microsoft.Extensions.DependencyInjection.Abstractions.DLL
----------------------------------------
Microsoft.EntityFrameworkCore.Abstractions
    Assembly Version: 3.1.28.0
    Win32 Version: 3.100.2822.36309
    CodeBase: file:///C:/Users/Scott/AppData/Local/Apps/2.0/KD9YXEPJ.DKY/5QCR3OCQ.WRY/vent..tion_098ef6a925fa6387_0001.0009_35951381a6b516d2/Microsoft.EntityFrameworkCore.Abstractions.DLL
----------------------------------------
Microsoft.Extensions.Logging.Abstractions
    Assembly Version: 3.1.28.0
    Win32 Version: 3.100.2822.36305
    CodeBase: file:///C:/Users/Scott/AppData/Local/Apps/2.0/KD9YXEPJ.DKY/5QCR3OCQ.WRY/vent..tion_098ef6a925fa6387_0001.0009_35951381a6b516d2/Microsoft.Extensions.Logging.Abstractions.DLL
----------------------------------------
System.ValueTuple
    Assembly Version: 4.0.0.0
    Win32 Version: 4.8.4084.0
    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.ValueTuple/v4.0_4.0.0.0__cc7b13ffcd2ddd51/System.ValueTuple.dll
----------------------------------------
Microsoft.Extensions.Caching.Abstractions
    Assembly Version: 3.1.28.0
    Win32 Version: 3.100.2822.36305
    CodeBase: file:///C:/Users/Scott/AppData/Local/Apps/2.0/KD9YXEPJ.DKY/5QCR3OCQ.WRY/vent..tion_098ef6a925fa6387_0001.0009_35951381a6b516d2/Microsoft.Extensions.Caching.Abstractions.DLL
----------------------------------------
Microsoft.Extensions.DependencyInjection
    Assembly Version: 3.1.28.0
    Win32 Version: 3.100.2822.36305
    CodeBase: file:///C:/Users/Scott/AppData/Local/Apps/2.0/KD9YXEPJ.DKY/5QCR3OCQ.WRY/vent..tion_098ef6a925fa6387_0001.0009_35951381a6b516d2/Microsoft.Extensions.DependencyInjection.DLL
----------------------------------------
System.Diagnostics.DiagnosticSource
    Assembly Version: 4.0.5.0
    Win32 Version: 4.700.20.21406
    CodeBase: file:///C:/Users/Scott/AppData/Local/Apps/2.0/KD9YXEPJ.DKY/5QCR3OCQ.WRY/vent..tion_098ef6a925fa6387_0001.0009_35951381a6b516d2/System.Diagnostics.DiagnosticSource.DLL
----------------------------------------
System.Transactions
    Assembly Version: 4.0.0.0
    Win32 Version: 4.8.4084.0 built by: NET48REL1
    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_32/System.Transactions/v4.0_4.0.0.0__b77a5c561934e089/System.Transactions.dll
----------------------------------------
Microsoft.Extensions.Logging
    Assembly Version: 3.1.28.0
    Win32 Version: 3.100.2822.36305
    CodeBase: file:///C:/Users/Scott/AppData/Local/Apps/2.0/KD9YXEPJ.DKY/5QCR3OCQ.WRY/vent..tion_098ef6a925fa6387_0001.0009_35951381a6b516d2/Microsoft.Extensions.Logging.DLL
----------------------------------------
Microsoft.Extensions.Options
    Assembly Version: 3.1.28.0
    Win32 Version: 3.100.2822.36305
    CodeBase: file:///C:/Users/Scott/AppData/Local/Apps/2.0/KD9YXEPJ.DKY/5QCR3OCQ.WRY/vent..tion_098ef6a925fa6387_0001.0009_35951381a6b516d2/Microsoft.Extensions.Options.DLL
----------------------------------------
Anonymously Hosted DynamicMethods Assembly
    Assembly Version: 0.0.0.0
    Win32 Version: 4.8.4515.0 built by: NET48REL1LAST_C
    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_32/mscorlib/v4.0_4.0.0.0__b77a5c561934e089/mscorlib.dll
----------------------------------------
System.Configuration
    Assembly Version: 4.0.0.0
    Win32 Version: 4.8.4190.0 built by: NET48REL1LAST_B
    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Configuration/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll
----------------------------------------
System.Xml
    Assembly Version: 4.0.0.0
    Win32 Version: 4.8.4084.0 built by: NET48REL1
    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Xml/v4.0_4.0.0.0__b77a5c561934e089/System.Xml.dll
----------------------------------------
System.EnterpriseServices
    Assembly Version: 4.0.0.0
    Win32 Version: 4.8.4084.0 built by: NET48REL1
    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_32/System.EnterpriseServices/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.EnterpriseServices.dll
----------------------------------------
System.Runtime.Caching
    Assembly Version: 4.0.0.0
    Win32 Version: 4.8.4084.0
    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Runtime.Caching/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Runtime.Caching.dll
----------------------------------------
System.Data.DataSetExtensions
    Assembly Version: 4.0.0.0
    Win32 Version: 4.8.4084.0 built by: NET48REL1
    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Data.DataSetExtensions/v4.0_4.0.0.0__b77a5c561934e089/System.Data.DataSetExtensions.dll
----------------------------------------
System.Numerics
    Assembly Version: 4.0.0.0
    Win32 Version: 4.8.4084.0 built by: NET48REL1
    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Numerics/v4.0_4.0.0.0__b77a5c561934e089/System.Numerics.dll
----------------------------------------
Microsoft.Extensions.Caching.Memory
    Assembly Version: 3.1.28.0
    Win32 Version: 3.100.2822.36305
    CodeBase: file:///C:/Users/Scott/AppData/Local/Apps/2.0/KD9YXEPJ.DKY/5QCR3OCQ.WRY/vent..tion_098ef6a925fa6387_0001.0009_35951381a6b516d2/Microsoft.Extensions.Caching.Memory.DLL
----------------------------------------
Microsoft.Extensions.Primitives
    Assembly Version: 3.1.28.0
    Win32 Version: 3.100.2822.36305
    CodeBase: file:///C:/Users/Scott/AppData/Local/Apps/2.0/KD9YXEPJ.DKY/5QCR3OCQ.WRY/vent..tion_098ef6a925fa6387_0001.0009_35951381a6b516d2/Microsoft.Extensions.Primitives.DLL
----------------------------------------
System.ComponentModel.Annotations
    Assembly Version: 4.2.1.0
    Win32 Version: 4.6.26515.06
    CodeBase: file:///C:/Users/Scott/AppData/Local/Apps/2.0/KD9YXEPJ.DKY/5QCR3OCQ.WRY/vent..tion_098ef6a925fa6387_0001.0009_35951381a6b516d2/System.ComponentModel.Annotations.DLL
----------------------------------------
System.ComponentModel.DataAnnotations
    Assembly Version: 4.0.0.0
    Win32 Version: 4.8.4084.0
    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.ComponentModel.DataAnnotations/v4.0_4.0.0.0__31bf3856ad364e35/System.ComponentModel.DataAnnotations.dll
----------------------------------------
Microsoft.Bcl.HashCode
    Assembly Version: 1.0.0.0
    Win32 Version: 4.700.20.56604
    CodeBase: file:///C:/Users/Scott/AppData/Local/Apps/2.0/KD9YXEPJ.DKY/5QCR3OCQ.WRY/vent..tion_098ef6a925fa6387_0001.0009_35951381a6b516d2/Microsoft.Bcl.HashCode.DLL
----------------------------------------
System.Collections.Immutable
    Assembly Version: 1.2.5.0
    Win32 Version: 4.700.20.21406
    CodeBase: file:///C:/Users/Scott/AppData/Local/Apps/2.0/KD9YXEPJ.DKY/5QCR3OCQ.WRY/vent..tion_098ef6a925fa6387_0001.0009_35951381a6b516d2/System.Collections.Immutable.DLL
----------------------------------------
Microsoft.Extensions.Configuration.Abstractions
    Assembly Version: 3.1.28.0
    Win32 Version: 3.100.2822.36305
    CodeBase: file:///C:/Users/Scott/AppData/Local/Apps/2.0/KD9YXEPJ.DKY/5QCR3OCQ.WRY/vent..tion_098ef6a925fa6387_0001.0009_35951381a6b516d2/Microsoft.Extensions.Configuration.Abstractions.DLL
----------------------------------------
Microsoft.Data.SqlClient
    Assembly Version: 1.13.20136.2
    Win32 Version: 1.13.20136.2
    CodeBase: file:///C:/Users/Scott/AppData/Local/Apps/2.0/KD9YXEPJ.DKY/5QCR3OCQ.WRY/vent..tion_098ef6a925fa6387_0001.0009_35951381a6b516d2/Microsoft.Data.SqlClient.DLL
----------------------------------------

Any and all help is much appreciated. I've been stuck on this issue for far too long.

Thanks!

CodePudding user response:

For future reference, here is what seems to be the issue https://github.com/dotnet/SqlClient/issues/936.

I found a not so great workaround, but it consistently works, so I guess it's not all that bad.

Here's my workaround until they come up with a fix or show me what I did wrong.

The only way I can get it to work is on each device after install, to manually copy and paste the x64 and x86 folders with SNI inside it from the debug in the project files to the application folder "C:\Users\Scott\AppData\Local\Apps\2.0\KD9YXEPJ.DKY\5QCR3OCQ.WRY\vent..tion_098ef6a925fa6387_0001.0009_35951381a6b516d2" for each machine.

for the record, I'm still looking for a better answer :)

  • Related