IMPORTANT: First things first. You have to set up your Silverlight app to make a web services connection to CRM. The best tutorial I have found for this is located here in the MSDN:
http://msdn.microsoft.com/en-us/library/gg594452.aspx
After you finish that setup you are ready to implement the rest of this post.
Now once that is done you can retrieve records in CRM using the following syntax. In the following example I am retrieving a webresource record wit the name new_mywebresourcename.
Here is the call in C#:
ColumnSet Columns = new ColumnSet();
Columns.Columns = new System.Collections.ObjectModel.ObservableCollection<string>(new string[] { "content" });
QueryExpression Query = new QueryExpression();
Query.EntityName = "webresource";
Query.ColumnSet = Columns;
Query.Criteria = new FilterExpression
{
FilterOperator = LogicalOperator.And,
Conditions =
{
new ConditionExpression
{
AttributeName = "name",
Operator = ConditionOperator.Equal,
Values = { "new_mywebresourcename" }
}
}
};
OrganizationRequest Request = new OrganizationRequest() { RequestName = "RetrieveMultiple" };
Request["Query"] = Query;
IOrganizationService Service = SilverlightUtility.GetSoapService();
Service.BeginExecute(Request, new AsyncCallback(GetCertificateResult), Service);
Now here is the call-back code:
private void GetCertificateResult(IAsyncResult Result)
{
try
{
OrganizationResponse Response = ((IOrganizationService)Result.AsyncState).EndExecute(Result);
EntityCollection EntityResult = (EntityCollection)Response["EntityCollection"];
Entity wr = new Entity();
wr = EntityResult.Entities[0];
byte[] certbytes = Convert.FromBase64String(wr.Attributes[0].Value.ToString());
X509Certificate MyCert = new X509Certificate(certbytes, "Certname");
this.Dispatcher.BeginInvoke(DisplayCert);
}
catch (Exception ex)
{
throw ex;
}
}
You will need to use the this.Dispatcher.BeginInvoke to call a method to act on the UI or perform actions in the main thread. I did not include the dispatcher invoked method called "DisplayCert" in this case because it could do anything in the UI.
You will notice that the biggest change in thinking and syntax from standard CRM SDK work will be that you have to specify your request and response properties as strings explicitly in code.
I hope this helps!
-
