DotConnect enables ADO.NET and Entity Framework to work with Magento data, offering advanced connectivity options.
The software comes with the same standard ADO.NET classes as other standard ADO.NET providers, including MagentoConnection, MagentoCommand, MagentoDataAdapter, MagentoDataReader, MagentoParameter, etc. This makes it easy for users to get started with it and eliminates the need to study any Magento data access specificities.
Some of the key features of this software include connecting to Magento from Server Explorer, Magento Data Binding, and performing SQL queries against your Magento data. You can use SQL statements to work with Magento accounts, contacts, leads, contracts, products, campaigns opportunities, and other objects.
Whether you're looking to connect to Magento to perform simple data queries or you want to take advantage of the more advanced features that it offers, dotConnect for Magento is the perfect solution. With its Entity Framework support, users can take their data access to the next level and enjoy a seamless and efficient experience.
Version 1.9:
*Visual Studio 2019 version 16.5 Preview is supported
*Entity Framework 6.4 is supported
*Entity Framework Core 3.1 is supported
Version 1.8: *Visual Studio 2019 is supported
Version 1.7:
*Entity Framework Core 2.1 is supported (Query type support, Lazy loading, the Constructor Parameter property)
*The 'Include Environment Variables' and 'Json File Base Path' properties added
*Entity Framework Core 2.1.1 is supported
Version 1.5:
*Entity Framework Support
-Entity Framework Core RC1 is supported
-Entity Framework-related assemblies are renamed
*Upgrade Wizard is improved for upgrading projects with the Entity Framework functionality
*Compatible with other dotConnect providers
Version 1.6:
*Visual Studio 2017 is supported
*The Readonly connection string parameter is added to allow only reading source data (only SELECT statements)
*Entity Framework Core 1.1.1 is supported