Bug #85912 Drop foreign key in migration
Submitted: 12 Apr 2017 6:50 Modified: 8 Jul 2020 20:31
Reporter: NAU Nathan Email Updates:
Status: Can't repeat Impact on me:
None 
Category:Connector / NET Severity:S2 (Serious)
Version:6.10.1 beta and 7.0.7 m6 OS:Any
Assigned to: CPU Architecture:Any
Tags: migration

[12 Apr 2017 6:50] NAU Nathan 
Description:
Syntax error while drop foreign key

How to repeat:
Excute migration with drop foreign key 

migrationBuilder.DropForeignKey(
    name: "FK_table1_table2_table2Id",
    table: "table1");

Suggested fix:
Look joint file
[12 Apr 2017 6:51] NAU Nathan 
Fiexd file (Source\MySql.Data.EntityFrameworkCore\Migrations\)

Attachment: MySQLMigrationsSqlGenerator.cs (text/plain), 12.94 KiB.
[13 Apr 2017 8:13] Chiranjeevi Battula 
Hello NAU Nathan,

Thank you for the bug report.
Could you please provide repeatable test case (steps/sample project, code, screenshot, database/create table statements etc. - please make it as private if you prefer) to confirm this issue at our end?

Thanks,
Chiranjeevi.
[13 Apr 2017 11:37] NAU Nathan 
Demo

Attachment: OracleBug2.rar (application/octet-stream, text), 4.60 KiB.
[13 Apr 2017 11:40] NAU Nathan 
To test demo, you need to fix bug 85902 or create manualy table "__EFMigrationsHistory".
[17 Apr 2017 5:46] Chiranjeevi Battula 
Hello NAU Nathan,

Thank you for the bug report and test case.
Verified this behavior on Visual Studio 2017 (C#.Net) and Connector/NET 6.10.1 version.

Thanks,
Chiranjeevi.
[8 Jul 2020 20:31] Daniel Valdez 
Posted by developer:
 
This is no longer an issue. Verified against C/NET v8.0.20.