| Subject | Re: [firebird-support] EF6 - Why extra index created? |
|---|---|
| Author | |
| Post date | 2016-05-09T12:02:29Z |
Thank you
On Monday, May 9, 2016 11:18 AM, "Mark Rotteveel mark@... [firebird-support]" <firebird-support@yahoogroups.com> wrote:
On 2016-05-09 0:35, 'emel@...' emel@... [firebird-support]
wrote:
...
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.
Mark
wrote:
> 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.
Mark