Blazor Vue .Net8 template migration

tiptopweb · January 8, 2024, 6:45am

Hello
I have installed the new Blazor Vue .Net8 template

using x new

With no change, everything is looking good until I try to login (AspNetUser table not found)
The Migration looks like creating correctly creating the tables for Ormlite but NOT for Identity

Using JetBrains Rider and Windows 10 Home

Thierry

tiptopweb · January 8, 2024, 6:53am

After deleting the app.db and running migration, I am getting

Running AppTask 'migrate'...
info: Tiptopweb.AFFFF.Demo.ConfigureDbMigrations[0]
      Running EF Migrations...
info: Microsoft.EntityFrameworkCore.Database.Command[20101]
      Executed DbCommand (2ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
      SELECT COUNT(*) FROM "sqlite_master" WHERE "type" = 'table' AND "rootpage" IS NOT NULL;
ERROR: Failed to run AppTask 'migrate', Exception: Could not load file or assembly 'Demo, Culture=neutral, PublicKeyToken=null'. The system cannot find the file specified.
System.IO.FileNotFoundException: Could not load file or assembly 'Demo, Culture=neutral, PublicKeyToken=null'. The system cannot find the file specified.
File name: 'Demo, Culture=neutral, PublicKeyToken=null'

My project is Tiptopweb.AFFFF.Demo
So it looks like it is missing the beginning of the name before the dot
Tiptopweb.AFFFF.Demo.dll vs Demo.dll

I cannot find where it is missing in the generated code

layoric · January 8, 2024, 7:01am

Can you share the x new command/project name you used? I might be an issue with using . dots in the name along with the name replacement happening in the EF migrations or DB context. Are you able to create and run a project without dots?

tiptopweb · January 8, 2024, 7:06am

x new blazor-vue Tiptopweb.AFFFF.Demo

ok, it does not like the dots
x new blazor-vue TiptopwebAFFFFDemo
is working, I can always get the DB from the other project or script it

Redvo · January 8, 2024, 2:47pm

Did u use ef migration commands from commandline?

dotnet ef migrations add CreateIdentitySchema
dotnet ef database update

github.com

NetCoreTemplates/blazor-vue/blob/main/MyApp/Program.cs#L36


      
          services.AddAuthorization();
          services.AddAuthentication(options =>
              {
                  options.DefaultScheme = IdentityConstants.ApplicationScheme;
                  options.DefaultSignInScheme = IdentityConstants.ExternalScheme;
              })
              .AddIdentityCookies();
          services.AddDataProtection()
              .PersistKeysToFileSystem(new DirectoryInfo("App_Data"));
          
          // $ dotnet ef migrations add CreateIdentitySchema
          // $ dotnet ef database update
          var connectionString = config.GetConnectionString("DefaultConnection") ?? throw new InvalidOperationException("Connection string 'DefaultConnection' not found.");
          services.AddDbContext<ApplicationDbContext>(options =>
              options.UseSqlite(connectionString, b => b.MigrationsAssembly(nameof(MyApp))));
          services.AddDatabaseDeveloperPageExceptionFilter();
          
          services.AddIdentityCore<ApplicationUser>(options => options.SignIn.RequireConfirmedAccount = true)
              .AddRoles<IdentityRole>()
              .AddEntityFrameworkStores<ApplicationDbContext>()
              .AddSignInManager()

Edit:

Sorry, did not realize you have resolved it. I too had problems with dot in project name, had to recreate it without dots.

It seems dotnet ef command strips the whole project name and takes only part after last dot for migration assembly name.

If someone knows the solution, or why that happens, I would be happy to know the answer.