| Subject | Re: [firebird-support] EF6 - Why extra index created? |
|---|---|
| Author | Mark Rotteveel |
| Post date | 2016-05-09T11:18:30Z |
On 2016-05-09 0:35, 'emel@...' emel@... [firebird-support]
wrote:
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 theThis question is more suitable for the Firebird .net provider
> "FK_Posts_Blogs_blogId" index created for FK?
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