How to retrive all entities in Microsoft Dynamics crm 2011 on premesis using query expression?

Answered How to retrive all entities in Microsoft Dynamics crm 2011 on premesis using query expression?

  • Wednesday, August 08, 2012 6:52 AM
     
     

    Dear Experts,

    am trying to retrive all entities from crm  using below code using query expression but am not getting

     the code like this

       QueryExpression r = new QueryExpressionColumnset=new ColumnSet{Columns={"acountid"}}, EntityCollection ec = _serviceProxy.RetrieveMultiple(r);

    {

    EntityName = Account.EntityLogicalName,

    foreach(Entity e in ec.Entities)

    {

    Console.WriteLine(e.Id);

    }

All Replies

  • Wednesday, August 08, 2012 8:28 AM
     
     Answered

    queryexpression q1=new queryexpression();

    q1.entityname="  ";///ur entityname

    q1.columnset.addcolumns("name "," ",);///add columns of the entity

    ///if u want add any filterexpression

    q1.creteria=new filterexpression();

    q1.creteria.addcondition("  ",condition.equal," ");

    filterexpression entityresult=serviceproxy.retrievemultiple(q1);

    foreach(entity i in entityresult.entities)

    {

    if(i.attribute.contains("name")==true)

    {

    string name=i.atrribute["name"].tostring();

    }

    ///this method can be used to retrive data

    for sample check in sdk to retrivev data


    ms crm

  • Friday, August 17, 2012 4:57 AM
     
     

    Hi,

    I got all records by using your query.thanks for your reply .

    Thanks & Regards,

    Chandra Shekar.

  • Saturday, August 18, 2012 7:43 AM
     
     
    if it helpful to u mark as helpful............


    if it help mark as helpfull
    • Edited by Dicaprio r Saturday, August 18, 2012 2:31 PM
    •