在调用 Db.CodeFirst.InitTables(@"xxx.xxx.models"); 显示System.IO.FileNotFoundException: Could not load file or assembly

[PSC-F]

Warning

在Aspire 中引入 SqlSugar 初始化数据库表结构，调用按指定命名空间初始化表时找不到程序集

• 使用版本

<PackageReference Include="SqlSugarCore" Version="5.1.4.152" />

• 堆栈

An unhandled exception has occurred while executing the request.
      System.IO.FileNotFoundException: Could not load file or assembly 'ZhangPengFei.IoT.ApiService.Model, Culture=neutral, PublicKeyToken=null'. 系统找不到指定的文件。
      File name: 'ZhangPengFei.IoT.ApiService.Model, Culture=neutral, PublicKeyToken=null'
         at System.Reflection.RuntimeAssembly.InternalLoad(AssemblyName assemblyName, StackCrawlMark& stackMark, AssemblyLoadContext assemblyLoadContext, RuntimeAssembly requestingAssembly, Boolean throwOnFileNotFound)
         at System.Reflection.Assembly.Load(String assemblyString)
         at SqlSugar.CodeFirstProvider.InitTables(String entitiesNamespace)
         at ZhangPengFei.IoT.ApiService.DataBase.DataBaseManager.BuildWithMySQL() in C:\Users\doudo\RiderProjects\Aspire.IoT\AspireIoT\ZhangPengFei.IoT.ApiService\DataBase\DataBaseManager.cs:line 40
         at ZhangPengFei.IoT.ApiService.EndPoints.GateWayEndPoints.Services.GateWayService..ctor(MySqlDataSource dataSource) in C:\Users\doudo\RiderProjects\Aspire.IoT\AspireIoT\ZhangPengFei.IoT.ApiService\EndPoints\GateWayEndPoints\Services\GateWayService.cs:line 11
         at System.RuntimeMethodHandle.InvokeMethod(Object target, Void** arguments, Signature sig, Boolean isConstructor)
         at System.Reflection.MethodBaseInvoker.InvokeDirectByRefWithFewArgs(Object obj, Span`1 copyOfArgs, BindingFlags invokeAttr)
         at System.Reflection.MethodBaseInvoker.InvokeWithOneArg(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
         at System.Reflection.RuntimeConstructorInfo.Invoke(BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
         at Microsoft.Extensions.DependencyInjection.ServiceLookup.CallSiteRuntimeResolver.VisitConstructor(ConstructorCallSite constructorCallSite, RuntimeResolverContext context)
         at Microsoft.Extensions.DependencyInjection.ServiceLookup.CallSiteVisitor`2.VisitCallSiteMain(ServiceCallSite callSite, TArgument argument)
         at Microsoft.Extensions.DependencyInjection.ServiceLookup.CallSiteRuntimeResolver.VisitDisposeCache(ServiceCallSite transientCallSite, RuntimeResolverContext context)
         at Microsoft.Extensions.DependencyInjection.ServiceLookup.CallSiteVisitor`2.VisitCallSite(ServiceCallSite callSite, TArgument argument)
         at Microsoft.Extensions.DependencyInjection.ServiceLookup.CallSiteRuntimeResolver.Resolve(ServiceCallSite callSite, ServiceProviderEngineScope scope)
         at Microsoft.Extensions.DependencyInjection.ServiceLookup.DynamicServiceProviderEngine.<>c__DisplayClass2_0.<RealizeService>b__0(ServiceProviderEngineScope scope)
         at Microsoft.Extensions.DependencyInjection.ServiceProvider.GetService(ServiceIdentifier serviceIdentifier, ServiceProviderEngineScope serviceProviderEngineScope)
         at Microsoft.Extensions.DependencyInjection.ServiceLookup.ServiceProviderEngineScope.GetService(Type serviceType)
         at Microsoft.Extensions.DependencyInjection.ServiceProviderServiceExtensions.GetRequiredService(IServiceProvider provider, Type serviceType)
         at lambda_method4(Closure, Object, HttpContext)
         at Microsoft.AspNetCore.Diagnostics.ExceptionHandlerMiddlewareImpl.Invoke(HttpContext context)

• 临时解决方案

Db.DbMaintenance.CreateDatabase();
        // todo: bug System.IO.FileNotFoundException: Could not load file or assembly
        // Db.CodeFirst.InitTables(@"ZhangPengFei.IoT.ApiService.Model");
        // todo: fix init tables
        Assembly assembly = Assembly.GetExecutingAssembly();
        var types = assembly.GetTypes().Where(t => t.Namespace == typeof(GateWay).Namespace).ToArray();
        Db.CodeFirst.InitTables(types);
    

[DotNetNext]

不要用这个方法，建议用这种

[DotNetNext]

string重载只是用的微软底层方法，可能不能跨程序集。

[PSC-F]

string重载只是用的微软底层方法，可能不能跨程序集。

好的，知道了感谢 👍