Issue Details (XML | Word | Printable)

Key: DNET-700
Type: Bug Bug
Status: Open Open
Priority: Major Major
Assignee: Jiri Cincura
Reporter: Fabiano Rezende
Votes: 0
Watchers: 0

If you were logged in you would be able to see more operations.
.NET Data provider

Migration Sql generate for AddColumn operation for non nullable Guid field is wrong

Created: 26/Sep/16 07:24 PM   Updated: 26/Sep/16 07:24 PM
Component/s: Entity Framework
Affects Version/s:
Fix Version/s: None

Environment: Firebird 3, Windows 10, 64 bits

 Description  « Hide
The Migration below

public partial class MyMigration : DbMigration
public override void Up()
AddColumn("dbo.TableName", "Id", c => c.Guid(nullable: false));

Generats the Sql:
ALTER TABLE "TableName" ADD "Id" CHAR(16) CHARACTER SET OCTETS DEFAULT CHAR_TO_UUID('00000000-0000-0000-0000-000000000000') NOT NULL

Firebird does not recognize DEFAULT CHAR_TO_UUID('00000000-0000-0000-0000-000000000000')

 All   Comments   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
There are no comments yet on this issue.