dotConnect for MySQL
Devart dotConnect for MySQL 8.12.1307 Professional
, formerly known as MyDirect .NET, is an enhanced ORM-enabled data provider for MySQL that builds on the ADO.NET technology to present a complete solution for developing MySQL-based database applications. It introduces new approaches for designing application architecture, boosts productivity, and leverages database applications.Fast and Advanced ADO.NET Provider
dotConnect for Oracle offers both high performance native connectivity to the Oracle database and a number of innovative development tools and technologies. It supports a wide range of Oracle-specific features, such as Advanced Queuing, Alerts, Pipes, Direct Path Loading, Change notifications, Transparent Application Failover, REF cursors, objects, packages, and others.RAD Approach
dotConnect for Oracle provides a vast number of GUI tools that increase your productivity. It integrates into Visual Studio Server Explorer and other tools, and provides advanced visual component editors to simplify component tweaking. DataSet tools, such as DataSet Wizard, DataSet Editor, DataSet Manager, provide you an easy way to create and edit typed and untyped DataSets.ORM Solutions
dotConnect for MySQL offers enhanced ORM support with a bundled visual designer for ORM models – Entity Developer. dotConnect for MySQL supports ADO.NET Entity Framework, NHibernate, and LinqConnect (formerly known as LINQ to MySQL) – our own ORM solution, closely compatible to Microsoft LINQ to SQL, while extending its functionality with its own features.
The behavior is changed: now “Unicode=true;” sets client character set to utf8mb4 for MySQL Server 5.5.3 and higher The bug with connecting to database with .NET Standard 1.3 compatible assemblies on .NET Framework 4.6.0 run-time is fixed LinqConnect (formerly known as LINQ to MySQL) The new overload DataContext.Refresh(bool ignoreErrors, RefreshMode mode, object entity) is added for ignoring errors during refresh The existing overload DataContext.Refresh(RefreshMode mode, object entity) is improved: its check avoids the try to refresh the entity that is added to the context but not submitted to the database The type and text of the error generated by the DataContext.Refresh(RefreshMode mode, object entity) method, when the passed entity doesn’t exist in database, is fixed The bug with generating the COALESCE expression is fixed Entity Developer The multiple select functionality in EF Core Model is improved: now it allows setting PrimaryKey, ValueGenerated, Concurrency for several properties simultaneously The bug with detecting order of columns in composite primary key with two or more columns by Update To Database and by Update From Database wizards in EF Core is fixed The bug with using ASP.NET Core Web Application (.NET Framework) and Azure Functions v1 (.NET Framework) projects in Visual Studio 2017 is fixed Entity Framework support Entity Framework Core 2.2.1 is supported The new extension method Database.IsMySql() in EF Core 2 is implemented The config.QueryOptions.NullStringCollation option is implemented to use the COLLATE operator with a required collation when comparing null strings in “equal” and “not equal” cases The bug with applying config.Workarounds.IgnoreSchemaName=true to the .ToTable() functionality in EF Core 2 is fixed The bugs with using the GuidToStringConverter, EnumToStringConverter, ValueConverter classes in EF Core 2 are fixed The bug with constructing the LIKE clause in EF Core 2 is fixed The bug with generating a subselect within the SELECT list in EF Core 2 is fixed The bug with applying an aggregate function to the result of a subselect in EF Core 2 is fixed