1. 安装
此处使用的是SQL SERVER数据库,.Net 框架式 .Net Core 2.2,由于.Net core 2.2的Microsoft.AspNetCore.App已经集成了对SQL Server的 EF Core 框架,所以不必再进行安装
2. 实例教程
- 增加
#region 保存
/// <summary>
/// 保存
/// </summary>
public void Add()
{
User userModel = new User()
{
CreateTime = DateTime.Now,
UserGroup = "111111",
UserName = "小李",
UserNo = "8440"
};
var resultUserModel = _testContext.User.Add(userModel);
int i = _testContext.SaveChanges();
}
#endregion
#region 异步保存
/// <summary>
/// 异步保存
/// </summary>
public void AddAsync()
{
User userModel = new User()
{
CreateTime = DateTime.Now,
UserGroup = "111111",
UserName = "小李异步保存的",
UserNo = "8440"
};
var resultUserModel = _testContext.User.Add(userModel);
var result = _testContext.SaveChangesAsync();
}
#endregion
#region 批量增加
/// <summary>
/// 批量增加
/// </summary>
private void AddBulk()
{
List<Usergroup> listUsers = new List<Usergroup>();
for (int i = 0; i < 100000; i++)
{
Usergroup UsergroupModel = new Usergroup()
{
CreateTime = DateTime.Now,
GroupId = "111111" + i.ToString(),
GroupName = i.ToString()
};
listUsers.Add(UsergroupModel);
}
var sw = new Stopwatch();
sw.Start();
_testContext.Usergroup.AddRange(listUsers);
_testContext.SaveChanges();
sw.Stop();
var spanTime = sw.Elapsed.TotalSeconds;
//List<User> listUsers = new List<User>();
//for (int i = 0; i < 100000; i++)
//{
// User userModel = new User()
// {
// CreateTime = DateTime.Now,
// UserGroup = "111111",
// UserName = "小李",
// UserNo = i.ToString()