Subject Re: [firebird-support] EF6 - Why extra index created?
Author Mark Rotteveel
On 2016-05-09 0:35, 'emel@...' emel@... [firebird-support]
> I try the ordinary EF CodeFirst test with latest packages for new
> FB3.


> BUT: why is created a "IX_Posts_blogId" index when the
> "FK_Posts_Blogs_blogId" index created for FK?

This question is more suitable for the Firebird .net provider
mailinglist. However, as Thomas already suggested, this is because
Entity Framework core will always create an index for a foreign key,
eventhough Firebird already creates an index for a foreign key. That is
what you get with a product that was created by Micrsoft with SQL Server
in mind, and only support for other databases as an afterthought. There
is not much you can do about this, afaik.