Hello guys!
I have some trouble with EF6 using MySql database and a many to many relation with an association table.
So i have these entities :
- [Table("user")]
- public partial class user
- {
- public user()
- {
- }
- public int id { get; set; }
- [Required]
- [StringLength(255)]
- public string first_name { get; set; }
- [Required]
- [StringLength(255)]
- public string last_name { get; set; }
- [Required]
- [StringLength(255)]
- public string email { get; set; }
- [Required]
- [StringLength(255)]
- public string hash { get; set; }
- public virtual ICollection
Roles { get; set; } - [Table("role")]
- public partial class role
- {
- public role()
- {
- }
- public int id { get; set; }
- [Required]
- [StringLength(255)]
- public string title { get; set; }
- public virtual ICollection
Users { get; set; } - }
And i start like that : i enable migrations, its working perfectly. I add first migration, its working perfectly.
But when i try to update-database i have this error :
System.FormatException : Input string was not in a correct format.
But i dont know why, because when i delete the collection in the 2 entities it work perfectly..
There is my context :
- public class TestContext : DbContext
- {
- public TestContext() : base("name=TestContext")
- {
- Database.SetInitializer
(new DropCreateDatabaseIfModelChanges ()); - }
- public virtual DbSet
Roles { get; set; } - public virtual DbSet
Users { get; set; } - protected override void OnModelCreating(DbModelBuilder modelBuilder)
- {
- modelBuilder.Entity
() - .HasMany(e => e.Roles)
- .WithMany(e => e.Users)
- .Map(m => m.ToTable("role_user", "test"));
- }
Someone have idea ?
Thank you!
Flenner TomPosted Mar 29, 2019, 5:14 AM
Mario ScheerenPosted Mar 29, 2019, 12:35 AM
Jignesh KumarPosted Mar 28, 2019, 11:42 PM
Flenner TomPosted Mar 28, 2019, 5:42 PM
Mario ScheerenPosted Mar 28, 2019, 4:23 PM