public virtual void Add(TEntity obj)
{
try
{
_context.Set <TEntity>().Add(obj);
_context.SaveChanges();
}
catch (Exception ex)
{
throw ex;
}
}
public ActionResult Delete(int id)
{
var livro = _db.Livros.FirstOrDefault(x => x.ID == id);
_db.Set <Livro>().Remove(livro);
_db.SaveChanges();
return(RedirectToAction("Index"));
}
public async Task <IList <LoanProcess> > SelectByFilterAsync(Expression <Func <LoanProcess, bool> > expression)
{
return(await context.Set <LoanProcess>()
.Include(t => t.Terms)
.Include(t => t.Status)
.Include(r => r.LoanRequest)
.ThenInclude(d => d.Customer)
.Where(expression)
.AsNoTracking()
.ToListAsync());
}
public async Task <List <T> > GetListByPageAsync(int pageIndex, int pageSize)
{
var skipCount = (pageIndex - 1) * pageSize;
var result = await _mySqlContext.Set <T>().AsNoTracking().Skip(skipCount).Take(pageSize).ToListAsync();;
return(result);
}
public IList <T> Get()
{
using (var context = new MySqlContext())
{
try
{
return(context.Set <T>().ToList());
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
return(null);
}
}
}
public T Get(int id)
{
using (var context = new MySqlContext())
{
try
{
return(context.Set <T>().First(x => x.Id == id));
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
return(null);
}
}
}
public T Remove(int id)
{
using (var context = new MySqlContext())
{
try
{
var entityRemove = context.Set <T>().First(x => x.Id == id);
context.Remove(entityRemove);
context.SaveChanges();
return(entityRemove);
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
return(null);
}
}
}
public T Add(T entity)
{
using (var context = new MySqlContext())
{
try
{
entity.DataCadastro = DateTime.Now;
context.Set <T>().Add(entity);
context.SaveChanges();
return(entity);
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
return(null);
}
}
}
public RetornoPadrao Insert(ItemEntidade obj)
{
try
{
context.Add(obj);
context.Set <ItemEntidade>().Add(obj);
context.SaveChanges();
return(new RetornoPadrao()
{
IdObjeto = obj.Id,
Resultado = EstadoResultado.OK
});
}
catch (Exception exception)
{
throw new Exception($"Falha ao inserir item no banco, exception: {exception}");
}
}
/// <summary>
/// 新增单条数据
/// </summary>
/// <typeparam name="T"></typeparam>
/// <param name="info">数据源</param>
/// <returns></returns>
public async Task <int> AddAsync <T>(T info) where T : class
{
try
{
using (_context)
{
await _context.Set <T>().AddAsync(info);
_context.SaveChanges();
return(0);
}
}
catch (Exception ex)
{
_log.Error("AddAsync method error:" + ex);
return(-1);
}
}
public BaseRepository(MySqlContext context, IUnitOfWork unitOfWork)
{
_context = context;
_dbSet = _context.Set <T>();
this.unitOfWork = unitOfWork;
}
public GenericRepository(MySqlContext context)
{
_context = context;
//Setando dinamicamente tipo generico no DbContext
_dataSet = _context.Set <T>();
}
public List <TransferEntity> GetAllTransfersAccount(Guid AccoundID)
{
return(_context.Set <TransferEntity>().Where(_ => _.AccountIDfrom.Equals(AccoundID) || _.AccountIDto.Equals(AccoundID)).ToList());
}
protected virtual void Insert(TEntity obj)
{
_mySqlContext.Set <TEntity>().Add(obj);
_mySqlContext.SaveChanges();
}
public void Insert(TEntity obj)
{
_mySqlContext.Set <TEntity>().Add(obj);
_mySqlContext.SaveChanges();
}
public virtual async Task <decimal?> SumAsync(
Expression <Func <T, bool> > predicate = null
)
{
var query = _context.Set <T>().AsQueryable();
query = PrepareQuery(query, predicate);
return(await((IQueryable <decimal?>)query).SumAsync());
}
public void Insert(T entity)
{
context.Set <T>().Add(entity);
context.SaveChanges();
}
public void Delete(T entity)
{
_context.Set <T>().Remove(entity);
_context.SaveChanges();
}
public GenericRepository(MySqlContext context)
{
this.context = context;
dataSet = context.Set <T>();
}
public GenericRepository(MySqlContext mySqlContext)
{
_mySqlContext = mySqlContext;
dataset = _mySqlContext.Set <T>();
}
public GenerciRepository(MySqlContext context)
{
_context = context;
_dataSet = _context.Set <T>();
}
public static void Main(string[] args)
{
DIService.RegisterService();
var dbconfig = DIService.ServiceProvider.GetService <IOptions <DatabaseConfig> >();
// var abc = DIService.services.BuildServiceProvider();
AppConfig.MasterDatabaseInfo = dbconfig.Value;
// new DataService.Infrastructure.DatabaseConfig()
// {
// Name = "cx",
// StoreType = StoreType.MySql,
// ConnectionString = @"server=localhost;userid=root;pwd=99b3ad6e;port=3306;database=blogdb;sslmode=none;"
// };
using (IBlogService blogService = DIService.GetService <IBlogService>())
{
Blog blog1 = new Blog();
blog1.BlogName = "我的个人博客II";
blog1.Url = "http://www.xyzsoft.com";
Post post = new Post();
post.Title = "如何使用EFCore-xyzsoft";
post.Content = "要想正确使用EFCORE，必须先看文档，了解有哪些东西,然后配合实践，不明白的再看文档";
blog1.Posts.Add(post);
blogService.InsertBlog(blog1);
//blogService.InsertBlog(new Blog() { Url = "http://blogs.msdn.com/adonet", BlogName = "我的博客" });
var count = blogService.AcceptAllChanges();
Console.WriteLine("{0} records saved to database", count);
// Console.WriteLine("All blogs in database:");
// foreach (var blog in blogService.GetAllBlogs().Where(b => b.BlogId > 0))
// {
// Console.WriteLine(" - {0} - {1}", blog.Url, blog.SiteName);
// }
}
var options = new DbContextOptionsBuilder <DbContextBase>()
.UseMySql(new MySqlConnection(AppConfig.MasterDatabaseInfo.ConnectionString))
.Options;
using (var context1 = new MySqlContext(options))
{
using (var transaction = context1.Database.BeginTransaction())
{
context1.CommittableTransaction = transaction;
try
{
var blog2 = new Blog {
Url = "http://blogs.msdn.com/visualstudio", BlogName = "新增的博客"
};
// var post = context1.Set<Post>().Last();
var post = new Post();
post.Title = "学习EF CORE";
post.Content = "学习EF CORE，必须了解的细节";
blog2.Posts.Add(post);
// post.BlogId = blog2.BlogId;
context1.Add(blog2);
// context1.Set<Blog>().Add(new Blog { BlogName = "单独实例上下文56", Url = "http://blogs.msdn.com/dotnet598" });
context1.SaveChanges();
using (var context2 = new MySqlContext(options))
{
// context2.Database.UseTransaction(context1.GetDbTransaction());
context2.UseTransaction(context1);
var lastblog = context2.Set <Blog>().Last();
// context2.Set<Blog>().Remove(lastblog);
context2.SaveChanges();
var blogs = context2
.Set <Blog>()
.FromSql("select * from Blog")
.Include(b => b.Posts)
.Select(blog => new { blog.BlogId, blog.Url, blog.BlogName, blog.Posts })
.OrderBy(b => b.Url)
.ToList();
foreach (var blog in blogs)
{
Console.WriteLine(" - {0} - {1} - {2}", blog.Url, blog.BlogName, blog.Posts.Count());
}
// Commit transaction if all commands succeed, transaction will auto-rollback
// when disposed if either commands fails
transaction.Commit();
}
}
catch (Exception)
{
// TODO: Handle failure
}
}
}
Console.ReadKey();
}
public GenericRepository(MySqlContext mySqlContext)
{
Context = mySqlContext;
DataSet = Context.Set <T>();
}
public T Get(int id)
{
return(context.Set <T>().Find(id));
}
public GenericRepository(MySqlContext context)
{
_context = context ?? throw new ArgumentNullException(nameof(context));
SetEntity = context.Set <TEntity>();
}
public void Remove(int id)
{
context.Set <T>().Remove(Select(id));
}
public void Insert(T obj)
{
context.Set <T>().Add(obj);
context.SaveChanges();
}
public void Add(TEntity obj)
{
Db.Set <TEntity>().Add(obj);
Db.SaveChanges();
}
public GenericRepository(MySqlContext context)
{
_context = context;
dataset = _context.Set <T>();
}
public BaseRepository(MySqlContext context)
{
_context = context;
DbSet = _context.Set <TEntity>();
}
