/// <summary> /// 随机向数据库添加数据EFCore /// </summary> public void AddData() { try { ClubseasonDrawboxreceive model = _context.ClubseasonDrawboxreceive.FirstOrDefault(i => i.Areaid == 100); model.Id = 0; //事务 using (var transaction = _context.Database.BeginTransaction()) { for (int i = 0; i < 10000 * 500; i++) { var info = model; info.Id = 0; info.endtime = DateTime.Now; info.opentime = DateTime.Now; Random random = new Random(); info.Gameno = DateTime.Now.ToString("yyyyMMddHHmmssfffff"); info.Uid = random.Next(1000, 3000); info.Clubid = random.Next(100000, 100020); _context.Add(info); info = null; logger.LogInformation($"第{i}条"); _context.SaveChanges(); } transaction.CommitAsync(); } } catch (Exception e) { logger.LogError($"{e.Message}"); } }
public async Task <IActionResult> Create([Bind("FirstName,LastName,PassportData,Email,Password,UserRole,ID")] User user) { if (ModelState.IsValid) { _context.Add(user); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } return(View(user)); }
public async Task <IActionResult> Create([Bind("Name,ID")] TrainStation trainStation) { if (ModelState.IsValid) { _context.Add(trainStation); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } return(View(trainStation)); }
public async Task <IActionResult> Create([Bind("bID,bAuthor,bTitle,bContent,bCreateTime,bReadNum,bCommentNum,cID")] BlogArticle blogArticle) { if (ModelState.IsValid) { _context.Add(blogArticle); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } return(View(blogArticle)); }
public async Task <IActionResult> Create([Bind("TrainId,TripDate,ID")] Trip trip) { if (ModelState.IsValid) { _context.Add(trip); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } ViewData["TrainId"] = new SelectList(_context.Trains, "ID", "ID", trip.TrainId); return(View(trip)); }
public int Create(AppUser appUser) { appUser.CreateDateTime = appUser.UpdateDateTime = DateTime.UtcNow; appUser.LastLoggedInDate = appUser.CreateDateTime; using (var db = new MySqlDbContext(_options.MySqlConnectionString)) { var addedAppUser = db.Add(appUser); db.SaveChanges(); return(addedAppUser.Entity.AppUserId); } }
public async Task <IActionResult> Create([Bind("TeamName,City,Province,Country")] Team team) { if (ModelState.IsValid) { _context.Add(team); _mysqlContext.Add(team); await _context.SaveChangesAsync(); await _mysqlContext.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } return(View(team)); }
public async Task <IActionResult> Create([Bind("PlayerId,FirstName,LastName,Position,TeamName")] Player player) { if (ModelState.IsValid) { _context.Add(player); _mysqlContext.Add(player); await _context.SaveChangesAsync(); await _mysqlContext.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } ViewData["TeamName"] = new SelectList(_context.Teams, "TeamName", "TeamName", player.TeamName); return(View(player)); }
/// <summary> /// 测试性能,建议删除 /// </summary> /// <param name="len"></param> /// <returns></returns> public long InsertTset(int len) { int n = 0; var sb = new StringBuilder(" EF 与Dapper常用方法性能分析 : \n"); Log logEntity1 = new Log() { Id = GuidUtils.GuId(), Date = DateTime.Now, Account = "admin", NickName = "超级管理员", OrganizeId = "2020101619392209546893", Type = "SQL", IPAddress = "171.110.40.191", IPAddressName = "中国广西壮族自治区玉林市", ModuleName = "Log", Result = true, Description = "SQL语句:update Sys_Role set EnabledMark=1 ,LastModifyUserId='2020100517554098226223',LastModifyTime=@LastModifyTime where id in ('2019091721053342871332')", DeleteMark = false, EnabledMark = true, CreatorTime = DateTime.Now, CreatorUserId = "9f2ec079-7d0f-4fe2-90ab-8b09a8302aba" }; using (var content = new MySqlDbContext()) { content.Add <Log>(logEntity1);; } Log logEntity2 = new Log() { Id = GuidUtils.GuId(), Date = DateTime.Now, Account = "admin", NickName = "超级管理员", OrganizeId = "2020101619392209546893", Type = "SQL", IPAddress = "171.110.40.191", IPAddressName = "中国广西壮族自治区玉林市", ModuleName = "Log", Result = true, Description = "SQL语句:update Sys_Role set EnabledMark=1 ,LastModifyUserId='2020100517554098226223',LastModifyTime=@LastModifyTime where id in ('2019091721053342871332')", DeleteMark = false, EnabledMark = true, CreatorTime = DateTime.Now, CreatorUserId = "9f2ec079-7d0f-4fe2-90ab-8b09a8302aba" }; Stopwatch stopwatch = new Stopwatch(); Stopwatch stopwatch1 = new Stopwatch(); Stopwatch stopwatch2 = new Stopwatch(); Stopwatch stopwatch3 = new Stopwatch(); Stopwatch stopwatch4 = new Stopwatch(); Stopwatch stopwatch5 = new Stopwatch(); Stopwatch stopwatch6 = new Stopwatch(); Stopwatch stopwatch7 = new Stopwatch(); Stopwatch stopwatch8 = new Stopwatch(); Stopwatch stopwatch9 = new Stopwatch(); Stopwatch stopwatch10 = new Stopwatch(); Stopwatch stopwatch11 = new Stopwatch(); Stopwatch stopwatch12 = new Stopwatch(); Stopwatch stopwatch13 = new Stopwatch(); Stopwatch stopwatch14 = new Stopwatch(); stopwatch.Start(); //DapperConn.Insert<Log>(logEntity1); stopwatch.Stop(); sb.Append("Dapper 单条数据插入Insert耗时:" + (stopwatch.ElapsedMilliseconds + " 毫秒\n")); stopwatch1.Start(); Add(logEntity2); stopwatch1.Stop(); sb.Append("EF 单条数据插入Add耗时:" + (stopwatch1.ElapsedMilliseconds + " 毫秒\n")); logEntity1.DeleteMark = false; logEntity1.LastModifyTime = DateTime.Now; logEntity2.DeleteMark = false; logEntity2.LastModifyTime = DateTime.Now; stopwatch2.Start(); Update(logEntity1); stopwatch2.Stop(); sb.Append("Dapper 单条数据更新Update耗时:" + (stopwatch2.ElapsedMilliseconds + " 毫秒\n")); stopwatch3.Start(); Edit(logEntity2); stopwatch3.Stop(); sb.Append("EF 单条数据更新Edit耗时:" + (stopwatch3.ElapsedMilliseconds + " 毫秒\n")); List <Log> logList = new List <Log>(); List <Log> logList2 = new List <Log>(); List <Log> logList3 = new List <Log>(); List <Log> logList4 = new List <Log>(); List <Log> logList5 = new List <Log>(); while (n < len.ToInt()) { Log logEntity = new Log() { Id = GuidUtils.GuId(), Date = DateTime.Now, Account = "admin", NickName = "超级管理员", OrganizeId = "2020101619392209546893", Type = "SQL", IPAddress = "171.110.40.191", IPAddressName = "中国广西壮族自治区玉林市", ModuleName = "Log", Result = true, Description = "SQL语句:update Sys_Role set EnabledMark=1 ,LastModifyUserId='2020100517554098226223',LastModifyTime=@LastModifyTime where id in ('2019091721053342871332')", DeleteMark = false, EnabledMark = true, CreatorTime = DateTime.Now, CreatorUserId = "9f2ec079-7d0f-4fe2-90ab-8b09a8302aba" }; logList.Add(logEntity); Log logEntity3 = new Log() { Id = GuidUtils.GuId(), Date = DateTime.Now, Account = "admin", NickName = "超级管理员", OrganizeId = "2020101619392209546893", Type = "SQL", IPAddress = "171.110.40.191", IPAddressName = "中国广西壮族自治区玉林市", ModuleName = "Log", Result = true, Description = "SQL语句:update Sys_Role set EnabledMark=1 ,LastModifyUserId='2020100517554098226223',LastModifyTime=@LastModifyTime where id in ('2019091721053342871332')", DeleteMark = false, EnabledMark = true, CreatorTime = DateTime.Now, CreatorUserId = "9f2ec079-7d0f-4fe2-90ab-8b09a8302aba" }; logList2.Add(logEntity3); Log logEntity4 = new Log() { Id = GuidUtils.GuId(), Date = DateTime.Now, Account = "admin", NickName = "超级管理员", OrganizeId = "2020101619392209546893", Type = "SQL", IPAddress = "171.110.40.191", IPAddressName = "中国广西壮族自治区玉林市", ModuleName = "Log", Result = true, Description = "SQL语句:update Sys_Role set EnabledMark=1 ,LastModifyUserId='2020100517554098226223',LastModifyTime=@LastModifyTime where id in ('2019091721053342871332')", DeleteMark = false, EnabledMark = true, CreatorTime = DateTime.Now, CreatorUserId = "9f2ec079-7d0f-4fe2-90ab-8b09a8302aba" }; logList3.Add(logEntity4); Log logEntity5 = new Log() { Id = GuidUtils.GuId(), Date = DateTime.Now, Account = "admin", NickName = "超级管理员", OrganizeId = "2020101619392209546893", Type = "SQL", IPAddress = "171.110.40.191", IPAddressName = "中国广西壮族自治区玉林市", ModuleName = "Log", Result = true, Description = "SQL语句:update Sys_Role set EnabledMark=1 ,LastModifyUserId='2020100517554098226223',LastModifyTime=@LastModifyTime where id in ('2019091721053342871332')", DeleteMark = false, EnabledMark = true, CreatorTime = DateTime.Now, CreatorUserId = "9f2ec079-7d0f-4fe2-90ab-8b09a8302aba" }; logList4.Add(logEntity5); Log logEntity6 = new Log() { Id = GuidUtils.GuId(), Date = DateTime.Now, Account = "admin", NickName = "超级管理员", OrganizeId = "2020101619392209546893", Type = "SQL", IPAddress = "171.110.40.191", IPAddressName = "中国广西壮族自治区玉林市", ModuleName = "Log", Result = true, Description = "SQL语句:update Sys_Role set EnabledMark=1 ,LastModifyUserId='2020100517554098226223',LastModifyTime=@LastModifyTime where id in ('2019091721053342871332')", DeleteMark = false, EnabledMark = true, CreatorTime = DateTime.Now, CreatorUserId = "9f2ec079-7d0f-4fe2-90ab-8b09a8302aba" }; logList5.Add(logEntity6); n++; } string sql = "insert into Sys_Log ([Date], [Account], [NickName], [OrganizeId], [Type], [IPAddress], [IPAddressName], [ModuleId], [ModuleName], [Result], [Description], [DeleteMark], [EnabledMark], [CreatorTime], [CreatorUserId], [LastModifyTime], [LastModifyUserId], [DeleteTime], [DeleteUserId], [Id]) values (@Date, @Account, @NickName, @OrganizeId, @Type, @IPAddress, @IPAddressName, @ModuleId, @ModuleName, @Result, @Description, @DeleteMark, @EnabledMark, @CreatorTime, @CreatorUserId, @LastModifyTime, @LastModifyUserId, @DeleteTime, @DeleteUserId, @Id)"; stopwatch4.Start(); DbContext.BulkInsert <Log>(logList); stopwatch4.Stop(); sb.Append("使用BulkInsert批量插入" + n + "条数据耗时:" + (stopwatch4.ElapsedMilliseconds + " 毫秒\n")); stopwatch5.Start(); DbContext.AddRange <Log>(logList3); stopwatch5.Stop(); sb.Append("EF 批量插入" + n + "条数据AddRange耗时:" + (stopwatch5.ElapsedMilliseconds + " 毫秒\n")); //stopwatch6.Start(); //conn.Insert(logList4); //stopwatch6.Stop(); //sb.Append("Dapper 批量插入" + n + "条数据Insert批量耗时:" + (stopwatch6.ElapsedMilliseconds + " 毫秒\n")); stopwatch7.Start(); DapperConn.Execute(sql, logList5); stopwatch7.Stop(); sb.Append("Dapper 批量插入" + n + "条数据ExecuteAsync耗时:" + (stopwatch7.ElapsedMilliseconds + " 毫秒\n")); List <Log> newlogList = new List <Log>(); foreach (Log item in logList) { Log info = new Log(); info = item; info.LastModifyTime = DateTime.Now; info.Description += item.Description + item.Description + "更新数据"; newlogList.Add(info); } Stopwatch stopwatch15 = new Stopwatch(); stopwatch15.Start(); // Update(newlogList); stopwatch15.Stop(); sb.Append("Dapper批量更新" + n + "条数据Update耗时:" + (stopwatch15.ElapsedMilliseconds + " 毫秒\n")); stopwatch8.Start(); DbContext.EditRange <Log>(newlogList); stopwatch8.Stop(); sb.Append("EF 批量更新" + n + "条数据EditRange耗时:" + (stopwatch8.ElapsedMilliseconds + " 毫秒\n")); stopwatch9.Start(); Get(logEntity1.Id); stopwatch9.Stop(); sb.Append("Dapper 查询单个实体Get耗时:" + (stopwatch9.ElapsedMilliseconds + " 毫秒\n")); stopwatch10.Start(); DbContext.GetDbSet <Log>().Find(logEntity1.Id); stopwatch10.Stop(); sb.Append("Ef查询单个实体Find耗时:" + (stopwatch10.ElapsedMilliseconds + " 毫秒\n")); sql = $"select * from sys_Log where Id='" + logEntity1.Id + "'"; stopwatch11.Start(); DbContext.GetDbSet <Log>().FromSqlRaw <Log>(sql).FirstOrDefaultAsync <Log>(); stopwatch11.Stop(); sb.Append("Ef查询单个实体FromSqlRaw FirstOrDefaultAsync耗时:" + (stopwatch11.ElapsedMilliseconds + " 毫秒\n")); PagerInfo pagerInfo = new PagerInfo { CurrenetPageIndex = 1, PageSize = 50 }; stopwatch12.Start(); List <Log> list = FindWithPager("", pagerInfo, "CreatorTime", true); PageResult <LogOutputDto> pageResult = new PageResult <LogOutputDto> { CurrentPage = pagerInfo.CurrenetPageIndex, Items = list.MapTo <LogOutputDto>(), ItemsPerPage = pagerInfo.PageSize, TotalItems = pagerInfo.RecordCount }; stopwatch12.Stop(); sb.Append("Dapper 分页查询耗时:" + (stopwatch12.ElapsedMilliseconds + " 毫秒\n")); stopwatch13.Start(); List <Log> list2 = GetByPagination(m => true, pagerInfo, true).ToList <Log>(); PageResult <LogOutputDto> pageResult2 = new PageResult <LogOutputDto> { CurrentPage = pagerInfo.CurrenetPageIndex, Items = list2.MapTo <LogOutputDto>(), ItemsPerPage = pagerInfo.PageSize, TotalItems = pagerInfo.RecordCount }; stopwatch13.Stop(); sb.Append("EF 分页查询耗时:" + (stopwatch13.ElapsedMilliseconds + " 毫秒\n")); stopwatch.Start(); sql = $"select * from Sys_log"; string[] orderBys = { "CreatorTime desc" }; stopwatch14.Start(); PageResult <Log> list3 = DbContext.SqlQueryByPagination <Log>(sql, orderBys, 1, 50); //PageResult<LogOutputDto> pageResult2 = new PageResult<LogOutputDto> //{ // CurrentPage = pagerInfo.CurrenetPageIndex, // Items = list2.MapTo<LogOutputDto>(), // ItemsPerPage = pagerInfo.PageSize, // TotalItems = pagerInfo.RecordCount //}; stopwatch14.Stop(); sb.Append("EF 分页查询耗时:" + (stopwatch14.ElapsedMilliseconds + " 毫秒\n")); Log4NetHelper.Info(sb.ToString()); return(1); }