public Data.User Get(int id)
{
Data.User result;
using (var dbContext = new Data.UserContext())
{
result = dbContext.Users.Find(id);
}
return(result);
}
public Data.User Post([FromBody] Data.User value)
{
using (var dbContext = new Data.UserContext())
{
dbContext.Users.Add(value);
dbContext.SaveChanges();
}
return(value);
}
public IEnumerable <Data.User> Get()
{
IEnumerable <Data.User> result;
using (var dbContext = new Data.UserContext())
{
result = dbContext.Users.ToList();
}
return(result);
}
public void Delete(int id)
{
using (var dbContext = new Data.UserContext())
{
var result = dbContext.Users.Find(id);
if (result != null)
{
dbContext.Remove(result);
dbContext.SaveChanges();
}
}
}
private Data.UserContext GetUserContext()
{
var options = new DbContextOptionsBuilder <Data.UserContext>()
.UseInMemoryDatabase(Guid.NewGuid().ToString()).Options;
var context = new Data.UserContext(options);
context.Add(new Models.AppUser {
Id = 1, Name = "check"
});
context.SaveChanges();
return(context);
}
private UserContext GetUserContext()
{
var options = new DbContextOptionsBuilder <Data.UserContext>().UseQueryTrackingBehavior(QueryTrackingBehavior.NoTracking)
.UseInMemoryDatabase(Guid.NewGuid().ToString()).Options;
var userContext = new Data.UserContext(options);
userContext.Users.Add(new AppUser {
Id = 1, Name = "jesse"
});
userContext.SaveChanges();
return(userContext);
}
public Data.User Put(int id, [FromBody] Data.User value)
{
Data.User result;
using (var dbContext = new Data.UserContext())
{
result = dbContext.Users.Find(id);
if (result != null)
{
result.firstName = value.firstName;
result.lastName = value.lastName;
result.updatedAt = DateTimeOffset.Now;
dbContext.SaveChanges();
}
}
return(result);
}
private Data.UserContext GetUserContext()
{
var option = new DbContextOptionsBuilder <Data.UserContext>()
.UseInMemoryDatabase(Guid.NewGuid().ToString())
.Options;
var useContext = new Data.UserContext(option);
useContext.Users.Add(new Models.AppUser
{
Id = 1,
Name = "zhaoyang"
});
useContext.SaveChanges();
return(useContext);
}
