CrmAdo is an ADO.Net data provider for Dynamics Crm. It hides from you the complexities of using the IOrganisation web service, and instead exposes Dynamics Crm to you as if it was an ordinary SQL database / data source. It allows you to use the familiar ADO.Net model to connect to, and perform queries against Dynamics CRM, and you can use the familiar T-SQL language to write your queries. CrmAdo handles all the conversion between your T-SQL queries / commands into the appropriate IOrganisation web service interactions behind the scenes, so to all intense and purposes it will appear to you as if Dynamics CRM is just an ordinary Sql database.
See the version list below for details.
- Intial Alpha release, all unit tests passing, currently only supports "Read" access to Dynamics CRM. Insert / Update and Delete will come in a future version.
- Changed the invariant name for the provider to be System.Data.DynamicsCrm.CrmAdo
- Added web and app config transform to NuGet package so that the DbProviderFactory configuration is done for you automatically.
- Corrected and tidied release notes.
- Stable release.