As we know, use of direct SQL to modify CRM database is not recommended, below are couple of ways which we can use to handle data.
When we create custom code for our custom applications and we need to interact with MS Dynamics CRM then we can use following techniques to deal with data
- Filtered views: Filtered views are SQL server created views and we can use these views to read data –
- CrmService We Service: This is an API supplied by MS to use for Auththentication and common data requests such as if we need to update, delete or create data
- CrmDiscoveryService Web Service: This is an other web service API we can use to get information about the installation of MS CRM
- MetadataService Web Service: If we need to manipluate the data structure then we can use this service