RobJeremy
-
1/27/2014 11:10:32 PM
Delete Test Orders, Addresses, Users, Customers, in Bulk
Hello everyone.
First I'd like to say thanks to Kentico for making such a reliable software. I am amazed at all of the functionality it has to offer.
I have been building an ecommerce website and have been doing a lot of testing with users, customers, orders, addresses, etc. The database has tons of test records in it (300+) and I would like to remove it all in bulk.
When I try to delete records from the orders and address table manually I get SQL foreign key constraint errors. Should I set them to cascade? I primarily want to just wipe these records out, and am curious to know what the Kentico way of accomplishing this would be.
The only other thoughts I had were using the API based off this example http://devnet.kentico.com/docs/devguide/index.html?membership_api_examples_managing_users.htm
Any advice or help would be greatly appreciated. Thanks
|