CRM 2011 plugin for multiple entity creation

Question

Im a newcomer to CRM 2011 plugins. Here, I is a piece of my code which throws error:

private static void AddWRItoServiceActivity(IOrganizationService service, Guid id)
    {
        using (var crm = new XrmServiceContext(service))
        {

            var serviceactivity = crm.ServiceAppointmentSet.Where(c => c.Id == id).First();
            var serviceitem = crm.brd_serviceitemSet.Where( c => c.brd_RegardingServiceId == serviceactivity.ServiceId);

            for (int i = 1; i < serviceitem.Count(); i++)
            {
                var workReportItem = new brd_workreportitem
                   {
                       brd_name = "By payman Plugin",
                       brd_serviceappointment_brd_workreportitem = serviceactivity,
                   };
                crm.AddObject(workReportItem);
                crm.SaveChanges();
            }
        }
    }

I've tried this:

for (int i = 1; i < serviceitem.ToList().Count(); i++)

and this gives error also. Would you please help me with counting such as this or using other syntax such as foreach? P.S.: I've tried this also:

foreach (var s in serviceitem.ToList())

offcoure! this is the error when using ur suggestion: The deserializer has no knowledge of any type that maps to this name. Consider changing the implementation of the ResolveName method on your DataContractResolver to return a non-null value for name 'CrmEntityReference' and namespace 'Microsoft.Xrm.Client'.Detail: — Payman Biukaghazadeh

Daryl Daryl · Accepted Answer · 2013-01-03T21:45:36

As @Anwar suggests, the Linq to CRM expressions eventually get converted into QueryExpressions, which do not support summation or aggregate expressions. I'm guessing the Linq Count method is trying to get converted into a Count Queryexpression which will fail. Now why the serviceitem.ToList().Count() doesn't work, I'm more confused. The ToList should cause the fetching of the entities, which is then added to a list, and then your standard LINQ Count method is used... You do have a using statement for LINQ correct?

Why don't you use a foreach(var item in serviceitem)?

EDIT: Didn't see the comment.

Based on the error in your oomment, it looks like you haven't enabled proxy types on your IOrganizationService, or are not including your custom entities on the server.

CRM 2011 plugin for multiple entity creation

4 Answers