System.Typeloadexception auf sqlconnection.open Methode -Aufruf ⇐ C#

[Anonymous]

Ich habe eine Konsolenanwendung, die einen Verweis auf das Projekt hat, das Paket microsoft.data.sqlclient .

Code: Select all

private IEnumerable GetData(string query)
{
string? connectionString = _configuration.GetConnectionString("DefaultConnection");
Console.WriteLine(connectionString);

if (string.IsNullOrWhiteSpace(connectionString))
{
throw new Exception("Cannot read DefaultConnection connection string");
}

List result = new List();

using (SqlConnection connection = new(connectionString))
{
SqlCommand command = new(query, connection);

connection.Open();
SqlDataReader reader = command.ExecuteReader();

while (reader.Read())
{
result.Add((T)reader["Value"]);
}

reader.Close();
}

return result;
}
< /code>
Alles funktioniert perfekt, wenn ich das Projekt im Debug -Modus ausführe. Microsoft.data.sqlclient.sninativemethodwrapper.sniaddProvider (Snihandle, Providerenum, Authproviderinfo &)

at microsoft.data.sqlclient.tdssparserStateObjectnative. Microsoft.data.sqlclient.tdsparser.enablessl (uint32, sqlConnectionCryption, boolean, String)

bei Microsoft.Data.SQLCLIENT.TDSPARSER.CONSUMEPRELANGELAUS. Boolean, String)

unter microsoft.data.sqlclient.tdsparser.connect (serverInfo, sqlinternalConnectionTds, TimeoutTimer, SQLConnectionString, Boolean)

at Microsoft.data.sqlclient.sqlinternalConnectiontds.attemptonelogin (ServerInfo, String, Securestring, TimeoutTimer, boolean)

bei microsoft.data.sqlclient.sqLinternalConnectionTds.loginnnovernoverfo. SqlConnectionString, SqlCredential,
TimeoutTimer)    at
Microsoft.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(TimeoutTimer,
SqlConnectionString, SqlCredential, String, SecureString, Boolean)

at
Microsoft.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity,
SqlConnectionString, SqlCredential, Object, String, SecureString,
Boolean, SqlConnectionString , SessionData , Boolean , String ,
DbConnectionPool , Func3 )    at Microsoft.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions, DbConnectionPoolKey, Object, DbConnectionPool, DbConnection, DbConnectionOptions)    at Microsoft.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnectionPool, DbConnection, DbConnectionOptions, DbConnectionPoolKey, DbConnectionOptions)    at Microsoft.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection, DbConnectionOptions, DbConnectionInternal)   at Microsoft.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection, DbConnectionOptions, DbConnectionInternal )    at Microsoft.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection, UInt32, Boolean, Boolean, DbConnectionOptions, DbConnectionInternal& ) at Microsoft.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection, TaskCompletionSource< /code> 1, dbConnectionOptions, dbConnectionInternal &)

at
MicroSoft.Data.Providerbase.dbConnectionFactory1, DbConnectionOptions, DbConnectionInternal, DbConnectionInternal& )    at Microsoft.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection, DbConnectionFactory, TaskCompletionSource< /code> 1, dbConnectionOptions)

at
MicroSoft.Data.sqlclient.sqlConnection.tryopen(TaskCompletionsOurce`1,ell /> SQLConnectionOverrids) unter
/>microsoft.data.sqlclient.sqlconnection.open(sqlConnectionOverrids)

unter opcw.vis.xmlgenerator.services.datahelperService.getDatat
in c: \ projects \ vis
MoDernisation\Utility\opcw.vis.xmlgenerator\services\DatahelPerService.cs:line
68 AT
opcw.vis.xmlgenerator.services />MoDernisation\Utility\opcw.vis.xmlgenerator\services\DatahelPerService.cs:line
52 AT Program. />  In dieser Codezeile: < /p>
connection.Open();

Ich habe versucht, nach diesem Beitrag zu suchen. /> Ich habe das getan, aber das hat auch nicht geholfen.>