I want to creat a "Purge" method that deletes all rows from the database where the Deleted field that I have in my datatable is true.

What I dont want to do is load the collection first, I think I want to use adapter.DeleteEntityCollection but I cant see how to use this unluess I load the collection into memory first.

Is there a quick and easy way to delete the rows in a database table where one column is equal to a specified value?

Thanks in advance

You want to use adapter.DeleteEntitiesDirectly() I think

Thanks

I am having a bit of trouble getting it to work...

Please tell me what I am doing wrong

EntityCollection myCollection = new EntityCollection(new UserGroupMenuItemEntityFactory());
                        
IRelationPredicateBucket myFilter = new RelationPredicateBucket();
myFilter.PredicateExpression.Add(PredicateFactory.CompareValue(UserGroupMenuItemFieldIndex.Deleted, ComparisonOperator.Equal, false));

DataAccessAdapter LLBLAdapter = new DataAccessAdapter(this.ConnectionString,false,
CatalogNameUsage.ForceName,new ConfigSetting().GetConfigSetting("DBCatalog"));

LLBLAdapter.DeleteEntitiesDirectly(myCollection,myFilter);

hplloyd wrote:

Thanks

I am having a bit of trouble getting it to work...

Please tell me what I am doing wrong

EntityCollection myCollection = new EntityCollection(new UserGroupMenuItemEntityFactory());
                        
IRelationPredicateBucket myFilter = new RelationPredicateBucket();
myFilter.PredicateExpression.Add(PredicateFactory.CompareValue(UserGroupMenuItemFieldIndex.Deleted, ComparisonOperator.Equal, false));

DataAccessAdapter LLBLAdapter = new DataAccessAdapter(this.ConnectionString,false,
CatalogNameUsage.ForceName,new ConfigSetting().GetConfigSetting("DBCatalog"));

LLBLAdapter.DeleteEntitiesDirectly(myCollection,myFilter);

That's not what you should do You should do:

IRelationPredicateBucket myFilter = new RelationPredicateBucket();
myFilter.PredicateExpression.Add(PredicateFactory.CompareValue(UserGroupMenuItemFieldIndex.Deleted, ComparisonOperator.Equal, false));

DataAccessAdapter LLBLAdapter = new DataAccessAdapter(this.ConnectionString,false,
CatalogNameUsage.ForceName,new ConfigSetting().GetConfigSetting("DBCatalog"));
LLBLAdapter.DeleteEntitiesDirectly("UserGroupMenuItemEntity", myFilter);

Aah I see thanks