public IReadOnlyList <T> FindMany <T>(Expression <Func <T, bool> > filter)
where T : class
{
using (var context = new EntityFrameworkDbContext()) {
return(context.Set <T>().Where(filter).ToList());
}
}
public T QueryOne <T>(Expression <Func <T, bool> > filter)
where T : class
{
using (var context = new EntityFrameworkDbContext()) {
return(context.Set <T>().SingleOrDefault(filter));
}
}
public void InserMany <T>(IEnumerable <T> entities)
where T : class
{
using (var context = new EntityFrameworkDbContext()) {
context.Set <T>().AddRange(entities);
context.SaveChanges();
}
}
public void InsertOne <T>(T entity)
where T : class
{
using (var context = new EntityFrameworkDbContext()) {
context.Set <T>().Add(entity);
context.SaveChanges();
}
}
public async Task Test()
{
var serializer = new Serializer(new AllPropertiesExtractor());
var customer = new Customer
{
Age = 1,
Name = "qwer",
Orders = new[]
{
new Order {
Price = 3, ShippingAddress = "4"
},
new Order {
Price = 1, ShippingAddress = "2"
},
}
};
await using var context = new EntityFrameworkDbContext();
await context.Set <TestTable>().AddAsync(new TestTable
{
Id = 1,
CompositeKey = "2",
Boolean = false,
Integer = 1345,
String = "qwerty",
DateTime = DateTime.Today,
DateTimeOffset = DateTimeOffset.UtcNow,
Customer = customer,
CustomerSerialized = serializer.Serialize(customer),
});
await context.Set <UsersTable>().AddAsync(new UsersTable
{
Id = 1,
Email = "2",
Name = "3",
});
await context.SaveChangesAsync();
}
public IQueryable <TEntity> Get(Expression <Func <TEntity, bool> > filter = null, Func <IQueryable <TEntity>, IOrderedQueryable <TEntity> > orderBy = null, string includeProperties = "")
{
IQueryable <TEntity> query = EntityFrameworkDbContext.Set <TEntity>();
if (filter != null)
{
query = query.Where(filter);
}
if (!string.IsNullOrWhiteSpace(includeProperties))
{
foreach (var includeProperty in includeProperties.Split(new[] { ',' }, StringSplitOptions.RemoveEmptyEntries))
{
query = query.Include(includeProperty);
}
}
if (orderBy != null)
{
return(orderBy(query).AsQueryable());
}
return(query.AsQueryable());
}
public IQueryable <ChildInterestJoin> Query()
{
return(_context.Set <ChildInterestJoin>());
}
public virtual TEntity GetById(TEntityId id)
{
return(EntityFrameworkDbContext.Set <TEntity>().Find(id));
}
public virtual IQueryable <TEntity> GetAll()
{
return(EntityFrameworkDbContext.Set <TEntity>().AsQueryable());
}
public BaseReadOnlyRepository(TDbContext entityFrameworkDbContext) : base(entityFrameworkDbContext)
{
DbSet = EntityFrameworkDbContext.Set <TEntity>();
}
public IQueryable <XMasMotherInterestJoin> Query()
{
return(_context.Set <XMasMotherInterestJoin>());
}