Hi everyone,我有Asp.使用实体框架Core 6.0和Postgresql作为数据库的Net Core Web API项目
我配置了实体及其关系.一切都很好,但通用存储库设计模式中只有一个问题
如果我只使用context.Products.ToList()
,它就工作得很好.但每当我将其与通用存储库设计模式一起使用时.我出错了.但有一件有趣的事.无论何时,只要我使用断点10秒或更长时间,并且在10秒后保持断点,都不会出现错误.一切都很完美.是否存在异步问题,我从未使用过它?
Error enter image description here
Newtonsoft.Json.JsonSerializationException:从获取值时出错
---&燃气轮机;系统InvalidOperationException:为警告生成错误
public class EfEntityRepositoryBase<TEntity, TContext> : IEntityRepository<TEntity>
where TEntity : class, IEntity, new()
where TContext : DbContext, new()
{
public TEntity Add(TEntity entity)
{
using (TContext context = new TContext())
{
var addedEntity = context.Entry(entity);
addedEntity.State = EntityState.Added;
context.SaveChanges();
return addedEntity.Entity;
}
}
public void Delete(TEntity entity)
{
using (TContext context = new TContext())
{
var deletedEntity = context.Entry(entity);
deletedEntity.State = EntityState.Deleted;
context.SaveChanges();
}
}
public TEntity Get(Expression<Func<TEntity, bool>> filter)
{
using (TContext context = new TContext())
{
var result = context.Set<TEntity>().SingleOrDefault(filter);
return result;
}
}
public List<TEntity> GetAll(Expression<Func<TEntity, bool>> filter = null)
{
using (TContext context = new TContext())
{
var result = filter == null
? context.Set<TEntity>().ToList()
: context.Set<TEntity>().Where(filter).ToList();
return result;
}
}
}
}
My Salon Entity
public class Salon : IEntity
{
[Key]
public int Id { get; set; }
public string Name { get; set; }
public string SalonNumber { get; set; }
public virtual List<Seat> Seats { get; set; }
public virtual List<Ticket> Tickets { get; set; }
}
My Seat Entity
public class Seat : IEntity
{
[Key]
public int Id { get; set; }
public int SeatNumber { get; set; }
public int SalonId { get; set; }
public virtual Salon Salon { get; set; }
}
MyDbContext
public class AppDbContext : DbContext
{
protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
{
optionsBuilder.UseLazyLoadingProxies().ConfigureWarnings(warnings => warnings.Ignore(CoreEventId.DetachedLazyLoadingWarning))
.UseNpgsql("Server=localhost;Database=BiletsgoDB;Port=5432;Username=postgres;Password=123456");
}
protected override void OnModelCreating(ModelBuilder modelBuilder)
{
modelBuilder.Entity<Ticket>().HasOne(t => t.Category).WithMany(b => b.Tickets).HasForeignKey(t => t.CategoryId);
modelBuilder.Entity<Ticket>().HasOne(t => t.Salon).WithMany(b => b.Tickets).HasForeignKey(t => t.SalonId);
modelBuilder.Entity<Seat>().HasOne(t => t.Salon).WithMany(b => b.Seats).HasForeignKey(t => t.SalonId);
modelBuilder.Entity<TicketFile>().HasOne(t => t.Ticket).WithMany(b => b.TicketFiles).HasForeignKey(t => t.TicketId);
}
public DbSet<Ticket> Tickets { get; set; }
public DbSet<TicketFile> TicketFiles { get; set; }
public DbSet<Category> Categories { get; set; }
public DbSet<Seat> Seats { get; set; }
public DbSet<Salon> Salons { get; set; }
}