Guest User

Untitled

a guest
Apr 18th, 2018
97
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.27 KB | None | 0 0
  1. using System;
  2. using Microsoft.Xrm.Sdk;
  3. using Microsoft.Xrm.Sdk.Query;
  4. using Microsoft.Xrm.Tooling.Connector;
  5.  
  6.  
  7. namespace My.Crm.RetrieveMultipleConsole
  8. {
  9. class Program
  10. {
  11. static void Main(string[] args)
  12. {
  13. try
  14. {
  15. var connectionString = @"AuthType = Office365; Url = xxxx/;Username=xxxx;Password=xxxx";
  16. CrmServiceClient conn = new CrmServiceClient(connectionString);
  17.  
  18. IOrganizationService service = (IOrganizationService)conn.OrganizationWebProxyClient != null ? (IOrganizationService)conn.OrganizationWebProxyClient : (IOrganizationService)conn.OrganizationServiceProxy;
  19.  
  20. string fetchquery = @"<fetch version='1.0' output-format='xml-platform' mapping='logical' distinct='false'>
  21. <entity name='account'>
  22. <attribute name='name' />
  23. <order attribute='name' descending='false' />
  24. <filter type='and'>
  25. <condition attribute='name' operator='like' value='%Tom%' />
  26. </filter>
  27. </entity>
  28. </fetch>";
  29.  
  30. var multipleRequest = new Microsoft.Xrm.Sdk.Messages.ExecuteMultipleRequest()
  31. {
  32. Settings = new ExecuteMultipleSettings()
  33. {
  34. ContinueOnError = false,
  35. ReturnResponses = true
  36. },
  37. Requests = new OrganizationRequestCollection()
  38. };
  39. EntityCollection accounts = service.RetrieveMultiple(new FetchExpression(fetchquery));
  40. foreach (var c in accounts.Entities)
  41. {
  42.  
  43. Console.WriteLine("accountid: {0}", c.Attributes["name"]);
  44. Microsoft.Xrm.Sdk.Messages.UpdateRequest updateRequest = new Microsoft.Xrm.Sdk.Messages.UpdateRequest { Target = c };
  45. multipleRequest.Requests.Add(updateRequest);
  46. c.Attributes["name"] = "New Name";
  47. Microsoft.Xrm.Sdk.Messages.ExecuteMultipleResponse multipleResponse = (Microsoft.Xrm.Sdk.Messages.ExecuteMultipleResponse)service.Execute(multipleRequest);
  48.  
  49. }
  50. }
  51.  
  52. catch (Exception ex)
  53. {
  54. Console.WriteLine(ex.ToString());
  55. }
  56. Console.ReadLine();
  57. }
  58. }
  59. }
Add Comment
Please, Sign In to add comment