title: Changing from sqlserver to mysql using efcore
body: <p>i was previously using MSSQLSERVER in my project, then i switched to a mysql database using ef core by installing the pomelo mysql client and using that in my configure services. when i try to update the new mysql database using the previous migrations i had gotten from mssql i am getting a bunch of errors
  the most annoying error was:</p>
  <pre><code> Microsoft.EntityFrameworkCore.Database.Command[20102]
        Failed executing DbCommand (4ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
        CREATE TABLE `Activities` (
            `Id` uniqueidentifier(36) NOT NULL,
            `Title` nvarchar(max) NULL,
            `Description` nvarchar(max) NULL,
            `Category` nvarchar(max) NULL,
            `Date` datetime2(6) NOT NULL,
            `City` nvarchar(max) NULL,
            `Venue` nvarchar(max) NULL,
            CONSTRAINT `PK_Activities` PRIMARY KEY (`Id`)
        );
  fail: API.Program[0]
        An error occured during migration
  MySql.Data.MySqlClient.MySqlException (0x80004005): You have an error in your SQL syntax; check the manual that corre
  sponds to your MySQL server version for the right syntax to use near 'uniqueidentifier(36) NOT NULL,
      `Title` nvarchar(max) NULL,
      `Descriptio' at line 2
  
  </code></pre>
  <p>the migration file that the error is pointing to:</p>
  <pre><code>namespace Persistence.Migrations
  {
      public partial class ActivityEntityAdded : Migration
      {
          protected override void Up(MigrationBuilder migrationBuilder)
          {
              migrationBuilder.CreateTable(
                  name: &quot;Activities&quot;,
                  columns: table =&gt; new
                  {
                      Id = table.Column&lt;Guid&gt;(nullable: false),
                      Title = table.Column&lt;string&gt;(nullable: true),
                      Description = table.Column&lt;string&gt;(nullable: true),
                      Category = table.Column&lt;string&gt;(nullable: true),
                      Date = table.Column&lt;DateTime&gt;(nullable: false),
                      City = table.Column&lt;string&gt;(nullable: true),
                      Venue = table.Column&lt;string&gt;(nullable: true)
                  },
                  constraints: table =&gt;
                  {
                      table.PrimaryKey(&quot;PK_Activities&quot;, x =&gt; x.Id);
                  });
          }
  
          protected override void Down(MigrationBuilder migrationBuilder)
          {
              migrationBuilder.DropTable(
                  name: &quot;Activities&quot;);
          }
      }
  }
  </code></pre>
  <p>can someone please tell me how to fix this error? or does mysql not support guids as of yet?
  Please any input will be much appreciated!</p>