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>()); }