Code-First Migrations

Entity Framework 6 Alpha 2 support is implemented in Devart ADO.NET providers: dotConnect for Oracle, dotConnect for MySQL, dotConnect for PostgreSQL, dotConnect for SQLite, and dotConnect for Salesforce. You need to download the corresponding Entity Framework NuGet package to use it in your applications. You can read about Entity Framework 6 features in the corresponding MSDN articles.

• New Assemblies
  • Code-First Migrations
  • Entity Framework Spatials Support
• Provider Registration
  • Config File Registration
    • Registration in entityFramework Section
    • DbProviderFactory Registration
    • Registration Examples
  • Code-based Registration
    • New Registration Classes
    • Code-based Registration Examples
• Migrating Projects from Entity Framework v4/v5
  • Entity Developer
  • Code-First or Entity Data Model Designer
  • Code-First Migrations
  • Obsolete Workarounds
    • Registration in entityFramework Section
    • Using Non-LOB Strings
    • Using DATE fields instead of TIMESTAMP
• Conclusion

New Assemblies

In order to support Entity Framework 6, we have included new assemblies compiled under .NET Framework 4.0 to the installation packages of our providers. We have added the revision number "6" to the assembly versions to easily distinguish them from the corresponding Entity Framework v4/v5 assemblies.
(more…)

Introduction

PostgreSQL database supports an advanced functionality of full-text search (FTS) and full-text indexing described comprehensively in the documentation:

Full-Text Search

We decided to meet the needs of our users willing to take advantage of the full-text search in Entity Framework and implemented the full-text search functionality in our Devart dotConnect for PostgreSQL ADO.NET Entity Framework provider.
This article deals with the following:

• Full-Text Search in LINQ to Entities
• Full-Text Indexes in Code-First Migrations
• Tutorial Overview
• Prerequisites
• Using Full-Text Index on Single Column
• Using Full-Text Index on Multiple Columns
• Conclusion

(more…)

Introduction

SQLite database supports an advanced functionality of full-text search (FTS) and full-text indexing described comprehensively in the SQLite documentation: SQLite FTS3 and FTS4 Extensions.
We decided to meet the needs of our users willing to take advantage of the full-text search in Entity Framework and implemented the full-text search functionality in our Devart dotConnect for SQLite ADO.NET Entity Framework provider.
This article deals with the following:

• Full-Text Search peculiarities in SQLite
• Full-Text Search in LINQ to Entities
• Full-Text Search Tables in Code-First Migrations
• Tutorial Overview
• Prerequisites
• Using Full-Text Search
• Conclusion

(more…)

Introduction

MySQL database supports an advanced functionality of full-text search (FTS) and full-text indexing described comprehensively in the documentation:

• Full-Text Search Functions (MySQL 5.5 stable release)
• Full-Text Search Functions (MySQL 5.6 development release)

We decided to meet the needs of our users willing to take advantage of the full-text search in Entity Framework and implemented the full-text search functionality in our Devart dotConnect for MySQL ADO.NET Entity Framework provider.
This article deals with the following:

• Full-Text Search in LINQ to Entities
• Full-Text Indexes in Code-First Migrations
• Tutorial Overview
• Prerequisites
• Using Full-Text Index on Single Column
• Using Full-Text Index on Multiple Columns
• Conclusion

(more…)

Introduction

Oracle database supports an advanced functionality of full-text search (FTS) called Oracle Text, which is described comprehensively in the documentation:

• Oracle® Text Application Developer’s Guide 11g
• Oracle® Text Reference 11g

We decided to meet the needs of our users willing to take advantage of the full-text search in Entity Framework and implemented the basic Oracle Text functionality in our Devart dotConnect for Oracle ADO.NET Entity Framework provider.
For working with Oracle Text specific functions in LINQ to Entities queries, the new OracleTextFunctions class is used, which is located in the Devart.Data.Oracle.Entity.dll assembly. It enables working with such Oracle Text functions as:

• CONTAINS
• CATSEARCH
• MATCHES
• SCORE
• MATCH_SCORE

To call Oracle Text specific stored procedures of the CTX_DDL package, the OracleCtxDdlPackage class is used, which is located in the Devart.Data.Oracle.Entity.dll assembly.
To customize Code-First Migrations with the purpose of creating and deleting Oracle Text specific indexes, the CreateIndexConfiguration and DropIndexConfiguration classes are used, which are located in the Devart.Data.Oracle.Entity.Migrations.dll assembly.
This article deals with the following:

• Tutorial Overview
• Prerequisites
• Using Context Index
• Using CTXCAT Index
• Using CTXRULE Index
• Conclusion

(more…)

ADO.NET EF providers Devart dotConnect for Oracle, dotConnect for MySQL, dotConnect for PostgreSQL, and dotConnect for SQLite implement support for Entity Framework 4.3 Beta 1 (Entity Framework Code-First Migrations). To use it in your applications, you need to download and install the corresponding Entity Framework NuGet package first. You can read about Entity Framework Code-First Migrations functionality in the corresponding MSDN articles.

• Code-First Migrations Features
  • Database Initialization Strategies
  • EdmMetadata and __MigrationHistory Tables
  • dbo
  • ColumnTypeCasingConvention
• Configuration and Deployment of Entity Framework Provider
  • New Assembly
  • Registration of Code-First Migrations SQL Generator
  • EntityFramework.dll Assembly Versions
• Migration Operation Support
• Additional Database-specific Customization of Migrations
  • Creating Tables
  • Creating Columns
  • Creating Indexes
  • Modifying Columns
  • Dropping Tables
• Ideas for Future

Code-First Migrations Features

Entity Framework Code-First Migrations continues the development of Entity Framework Code-First functionality from Entity Framework 4.1 and Entity Framework 4.2, extending the functionality of dynamic database creating and deleting with the possibility of dynamic database schema modification (adding new columns/tables/foreign keys, creating and modifying existing database objects).

(more…)