使用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 = ...

推荐文章

淡定的仙人球 · Uncaught runtime errors: × ERROR Unknown promise rejection reason at handleError (webpack-intern

5 月前

幸福的帽子 · ConnectionError: (‘Connection aborted.‘, ConnectionResetError(10054, ‘远程主机强迫关闭了一个现有的连接。‘, None, 1005

11 月前

骑白马的葡萄 · 【唐博士带你学AI】使用OpenCV实现YOLO目标检测，这绝对是最适合小白入门学习的计算机视觉课程！_哔哩哔哩_bilibili

1 年前

胡子拉碴的大象 · Excel的王炸组合来了，数据透视表+切片器，天下无敌_图表_字段_动态

1 年前

爱玩的馒头 · Floating Photocatalysts for Effluent Refinement Based on Stable Pickering Cellulose Foams and Graphitic Carbon Nitride (g-C3N4) -

1 年前

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

回答 2

Code Review用户

Code Review用户