积极答复者
從資料庫中刪除Email

问题
答案
-
在MSCRM中删除一条记录后,我们在数据库的相应表中还是会看到这条记录,mscrm并没有马上从数据库把记录删除掉,而是把该记录的属性DeletionStateCode值设置为2.系统后台运行DeletionService来定时删除这些记录,mscrm4.0这个服务是每24小时执行一次.
看我的下面这篇blog:
http://www.cnblogs.com/caims/archive/2008/07/08/1238328.html
Batistuta Cai-刀客 | 蔡敏生 | MS CRM MVP | Blog:http://caims.cnblogs.com- 已标记为答案 Jeff.Han 2009年8月18日 1:03
全部回复
-
还是建议用webserice,用 BulkDelete Message 而不是用Delete Message
Sample Code:
CrmService service = new CrmService();
service.Url = "http://<servername>:<port>/mscrmservices/2007/crmservice.asmx";
service.CrmAuthenticationTokenValue = token;
service.Credentials = System.Net.CredentialCache.DefaultCredentials;
// Create a query expression that retrieves all accounts.
QueryExpression accountsQuery = new QueryExpression();
accountsQuery.EntityName = EntityName.account.ToString();
accountsQuery.ColumnSet = new AllColumns();
// Create a query expression that retrieves all contacts.
QueryExpression contactsQuery = new QueryExpression();
contactsQuery.EntityName = EntityName.contact.ToString();
contactsQuery.ColumnSet = new AllColumns();
// Create a request.
BulkDeleteRequest request = new BulkDeleteRequest();
request.JobName = "Delete all accounts and contacts";
request.QuerySet = new QueryBase[] { accountsQuery, contactsQuery };
request.SendEmailNotification = false;
request.ToRecipients = new Guid[0];
request.CCRecipients = new Guid[0];
request.RecurrencePattern = string.Empty;
request.StartDateTime = new CrmDateTime();
request.StartDateTime.Value = DateTime.Now.ToString("s");
// Execute the request.
BulkDeleteResponse response = (BulkDeleteResponse)service.Execute(request);
Guid jobId = response.JobId;
Batistuta Cai-刀客 | 蔡敏生 | MS CRM MVP | Blog:http://caims.cnblogs.com -
在MSCRM中删除一条记录后,我们在数据库的相应表中还是会看到这条记录,mscrm并没有马上从数据库把记录删除掉,而是把该记录的属性DeletionStateCode值设置为2.系统后台运行DeletionService来定时删除这些记录,mscrm4.0这个服务是每24小时执行一次.
看我的下面这篇blog:
http://www.cnblogs.com/caims/archive/2008/07/08/1238328.html
Batistuta Cai-刀客 | 蔡敏生 | MS CRM MVP | Blog:http://caims.cnblogs.com- 已标记为答案 Jeff.Han 2009年8月18日 1:03