Simple C# code to retrieve an Entity Record

(0) Share

Report

Posted on by Hasibur Rahman

Hello,

I am looking for the simplest C# sample code to retrieve an entity record and value of some fields by passing the "ID" of the entity record

*This post is locked for comments

I have the same question (0)

All responses (11)

Answers (4)

Suggested answer

Mamatha Swamy 5,426 on at

Like (0)

Report

Refer msdn.microsoft.com/.../microsoft.xrm.sdk.iorganizationservice.retrieve.aspx

Was this reply helpful? Yes No
Suggested answer

Mahadeo Matre 17,021 on at

Like (0)

Report

Download crm sdk..it has sample code to retrieve, and for other operations.

you can download sdk from

www.microsoft.com/.../details.aspx

Was this reply helpful? Yes No
Verified answer

Aileen Gusni 44,524 on at

Like (5)

Report

Hi Hasibur:

As per your requirement, a simple sample code:

private Entity RetrieveEntityById(IOrganizationService service, string strEntityLogicalName, Guid guidEntityId)

{

Entity RetrievedEntityById= service.Retrieve(strEntityLogicalname, guidEntityId, newColumnSet(true)); //it will retrieve the all attrributes

return RetrievedEntityById;

}

How to call?

Entity entity = RetrieveEntityById(service, "account", guidAccountId);

how to get the attributes?

String strAccountName = string.Empty;

if(entity.Attributes.Contains("name"))

{

strAccountName = entity.Attributes["name"]

}

msdn.microsoft.com/.../gg328416.aspx

Hope this helps.

Thanks.

Was this reply helpful? Yes No
Verified answer

Hasibur Rahman on at

Like (0)

Report

Aileen Gusni - thanks for your reply. How would a go about if I want to retrieve them by a custom field (i.e. - ticketnumber (int))

Thanks

Was this reply helpful? Yes No
Verified answer

Aileen Gusni 44,524 on at

Like (0)

Report

Hasibur,

Just use this:

if(entity.Attributes.Contains("new_ticketnumber"))

{

int intTickerNumber= Convert.ToInt32(entity.Attributes["new_ticketnumber"].ToString());

}

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report
Easy way,

Install this Nuget package

https://www.nuget.org/packages/CRMConnection/1.0.2

Here is the sample to connect and use the service object into your own way.

static void Main(string[] args) { Microsoft.Xrm.Sdk.IOrganizationService _service = null; Microsoft.Xrm.Sdk.Client.OrganizationServiceProxy _serviceProxy; ServerConnection serverConnect = new ServerConnection(); // Final parameter of this method is your CRM version. like crm4, crm5 etc. If you pass Blank value it will use crm default. ServerConnection.Configuration config = serverConnect.GetServerConfiguration("yourusername", "yourpassword","crm"); _serviceProxy = ServerConnection.GetOrganizationProxy(config); // This statement is required to enable early-bound type support. _serviceProxy.EnableProxyTypes(); _service = (Microsoft.Xrm.Sdk.IOrganizationService)_serviceProxy; }

Was this reply helpful? Yes No
Verified answer

Hasibur Rahman on at

Like (0)

Report

Thanks - the reply from Aileen Gusni solved the problem

Was this reply helpful? Yes No
Saddamk206 777 on at

Like (1)

Report
Retrieve a record of an entity:-

public Entity RetrieveEntityById(IOrganizationService service, string EntityLogicalname, Guid guidEntityId) { Entity entityRecord = service.Retrieve(EntityLogicalname, Entityguid, new ColumnSet(true)); return entityRecord; }

public void getEntityRecord()
{

Entity entity = RetrieveEntityById(service, "account", guidAccountId);

if(entity.Attributes.Contains("name"))
{
string strAccountName = entity.Attributes["name"]
}

}

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (1)

Report

aspsolutionkirit.blogspot.in/.../update-contact-entity-from-website-to.html

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Can you help me with the code for My Active contacts under Contact entity, I want to retrieve all the records and also update them

Was this reply helpful? Yes No