在Time trigger中使用Azure Functions上的Entity Framework with Dependency Injection。感谢@Kunal Borkar。

验证码：

public class MyTimerFunction
    {
        private readonly MyDbContext dbContext;

        public MyTimerFunction(MyDbContext dbContext)
        {
            this.dbContext = dbContext;
        }

        [FunctionName("MyTimerFunction")]
        public void Run([TimerTrigger("0 * * * * 5"
#if DEBUG
            , RunOnStartup = true
#endif
        )] TimerInfo myTimer, [DurableClient] IDurableOrchestrationClient starter, ILogger log, ExecutionContext context)
        {
            try
            {
                
                var csv = GetCSVDetails.GetCSVContent(Path.Combine(context.FunctionAppDirectory, "Resources", "new_user_credentials.csv"));
                if (csv != null)
                {
                    foreach (var line in csv)
                    {
                        var username = line.Username;

                        // Check if a record with the same username already exists
                        var existingRecord = dbContext.Test.FirstOrDefault(x => x.Username == username);

                        if (existingRecord != null)
                        {
                           
                            log.LogInformation($"Updated existing record for Username: {username}");
                        }
                        else
                        {

                            var test = new Data
                            {
                                Username = username,
                                Password = line.Password,
                                AccesskeyID = line.AccesskeyID,
                                Secretaccesskey = line.Secretaccesskey,
                                Consoleloginlink = line.Consoleloginlink
                            };

                            dbContext.Test.Add(test);
                        }
                    }

                    dbContext.SaveChanges();
                }
                else
                {
                    log.LogWarning(" data is null or invalid.");
                }

                log.LogInformation($"C# Timer trigger function executed at: {DateTime.Now}");
            }
            catch (Exception e)
            {
                log.LogCritical(e.Message);
                log.LogCritical(e.StackTrace);

                if (e.InnerException != null)
                {
                    log.LogCritical("Inner Exception: " + e.InnerException.Message);
                    log.LogCritical("Inner Exception Stack Trace: " + e.InnerException.StackTrace);
                }
            }
        }
    }

public class StartUp : FunctionsStartup
    {
        public override void Configure(IFunctionsHostBuilder builder)
        {
            string connectionString = "Azuresqlconnectionstring";
            builder.Services.AddDbContext<MyDbContext>(
              options => SqlServerDbContextOptionsExtensions.UseSqlServer(options, connectionString));
        }
    }

输出：