August, 2012

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…)