private static void seedDb(ApplicationDbContext context)
        {
            if (!context.Chapters.Any())
            {
                var user1 = context.Users.Add(new User { Name = "Test User" });
                context.Chapters.Add(new Chapter
                {
                    Title = "Learn SQlite FTS5",
                    Text = "This tutorial teaches you how to perform full-text search in SQLite using FTS5",
                    User = user1.Entity
                });
                context.Chapters.Add(new Chapter
                {
                    Title = "Advanced SQlite Full-text Search",
                    Text = "Show you some advanced techniques in SQLite full-text searching",
                    User = user1.Entity
                });
                context.Chapters.Add(new Chapter
                {
                    Title = "SQLite Tutorial",
                    Text = "Help you learn SQLite quickly and effectively",
                    User = user1.Entity
                });
                context.Chapters.Add(new Chapter
                {
                    Title = "Handle markup in text",
                    Text = "<p>Isn't this <font face=\"Comic Sans\">funny</font>?",
                    User = user1.Entity
                });

                context.Chapters.Add(new Chapter
                {
                    Title = "آزمایش متن فارسی",
                    Text = "برای نمونه تهیه شده‌است",
                    User = user1.Entity
                });

                context.Chapters.Add(new Chapter
                {
                    Title = "Exclude test 1",
                    Text = "in the years 2018-2019 something happened.",
                    User = user1.Entity
                });
                context.Chapters.Add(new Chapter
                {
                    Title = "Exclude test 2",
                    Text = "It was 2018 and then it was 2019",
                    User = user1.Entity
                });

                context.SaveChanges();
            }
        }

select * from Chapters_FTS where Chapters_FTS match "fts5"

SELECT rowid, title, text, rank FROM Chapters_FTS WHERE Chapters_FTS MATCH "fts5"

CREATE VIRTUAL TABLE "Chapters_FTS"
USING fts5("Text", "Title", content="Chapters", content_rowid="Id")

select * from Chapters_FTS where Chapters_FTS match "fts5" ORDER BY bm25(fts);
select * from Chapters_FTS where Chapters_FTS match "fts5" ORDER BY rank;

namespace EFCoreSQLiteFTS.Entities
{
    public class ChapterFTS
    {
        public int RowId { get; set; }
        public decimal? Rank { get; set; }

        public string Title { get; set; }
        public string Text { get; set; }
    } 
}

namespace EFCoreSQLiteFTS.DataLayer
{
    public class ApplicationDbContext : DbContext
    {
        //...

        protected override void OnModelCreating(ModelBuilder builder)
        {
            base.OnModelCreating(builder);

            builder.Entity<ChapterFTS>().HasNoKey().ToView(null);
        }

        //...
    }
}

const string ftsSql = "SELECT rowid, title, text, rank FROM Chapters_FTS WHERE Chapters_FTS MATCH {0}";
foreach (var chapter in context.Set<ChapterFTS>().FromSqlRaw(ftsSql, "fts5"))
{
  Console.WriteLine($"Title: {chapter.Title}");
  Console.WriteLine($"Text: {chapter.Text}");
}

SELECT rowid, title, text, rank FROM Chapters_FTS WHERE Chapters_FTS MATCH "fts5";
SELECT rowid, title, text, rank FROM Chapters_FTS WHERE Chapters_FTS = "fts5";

SELECT rowid, title, text, rank FROM Chapters_FTS WHERE Chapters_FTS MATCH "fts5" ORDER by rank;

SELECT rowid, title, text, rank FROM Chapters_FTS WHERE Chapters_FTS MATCH "learn SQLite" ORDER by rank;
SELECT rowid, title, text, rank FROM Chapters_FTS WHERE Chapters_FTS MATCH "learn + SQLite" ORDER by rank;

 SELECT rowid, title, text, rank FROM Chapters_FTS WHERE Chapters_FTS MATCH "search*" ORDER by rank;

SELECT rowid, title, text, rank FROM Chapters_FTS WHERE Chapters_FTS MATCH "learn text" ORDER by rank;

SELECT rowid, title, text, rank FROM Chapters_FTS WHERE Chapters_FTS MATCH "learn NOT text" ORDER by rank;

SELECT rowid, title, text, rank FROM Chapters_FTS WHERE Chapters_FTS MATCH "search AND sqlite OR help" ORDER by rank;

SELECT rowid, title, text, rank FROM Chapters_FTS WHERE Chapters_FTS MATCH "search AND (sqlite OR help)" ORDER by rank;

SELECT rowid, title, text, rank FROM Chapters_FTS WHERE Chapters_FTS MATCH "text:some AND title:sqlite" ORDER by rank;

"in the years 2018-2019 something happened"
"It was 2018 and then it was 2019"

SELECT rowid, title, text, rank FROM Chapters_FTS WHERE Chapters_FTS MATCH "2018-2019" ORDER by rank;

Execution finished with errors.
Result: no such column: 2019

SELECT rowid, title, text, rank FROM Chapters_FTS WHERE Chapters_FTS MATCH '"2018-2019"' ORDER by rank;

SELECT rowid, title, text, rank FROM Chapters_FTS WHERE Chapters_FTS MATCH "آزمایش"
ORDER by rank;

SELECT rowid, highlight(Chapters_FTS, title, '<b>', '</b>') as title,
snippet(Chapters_FTS, text, '<b>', '</b>', '...', 64) as text, rank FROM Chapters_FTS
WHERE Chapters_FTS MATCH "fts5" ORDER BY rank

Top Issues Fixed in Visual Studio 2019 RC.2

