public static int Update(IEntity2 entity, IRelationPredicateBucket filter) { using (DataAccessAdapter adapter = DataAccessAdapterManagerBase.CreateAdapter()) { return(adapter.UpdateEntitiesDirectly(entity, filter)); } }
public static object GetSum(IEntityField2 field, IRelationPredicateBucket filter) { using (DataAccessAdapter adapter = DataAccessAdapterManagerBase.CreateAdapter()) { return(adapter.GetScalar(field, null, AggregateFunction.Sum, filter.PredicateExpression, null, filter.Relations)); } }
public static bool InsUpdate(TEntity entity2Update, bool refetch, bool recurse) { using (DataAccessAdapter adapter = DataAccessAdapterManagerBase.CreateAdapter()) { return(adapter.SaveEntity(entity2Update, refetch, recurse)); } }
public static int InsUpdateCollection(EntityCollection ecEntity) { using (DataAccessAdapter adapter = DataAccessAdapterManagerBase.CreateAdapter()) { return(adapter.SaveEntityCollection(ecEntity, false, false)); } }
public static bool DeleteById(Guid id) { TEntity _entity = (TEntity)Activator.CreateInstance(typeof(TEntity), new object[] { id }); using (DataAccessAdapter adapter = DataAccessAdapterManagerBase.CreateAdapter()) { return(adapter.DeleteEntity(_entity)); } }
public static int GetDbCount(IRelationPredicateBucket filter) { EntityCollection ec = new EntityCollection(new TEntityFactory()); using (DataAccessAdapter adapter = DataAccessAdapterManagerBase.CreateAdapter()) { return(adapter.GetDbCount(ec, filter)); } }
public static int GetDbCount(IRelationPredicateBucket filter, EntityField2 fieldStatus) { EntityCollection ec = new EntityCollection(new TEntityFactory()); using (DataAccessAdapter adapter = DataAccessAdapterManagerBase.CreateAdapter()) { filter.PredicateExpression.Add(fieldStatus == true); return(adapter.GetDbCount(ec, filter)); } }
public static EntityCollection SelectAllWFKAPaging(int iTop, ISortExpression sorter, IRelationPredicateBucket filter, IPrefetchPath2 paths, int pageNumber, int pageSize) { EntityCollection ec = new EntityCollection(new TEntityFactory()); using (DataAccessAdapter adapter = DataAccessAdapterManagerBase.CreateAdapter()) { adapter.FetchEntityCollection(ec, filter, iTop, sorter, paths, pageNumber, pageSize); } return(ec); }
public static EntityCollection SelectAll(int iTop, ISortExpression sorter, IRelationPredicateBucket filter, IncludeFieldsList includeFields) { EntityCollection ec = new EntityCollection(new TEntityFactory()); using (DataAccessAdapter adapter = DataAccessAdapterManagerBase.CreateAdapter()) { adapter.FetchEntityCollection(ec, filter, iTop, sorter, null, includeFields); } return(ec); }
public static DataTable SelectAllRDT(int iTop, ISortExpression sorter, IRelationPredicateBucket filter) { DataTable toReturn = new DataTable(); EntityCollection ec = new EntityCollection(new TEntityFactory()); using (DataAccessAdapter adapter = DataAccessAdapterManagerBase.CreateAdapter()) { adapter.FetchTypedList(ec.EntityFactoryToUse.CreateFields(), toReturn, filter, iTop, sorter, false); } return(toReturn); }
public static EntityCollection SelectAllWPaging(int iTop, ISortExpression sorter, EntityField2 fieldStatus, IRelationPredicateBucket filter, int pageNumber, int pageSize) { EntityCollection ec = new EntityCollection(new TEntityFactory()); using (DataAccessAdapter adapter = DataAccessAdapterManagerBase.CreateAdapter()) { filter.PredicateExpression.Add(fieldStatus == true); adapter.FetchEntityCollection(ec, filter, iTop, sorter, null, pageNumber, pageSize); } return(ec); }
public static int DeleteByCondition(IRelationPredicateBucket filter) { int toReturn = 0; TEntity _entity = (TEntity)Activator.CreateInstance(typeof(TEntity)); IEntityCore _entityCore = (IEntityCore)_entity; using (DataAccessAdapter adapter = DataAccessAdapterManagerBase.CreateAdapter()) { toReturn = adapter.DeleteEntitiesDirectly(_entityCore.LLBLGenProEntityName, filter); } return(toReturn); }
public static EntityCollection SelectByField(EntityField2 fieldColumn, object fkValue) { EntityCollection ec = new EntityCollection(new TEntityFactory()); RelationPredicateBucket filter = new RelationPredicateBucket(); filter.PredicateExpression.Add(fieldColumn == fkValue); using (DataAccessAdapter adapter = DataAccessAdapterManagerBase.CreateAdapter()) { adapter.FetchEntityCollection(ec, filter, 0, null); } return(ec); }
public static TEntity SelectOne(Guid id) { TEntity result = null; using (DataAccessAdapter adapter = DataAccessAdapterManagerBase.CreateAdapter()) { TEntity _resultEntity = (TEntity)Activator.CreateInstance(typeof(TEntity), new object[] { id }); if (adapter.FetchEntity(_resultEntity)) { result = _resultEntity; } } return(result); }