Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
CRM: Values are not returned by Linq RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi Friends,

    I'm facing the strange issue while querying the records in CRM using Linq. Fields are returned as null though those are having the value.

    EX:

    When I queried business unit default team value using Linq it returned null but businessunitid was returned for the record. 

    Sample Query:

    var defaultteam= from bu in orgContext.CreateQuery("businessunit")
where bu["businessunitid"]== new Guid("Guid")
select bu["defaultteam"]
    And when I query the same using QueryByAttribute/FetchXML it returned the value.

    Have anyone faced this kind of issue?

    Saturday, November 1, 2014 6:40 AM

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi,

    Please confirm you are getting ("Guid") value in your script- where bu["businessunitid"]== new Guid("Guid").
    first try by using hardcode value.
    Also check below link for help.

    http://nishantrana.me/linq-query-crm-2011late-bound/

    Hope this help. Thanks

    Saturday, November 1, 2014 10:02 AM
  • Question
    Sign in to vote
    0
    Sign in to vote
    Yes. Passing the Guid. Because if I get the businessunit object bu  instead of bu["defaultteam"]. it is returning the Business Unit id but defaultteam and all other fields value are null.
    Saturday, November 1, 2014 10:08 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi,

    try like this..

    var defaultteam = from bu in orgContext.CreateQuery("businessunit")
        where ((EntityReference)bu["businessunitid"]).Id.Equals(new Guid("fe28e0c6-7ad5-e211-9d01-00155d017a1e"))                    
        select new { abc = bu["name"] };
               foreach (var baccount in defaultteam)
               {
                   string s = baccount.abc.ToString();
               }


    • Edited by Suresh Sorde Saturday, November 1, 2014 11:12 AM
    Saturday, November 1, 2014 11:07 AM