I have been struggling to get the final SAMPLE (ASP.Net, EF Core, SQL) to work against a real SQL Server. Every sample I can find does not use real SQL they always opt for in-memory data store

I changed the connection string 

```
"Data Source=.;Initial Catalog=IS4;Integrated Security=True;"

```

and ran

```
dotnet ef database update -c ApplicationDbContext

```

This created me a SQL database with 25 tables.

I tweaked Startup.cs to change 

```
        services.AddDbContext<ApplicationDbContext>(options =>
            options.UseSqlServer(connectionString));

```

and b.UseSqlite to b.UseSqlServer

```
            .AddConfigurationStore(options =>
            {
                options.ConfigureDbContext = b =>
                    b.UseSqlServer(connectionString,
                        sql => sql.MigrationsAssembly(migrationsAssembly));
            })
            // this adds the operational data from DB (codes, tokens, consents)
            .AddOperationalStore(options =>
            {
                options.ConfigureDbContext = b =>
                    b.UseSqlServer(connectionString,
                        sql => sql.MigrationsAssembly(migrationsAssembly));

                // this enables automatic token cleanup. this is optional.
                options.EnableTokenCleanup = true;
                // options.TokenCleanupInterval = 15;
            });

```

I ran the server with "/seed" on the command line but the Seed functionality doesn't work

First it complains CLIENT can't have a NULL ID when it calls SaveChanges(). If I change the code to add the ID 

```
        if (!context.Clients.Any())
        {
            Console.WriteLine("Clients being populated");
            int i = 1;
            foreach (var client in Config.GetClients().ToList())
            {
                var x = client.ToEntity();
                x.Id = i++;
                context.Clients.Add(x);
            }
            context.SaveChanges();
        }
        else
        {
            Console.WriteLine("Clients already populated");
        }

```

I then get 

```
"Cannot insert the value NULL into column 'Id', table 'IS4.dbo.ClientGrantTypes".

```

When I watch the video's it says it can be migrated from SQLite to full SQL simply by changing the connection string which is obviously not true, given all the other changes I have done, so I must be doing (or missing) something else.

Any thoughts?