使用LINQ优化数据库访问开发者社区

文章/答案/技术大牛

发布

    public async Task UpdateEmailTable(IEnumerable students)
        Console.WriteLine("Updating Email table");
        var studentEmails = students.ToList();
        int totalStudents = studentEmails.Count;
        int currentCount = 0;
        float lastPercentage = -1;
        foreach (var student in studentEmails)
            var isIn = await _context.BarcDemoGraphicEmail.AnyAsync(z => z.Sridentifier == student.StudentId);
            if (!isIn)
                var ar = await _context.Barcaccount.FirstOrDefaultAsync(z => z.SrIdentifier == student.StudentId);
                await _context.BarcDemoGraphicEmail.AddAsync(new BarcDemoGraphicEmail
                    Sridentifier = student.StudentId,
                    Email = student.EmailAddress,
                    Updatedate = DateTime.Now,
                    Aridentifier = ar == null ? "" : ar.ArIdentifier
                var rec = await _context.BarcDemoGraphicEmail.Where(z => z.Sridentifier == student.StudentId)
                    .FirstAsync();
                rec.Email = student.EmailAddress;
                rec.Updatedate = DateTime.Now;
            await _context.SaveChangesAsync();
            int percentage = (int)Math.Round((float)currentCount / totalStudents * 100);
            if (lastPercentage != percentage) Console.Write("\r" + percentage + "%");
            lastPercentage = percentage;
            currentCount++;
    }

var rec = await _context.BarcDemoGraphicEmail
    .FirstOrDefaultAsync(z => z.Sridentifier == student.StudentId);
if (rec == null)
    var ar = ...

推荐文章

侠义非凡的闹钟 · logstash+mongodb插件子查询怎么实现？_logstash 子查询无序-CSDN博客

1 年前

满身肌肉的野马 · python 获取网页指定内容-掘金

2 年前

含蓄的斑马 · Java 命令行交互输入库 JLine_sun_ting_chuan的博客-CSDN博客

2 年前

文雅的小蝌蚪 · android - PeriodicWorkRequest Does not Work No Matter What - Stack Overflow

2 年前

满身肌肉的冲锋衣 · js脚本数组Array长度可动态增长_js数组长度暴增_葉無聞的博客-CSDN博客

2 年前

问 使用LINQ优化数据库访问 EN

回答 2

Code Review用户

Code Review用户