• Find in files "Locating next match" UI is annoying.
• Find files keeps defaulting to current document.
• Quick references freezes VS 2019 RC.
• PackageId:MsSqlCmdLnUtils;PackageAction:Install;ReturnCode:1603;.
• Error List does not show errors because it is scoped to "Current Document".
• Cannot use conditional breakpoint on PropertyInfo.Name value.
• Visual Studio crashes when parsing macros at the end of a file.
• Search in Visual Studio 2019 is very slow.
• Visual Studio hangs when starting debugging.
• vdproj not supported in Visual Studio 2019 RC.
• Visual Studio installer welcome image contains offensive element for Chinese.
• VSIX Extension pre-req has been removed in Visual Studio 2019 RC breaking extension compatibility.
• Create Project from Start Screen Ignores Selected Project Folder.
• cpp properties is dialog does not show up when using Project menu item or select "Manage configuration" drop down menu.
• Visual Studio 2019 Build Tools - developer prompt title says "Developer Command Prompt for Visual Studio 2017".
• German tranlation regarding the Feedback Tool: Help > Send Feedback > Report a Problem.
• 自动完成功能，如果双击候选项，会丢失输入焦点，需要单机编辑器才能继续输入-AutoComplete function, if you double-click the candidate, will lose the input focus, need a stand-alone editor to continue to enter.
• Context menus are sometimes placed on the wrong monitor in a multiple monitor configuration.
• Visual Studio 2019 conflict with QQ Pinyin.
• Cannot drag maximized Visual Studio window.
• Fixed slow reload of multiple C# and Visual Basic projects.
• When IntelliSense is present, when a user types Shift + Enter, the active selection will be completed and a new line inserted.
• Fixed a PMA issue where editor tooltips and light bulb doesn't render properly.
• Notifications about crashes caused by extensions now show up again.
• Notifications about performance of Visual Studio have been secured against tampering.
• Fixed an issue with toolbar rendering when dragged across displays.
• Fixed an issue with Tools Options rendering when running with per-monitor awareness enabled.
• Various DpiHelper classes has been deprecated (extensibility).
• Fixed splash screen scaling to better match the primary monitor scale factor.
• Fixed an issue in settings import where warnings/errors were not always reported correctly.
• Fixed an issue where Tools Options reported software rendering regardless of rendering tier.
• Fixed an issue where the name of the open folder was not displayed in the title bar region.
• Fixed an issue with find in files positioning when per-monitor awareness is enabled.
• Fixed an issue with dock adorner rendering when per-monitor awareness is enabled. 

• We added support to change installation locations.
• You can Save All your pending changes before you start your update.
• The update dialog provides you even more details about your update during installation.
• C# 7.3 is included in Visual Studio version 15.7.
• We improved solution load time for C# and VB projects.
• We made numerous updates to F# and its tools, with a focus on performance.
• We reduced the time to enable IntelliSense for large .NET Core projects by 25%.
• We made Quick Info improvements and new .NET refactorings like convert for-to-foreach and make private fields readonly.
• We added the ability to publish ASP.NET Core applications to App Service Linux without containers.
• Live Unit Testing works with embedded pdbs and supports projects that use reference assemblies.
• The Test Explorer has more responsive icons during test runs.
• C++ developers can use CodeLens for unit testing.
• We added new rules enforcing items from the C++ Core Guidelines.
• Debugging large solutions with /Debug:fastlink PDBs is more robust.
• CMake integration supports CMake 3.11 and static analysis.
• Python projects support type hints in IntelliSense, and a Run MyPy command has been added to look for typing errors in your code.
• Conda environments are supported in Python projects.
• We added a next version of our Python debugger based on the popular open source pydevd debugger.
• TypeScript 2.8 is included in Visual Studio version 15.7.
• We improved Kestrel HTTPs support during debugging.
• We added support for JavaScript debugging with Microsoft Edge.
• The Debugger supports VSTS and GitHub Authentication for Source Link.
• IntelliTrace’s step-back debugging feature is supported for debugging .NET Core projects.
• We added IntelliTrace support for taking snapshots on exceptions.
• We removed the blocking modal dialog from branch checkouts in Git when a solution or project reload is not required.
• There is an option to choose between OpenSSL and SChannel in Git.
• You can create and associate Azure Key Vaults from within the Visual Studio IDE.
• Visual Studio Tools for Xamarin can automatically install missing Android API levels required by Xamarin.Android projects.
• The Xamarin.Forms XAML editor provides IntelliSense and quick fixes for conditional XAML.
• We added support for Azure, UWP, and additional project types in Visual Studio Build Tools.
• You can create build servers without installing all of Visual Studio.
• The Windows 10 April 2018 Update SDK - Build 17134 is the default required SDK for the Universal Windows Platform development workload.
• We added support for Visual State Management for all UWP apps and more.
• We enabled automatic updates for sideloaded APPX packages.
• You have new tools for migrating to NuGet PackageReference.
• We added support for NuGet package signatures.
• We added Service Fabric Tooling for the 6.2 Service Fabric release.
• We updated Entity Framework Tools to work with the EF 6.2 runtime and to improve reverse engineering of existing databases.

public class Car {}
public class SportsCar : Car
{
   public string Color { get; set; }
}

public static void Run<T>(T car) where T : Car
{
   if (car is SportsCar sportsCar)
   {
   }

   switch (car)
   {
      case SportsCar sCar:
      break;
   }
}

 An expression of type "T" cannot be handled by a pattern of type "SportsCar"

public static void Run<T>(T car) where T : Car
{
   if ((object)car is SportsCar sportsCar)
   {
   }

   switch ((object)car)
   {
      case SportsCar sCar:
      break;
   }
}

There are tonnes of exciting things happening in the Javascript space in 2015. The two most exciting things for me are React.js by Facebook and Aurelia by Rob Eisenberg (of Durandal fame).