Bug #74239 FixedLength appear in TimeSpan type EF migration
| Submitted: | 6 Oct 2014 21:14 | Modified: | 18 May 2015 17:52 |
|---|---|---|---|
| Reporter: | Gabriela Martinez Sanchez | Email Updates: | |
| Status: | Not a Bug | Impact on me: | |
| Category: | Connector / NET | Severity: | S3 (Non-critical) |
| Version: | 6.8, 6.9 | OS: | Any |
| Assigned to: | CPU Architecture: | Any |
[18 May 2015 17:48]
Chiranjeevi Battula
Hello Gabriela Martinez Sanchez, Thank you for the bug report. I could not repeat the issue on Visual Studio 2013 (C#.Net) with MySQL Connector/Net 6.9.6, EF6.1.1 and EF6.1.3. Thanks, Chiranjeevi.
[18 May 2015 17:49]
Chiranjeevi Battula
screenshot
Attachment: 74239.PNG (image/png, text), 63.25 KiB.
[11 Feb 2018 3:59]
g s
Same problem
EntityFramework 6.2.0
MySql.Data , MySql.Data.Entity.EF6 6.10.6
Source.cs :
[Column( TypeName = "time" )]
public TimeSpan RunAt { get; set; }
Migration :
RunAt = c.Time(nullable: false, precision: 0, fixedLength: true)
Portions of this website are copyright © 2001, 2002 The PHP Group
Page generated in 0.053 sec. using MySQL 8.4.7-u6-cloud
Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the
respective copyright holders.
It is not reviewed in advance
by Oracle and does not necessarily represent the opinion of
Oracle or any other party.
Description: I have the following EF 6.1.1 model: public class Person { [Key] public int PersonId { get; set; } public string Name { get; set; } public string Address { get; set; } public TimeSpan TimeTest { get; set;} } public class PersonalContext : DbContext { public DbSet<Person> Persons { get; set; } protected override void OnModelCreating(DbModelBuilder modelBuilder) { base.OnModelCreating(modelBuilder); } } I run the project the first time, which creates an initial table in the database. Then I run this to generate the initial migrations: This is the resulting code of the migration: public override void Up() { CreateTable( "People", c => new { PersonId = c.Int(nullable: false, identity: true), Name = c.String(unicode: false), Address = c.String(unicode: false), TimeTest = c.Time(nullable: false, precision: 0, fixedLength: true), }) .PrimaryKey(t => t.PersonId) ; } The migration code is wrong due that the fixedlength attribute does not exist in the Time method. How to repeat: Create an application with EF 6.1. run enable-migrations run add-migration initial Suggested fix: N.A.