Call Custom Service outside the CRM hosted website

How to call the Custom Rest/Webservice outside the CRM website in OnPremsies in CRM:

Purpose:
   Why we need to host the custom service inside the CRM rather than outside?
        Reason behind this is if we host the custom service inside the CRM,if any crashes happen in the custom service it will affect the CRM application because of same application pool.If we host outside the CRM website this wont happen.

1.Create a REST service in Visual studio2013 using Web API

2. The following links helps you to enable CORS using nuget package console

http://www.asp.net/web-api/overview/security/enabling-cross-origin-requests-in-web-api

3.Once u enable the CORS using above link,Publish the application and make sure all dll allow local copy set to  true in the properties.

4.Host the the custom service in separate website in IIS(ouside the CRM with Https enabled)

5.When ran the custom service through IIS to make sure it is working or not

the following errror occured.

Error:

Attempt by security transparent method 'System.Web.Http.GlobalConfiguration.get_Configuration()' to access security critical type 'System.Web.Http.HttpConfiguration' failed

6. The below steps would solve the problem.

Steps to Do:

• Go to Tools->Nuget Package Manager->Package manager Console
• Run the below command in order

Update-Package Microsoft.AspNet.WebApi -Pre

Install-Package Microsoft.AspNet.WebApi.OData -Version 5.0.0

Publish the changes and host again will solve the issue

Ref:

http://stackoverflow.com/questions/18476370/how-do-i-resolve-the-error-attempt-by-security- transparent-method-system-web-h

Today we learnt how to Call the Custom services outside the CRM website in OnPremsies in CRM

How big is the CRM database?

As consultants, we often perform an analysis of CRM systems belonging to prospects or customers, perhaps because they have performance issues, they want to upgrade, or we need to understand more about their current implementations.

If the CRM is on-premises, it is useful to find out about which out-of-the-box CRM entities are used, custom entities if any, number of records, and size of tables. You can find out all about this easily through few clicks and without having to write any T-SQL.

1. Logon to SQL Server Management Studio
2. Right-click on the CRM database (e.g. sandbox_CRM), then select Reports > Standard Reports > Disk Usage by Table
3. A report will be loaded in a new tab. This may take a couple of minutes depending on the overall size of the database.
4. You can interact with the report then by sorting the desired columns, however my recommendation is to export this to Excel and perform further manipulation in Excel. To export, right click on the report, and select Export > Excel