public async void test2()
{
using (var scope = new AppDbScope())
{
var ret = await scope.AppDb.Set <Sequence>().FromSql("select * from Sequence").FirstOrDefaultAsync();
}
}
public async void DapperTest()
{
using (var scope = new AppDbScope())
{
scope.AppDb.Users.Add(new Users {
age = 10, name = "jack"
});
await scope.AppDb.SaveChangesAsync();
}
}
public void EfInsertTest()
{
using (var scope = new AppDbScope())
{
var _unitOfWork = scope._scope.ServiceProvider.GetService <IUnitOfWork>();
var userRepo = _unitOfWork.GetRepository <Users>();
int age = new Random(10).Next(1, 100);
userRepo.Insert(new Users {
age = age, name = "jack" + age
});
_unitOfWork.SaveChanges();
}
}
public void AppDbAdd()
{
using (var scope = new AppDbScope())
{
scope.AppDb.Add(new Users {
age = 20, name = "jack"
});
scope.AppDb.Add(new Users {
age = 30, name = "jack2"
});
scope.AppDb.Add(new Sequence());
scope.AppDb.SaveChanges();
}
}
public async void test()
{
var sequence1 = new Sequence {
};
var sequence2 = new Sequence {
};
using (var scope = new AppDbScope())
{
scope.AppDb.Sequence.AddRange(new[] { sequence1, sequence2 });
await scope.AppDb.SaveChangesAsync();
}
Assert.Equal(sequence1.Id + 1, sequence2.Id);
}
public void a()
{
using (var scope = new AppDbScope())
{
var _unitOfWork = scope._scope.ServiceProvider.GetService <IUnitOfWork>();
var SequenceRepo = _unitOfWork.GetRepository <Sequence>();
var userRepo = _unitOfWork.GetRepository <Users>();
// var ret =userRepo.Find(1).name;
userRepo.Insert(new Users {
age = 20, name = "jack"
});
userRepo.Insert(new Users {
age = 30, name = "jack2"
});
// SequenceRepo.Insert(new Sequence());
_unitOfWork.SaveChanges();
}
}
