public async Task <ActionResult> dropDb()
{
using (ChenDbContext db = new ChenDbContext())
{
await db.Database.EnsureDeletedAsync();
}
return(Ok("drop db successfully"));
}
public async Task <ActionResult> testEager()
{
using (ChenDbContext db = new ChenDbContext(isLazy: true))
{
var user = await db.UserInfo.Include(x => x.Order).Where(x => x.Id == 1).ToListAsync();
return(Ok(user));
}
}
public ActionResult TestQuery()
{
using (ChenDbContext db = new ChenDbContext())
{
var data = db.UserInfo.Where(x => x.Id == 1);
data = data.Where(x => x.lastName == "Chen is number one");
return(Ok(data.ToList()));
//return Ok(data.Select(x => new { x.lastName }).AsNoTracking().ToList());
}
}
public async Task <ActionResult> testdelete()
{
using (ChenDbContext db = new ChenDbContext())
{
UserInfo result = await db.UserInfo.Include(x => x.Order).FirstOrDefaultAsync();
db.UserInfo.Remove(result);
int affected = await db.SaveChangesAsync();
return(Ok($"deleted! {affected} row"));
}
}
public async Task <ActionResult> testLazy()
{
using (ChenDbContext db = new ChenDbContext())
{
List <UserInfo> user = await db.UserInfo.ToListAsync <UserInfo>();
UserInfo userinfo = user[0];
var order = userinfo.Order.Select(x => new { x.OrderId, x.UserId, x.ProductId });
return(Ok(order));
}
}
public async Task <ActionResult> createDb()
{
using (ChenDbContext db = new ChenDbContext())
{
await db.Database.EnsureCreatedAsync();
List <UserInfo> userList = new List <UserInfo>();
userList.Add(new UserInfo {
userName = "******", lastName = "semapat", email = "*****@*****.**"
});
userList.Add(new UserInfo {
userName = "******", lastName = "semapat2", email = "*****@*****.**"
});
userList.Add(new UserInfo {
userName = "******", lastName = "semapat3", email = "*****@*****.**"
});
await db.UserInfo.AddRangeAsync(userList);
await db.SaveChangesAsync();
List <Product> productList = new List <Product>();
productList.Add(new Product {
productName = "Item1", remain = 10, price = 10000
});
productList.Add(new Product {
productName = "Item2", remain = 20, price = 20000
});
productList.Add(new Product {
productName = "Item3", remain = 30, price = 30000
});
await db.Product.AddRangeAsync(productList);
await db.SaveChangesAsync();
List <Order> orderList = new List <Order>();
orderList.Add(new Order {
UserId = 1, ProductId = 1, value = 10
});
orderList.Add(new Order {
UserId = 2, ProductId = 2, value = 20
});
orderList.Add(new Order {
UserId = 1, ProductId = 3, value = 30
});
await db.Order.AddRangeAsync(orderList);
await db.SaveChangesAsync();
}
return(Ok("create db successfully"));
}
