Using SQL Query in Migration file

in migration UP part

migrationBuilder.Sql("INSERT INTO Makes (Name) VALUES ('Test')");

migrationBuilder.Sql("INSERT INTO Models (Name, MakeID) VALUES ('Model 1', (SELECT Id FROM Makes WHERE Name = 'Test'))");