Is it possible to perform _session.query on startup file, i am getting error Unable to resolve service for type 'YesSql.ISession'

[yassinsayed]

Is it possible to perform _session.query on startup file, i am getting error Unable to resolve service for type 'YesSql.ISession'

using YesSql;
using YesSql.Sql;

namespace OrchardCore.DCE
{
  public class Startup : StartupBase
    {
   private readonly ISession _session;
        public Startup(ISession session)
        {
            _session = session;
        }
        public override void ConfigureServices(IServiceCollection services)
        {
            **var Documents = _session.Query<D365CEViewModel>().FirstOrDefaultAsync();**
            CE.GetOrganizationServiceClientSecret(Documents);

            services.AddControllers();
            services.AddControllersWithViews();

[hishamco]

It's not resolved yet, the ISession is added in AddDataAccess() you can check this line

OrchardCore/src/OrchardCore/OrchardCore.Data.YesSql/OrchardCoreBuilderExtensions.cs

Line 143 in 339d74b

return session;

[yassinsayed]

i need more help, any by any way

[deanmarcussen]

If you need to get a configuration value from the database you should use an options pattern, and resolve it from an options provider, as it will be built lazily, in the scope that actually needs the value.

Here is an example, which is accessing site settings, you should be able to build on that.

https://github.com/OrchardCMS/OrchardCore/blob/main/src/OrchardCore/OrchardCore.ReCaptcha.Core/Configuration/ReCaptchaSettingsConfiguration.cs

[yassinsayed]

yah, i need the database value in the startup file

[hishamco]

You can use configurations options as Dean mentioned earlier

[yassinsayed]

work thanks for all
below code save my work

public class MyStartupTaskService : ModularTenantEvents
{
    private readonly ILogger<MyStartupTaskService> _logger;

    public MyStartupTaskService(ILogger<MyStartupTaskService> logger)
    {
        _logger = logger;
    }

    public override Task ActivatingAsync()
    {
        _logger.LogInformation("A tenant has been activated.");

        return Task.CompletedTask;
    }
}

[Skrypt]

@yassinsayed Please look at markdown syntax to highlight your code.

```C#
your code
```

[yassinsayed]

with the below i was able to get documents (stored on db) on startup, by registering ModularTenantEvents

public class D365CEGetOrganizationService : ModularTenantEvents
    {
        private readonly ILogger<D365CEGetOrganizationService> _logger;
        private readonly ISession _session;
        private readonly INotifier _notifier;

        private readonly dynamic New;
        private readonly IHtmlLocalizer H;
        private readonly IStringLocalizer S;

        public D365CEGetOrganizationService(
            ISession session,
            INotifier notifier,
            ILogger<D365CEGetOrganizationService> logger,
            IHtmlLocalizer<D365CEGetOrganizationService> htmlLocalizer,
            IStringLocalizer<D365CEGetOrganizationService> stringLocalizer,
            IShapeFactory shapeFactory)
        {
            _session = session;
            _logger = logger;
            _notifier = notifier;

            New = shapeFactory;
            H = htmlLocalizer;
            S = stringLocalizer;
        }
        
        public override async Task<Task> ActivatingAsync()
        {
            var Documents = await _session.Query<D365CEViewModel>().FirstOrDefaultAsync();
            if (Documents != null)
            {
                var _orgService = CE.GetOrganizationServiceClientSecret(
Documents.OrganizationName
                );

                _logger.LogInformation("A tenant has been activated.");
                await _notifier.SuccessAsync(H["Welcome to the .", Documents.OrganizationName]);
            }
            
            return null;
        }
    }

}