Data not showing in Advanced Find in CRM

In advanced find we were not able to see the value in some fields but when we open a record then we will be able to see the data.

Then thought of, might be there will be no data in the table. So I checked in the database then we found the solution as unfortunately the data was not there. 

As there are thousands of records in that entity so it was not feasible to open the each record and Save & Close it, just to make the values available in the advanced view.So I tried to troubleshoot the issue in many ways, since it was OnLoad(doing the changes on the form onload and the data in not there in the database) function problem. It was loading the data on form load.
 

cannot specify child attribute in the columnset for Retrieve. Attribute: createdbyname

one of the possible solution for this to ensure the fieldname is existing in that particular entity

Can't access Microsoft.Xrm namespace in Visual Studio

The type or namespace name 'Xrm' does not exist in the namespace 'Microsoft' (are you missing an assembly reference?)

Solution:
Double check in your project settings to see which Target Framework you are using. If it is .NET Framework 4 Client Profile try changing it to .NET Framework 4.

provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified

If your facing the below issue in .NET

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

Check the connection string in your Config file
 <connectionStrings>
        <add name="Connection" providerName="System.Data.SqlClient"  
             connectionString="Trusted_Connection=Yes;persist security info=False;Integrated Security=SSPI; Data Source=ServerName\SQLExpress;Initial Catalog=databasename" />

 </connectionStrings>

confirm that we have only one "\" in DataSource 

How to set the OptionSet value in Plugin

Entity opp = new Entity("opportunity");
opp ["name"] = "Test Opportunity";      // string
opp ["estimatedclosedate"] = new DateTime(2015, 12, 1);              // DateTime
opp ["discountpercentage"] = 0.5;                                   // decimal
opp ["closeprobability"] = 82;                                       // int
opp ["isrevenuesystemcalculated"] = false;                           // bool 

Here is how we would set special field values in Dynamics CRM 2011. 
These include OptionSetValue, Money (Currency), and EntityReference (Lookup).
Entity opp = new Entity("opportunity");
opp["opportunityratingcode"] = new OptionSetValue(2);               // OptionSetValue
opp["estimatedvalue"] = new Money(700.2M);                          // Money
opp["campaignid"] = new EntityReference("campaign", campaignId); 

Microsoft Visual Studio is waiting for an operation to complete

Microsoft visual studio is busy waiting for an operation to complete

If you encounter Microsoft Visual Studio is waiting for an internal operation to complete then you should try killing rdpclip.exe

 

CRM CONSULTANT VS CRM DEVELOPER

One of the thing which needs to be clear to clients, companies when we work on projects is the role of a consultant and role of the developer in the projects. This becomes more important when we have larger implementations and multi-geography teams and deployments to handle.

CRM consultant’s is an expert who will visit clients (or be a semi-permanent contractor in an organisation) and advise them on their CRM systems, train employees in

the use of the CRM systems, configure/set up/customise their CRM systems and possibly design/develop software for that organisation (or at least provide a design

spec/requirements for the software and manage the project with software developers).

CRM Developer’s will work on a broad spectrum of work, however, it’s likely to be designing/developing software for a specific purpose or design brief with little or no involvement with the end client.

Or it could be in-house software development for the IT systems of the company that you are working for.

CRM consultant’s is primarily a customer facing function and lot of it involved not only techno-functional skills but also communication skills, presentation skills alongside.

A Technical consultant will also need to possess great CRM and .net technical experience set as well.

CRM developer’s on the other hand is very hands-on job, primarily focused on technical delivery and to develop and package new services and/or offerings in line your organisation and client expectations.

CRM Consultant’s job is also to contribute to the participation in scoping, estimating and risk management efforts.

Also, to participate in building knowledge capital, improving the aptitude of your team by sharing your technical knowledge and experience.

CRM developer’s primary focus is to deliver code maintaining code quality, unit testing and fix bugs with least number of bugs introduced to the project.

CRM Consultant job is to suggest the best possible solution to problem and making it an easy job for the customer to select the best option.

It might be his/her job to complete technical delivery as well.

CRM developer’s need to have not only sound background of CRM but also of Unit testing frameworks.

Referred from Deepesh Somani blog.