Nrthugu

What I have actually is a property of type char which I use to store the string value of a guid.

My current setup:

- MySQL

- EF Code-First

- EF Migration

Model:

public class Employee  

{  

    public string Id { get; set; }

}  

EF config

public class EmployeeConfiguration : EntityConfiguration<Employee>  

{  

    public EmployeeConfiguration()  

    {  

        HasKey(x => x.Id);  

        Property(x => x.Id)

            .HasColumnType(“char”)

            .HasMaxLength(36)

            .HasDatabaseGeneratedOption(DatabaseGeneratedOption.None);  

    }  

}  

The problem:

System.FormatException is thrown if I do the following:

1. Insert with an Id that doesn’t follow the format of a guid.

2. Querying the above Employee class from database that contains an Id that doesn’t follow the format of a guid.

If I try to insert or query straight to the database using sql (without using EF), it’s all fine.
Can you please guide me how to work around this problem?

Edit 1:

Error message

Guid should contain 32 digits with 4 dashes (xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx).

Solution that worked for me

From "Jason Armstrong" suggestion, I used a different char length, I went with a char(37).

EntityFramework automatically maps CHAR(36) TO GUID for MySQL per Entity Framework Data Type Mapping

Try adding old guids=true to your connection string per C# & MySQL Connector: Guid should contain 32 digits with 4 dashes