ho fatto un nuovo progetto perchè l'altro era un pò pasticciato,
ho aggiunto la tabella MessageWithKey
ho eseguito il comando: Scaffold-DbContext "Server=(localdb)\mssqllocaldb;Database=aspnet-TestWithKey-0E6FB1F9-BD7A-4E90-AC2C-CC66E592F25C;Trusted_Connection=True;MultipleActiveResultSets=true;" Microsoft.EntityFrameworkCore.SqlServer -OutputDir Models -Tables MessageWithKey,AspNetUsers
e non ho ricevuto nessun errore
segue la classe MessageWithKey
using System;
using System.Collections.Generic;
namespace TestWithKey.Models
{
public partial class MessageWithKey
{
public int Id { get; set; }
public string IdUtente { get; set; }
public string Testo { get; set; }
public virtual AspNetUsers IdUtenteNavigation { get; set; }
}
}
l'uso di database first ha comportato la creazione di un nuovo dbcontext
using System;
using Microsoft.EntityFrameworkCore;
using Microsoft.EntityFrameworkCore.Metadata;
namespace TestWithKey.Models
{
public partial class aspnetTestWithKey0E6FB1F9BD7A4E90AC2CCC66E592F25CContext : DbContext
{
public aspnetTestWithKey0E6FB1F9BD7A4E90AC2CCC66E592F25CContext()
{
}
public aspnetTestWithKey0E6FB1F9BD7A4E90AC2CCC66E592F25CContext(DbContextOptions<aspnetTestWithKey0E6FB1F9BD7A4E90AC2CCC66E592F25CContext> options)
: base(options)
{
}
public virtual DbSet<AspNetUsers> AspNetUsers { get; set; }
public virtual DbSet<MessageWithKey> MessageWithKey { get; set; }
protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
{
if (!optionsBuilder.IsConfigured)
{
#warning To protect potentially sensitive information in your connection string, you should move it out of source code. See http://go.microsoft.com/fwlink/?LinkId=723263 for guidance on storing connection strings.
optionsBuilder.UseSqlServer("Server=(localdb)\\mssqllocaldb;Database=aspnet-TestWithKey-0E6FB1F9-BD7A-4E90-AC2C-CC66E592F25C;Trusted_Connection=True;MultipleActiveResultSets=true;");
}
}
protected override void OnModelCreating(ModelBuilder modelBuilder)
{
modelBuilder.HasAnnotation("ProductVersion", "2.2.4-servicing-10062");
modelBuilder.Entity<AspNetUsers>(entity =>
{
entity.HasIndex(e => e.NormalizedEmail)
.HasName("EmailIndex");
entity.HasIndex(e => e.NormalizedUserName)
.HasName("UserNameIndex")
.IsUnique()
.HasFilter("([NormalizedUserName] IS NOT NULL)");
entity.Property(e => e.Id).ValueGeneratedNever();
entity.Property(e => e.Email).HasMaxLength(256);
entity.Property(e => e.NormalizedEmail).HasMaxLength(256);
entity.Property(e => e.NormalizedUserName).HasMaxLength(256);
entity.Property(e => e.UserName).HasMaxLength(256);
});
modelBuilder.Entity<MessageWithKey>(entity =>
{
entity.Property(e => e.IdUtente)
.HasColumnName("Id_Utente")
.HasMaxLength(450);
entity.Property(e => e.Testo).HasColumnName("testo");
entity.HasOne(d => d.IdUtenteNavigation)
.WithMany(p => p.MessageWithKey)
.HasForeignKey(d => d.IdUtente)
.HasConstraintName("FK_MessageWithKey_AspNetUsers");
});
}
}
}
l'uso di dadatabase first ha comportato anche la creazione di una classe AspNetUsers sotto Models
using System;
using System.Collections.Generic;
namespace TestWithKey.Models
{
public partial class AspNetUsers
{
public AspNetUsers()
{
MessageWithKey = new HashSet<MessageWithKey>();
}
public string Id { get; set; }
public string UserName { get; set; }
public string NormalizedUserName { get; set; }
public string Email { get; set; }
public string NormalizedEmail { get; set; }
public bool EmailConfirmed { get; set; }
public string PasswordHash { get; set; }
public string SecurityStamp { get; set; }devo
public string ConcurrencyStamp { get; set; }
public string PhoneNumber { get; set; }
public bool PhoneNumberConfirmed { get; set; }
public bool TwoFactorEnabled { get; set; }
public DateTimeOffset? LockoutEnd { get; set; }
public bool LockoutEnabled { get; set; }
public int AccessFailedCount { get; set; }
public virtual ICollection<MessageWithKey> MessageWithKey { get; set; }
}
}
ho provato ad aggiungere un controller usando la classe MessageWithKeys ed il db context aspnetTestWithKey0E6FB1F9BD7A4E90AC2CCC66E592F25CContext ma quando chiamo il controller ottengo il seguente messaggio di errore:
An unhandled exception occurred while processing the request.
InvalidOperationException: Unable to resolve service for type 'TestWithKey.Models.aspnetTestWithKey0E6FB1F9BD7A4E90AC2CCC66E592F25CContext' while attempting to activate 'TestWithKey.Controllers.MessageWithKeysController'.
se provo a creare un controller usando ApplicationDbCOntext ottengo l'errore :
"Si è verificato un errore durante l'esecuzione del generatore di codice selezionato.
'Cannot use table AspNetUsers for entity type 'IdentityUser' and there is no relationship between their primary keys'
se devo fornire altre informazioni dimmi pure cercherò d'essere più chiaro,grazie per l'aiuto,ciao
