75 liens privés
This comprehensive guide aims to elucidate the differences between AddTransient and AddScoped to help developers make informed decisions when registering repositories in ASP.NET Core applications.
EF Core => add Scoped
Kamil Grzybek Personal Site
Changes and improvements in Entity Framework Core 2.0
https://www.infoworld.com/article/3692811/how-to-use-the-unit-of-work-pattern-in-aspnet-core.html
Part 8 of Razor Pages and Entity Framework tutorial series.
string connectionstring = "Server=(localdb)\mssqllocaldb;Database=aspnet-WebApplication1-pouet;Trusted_Connection=True;MultipleActiveResultSets=true";
var sqlOptions = new DbContextOptionsBuilder<ApplicationDbContext>()
.UseSqlServer(connectionstring)
.Options;
using (ApplicationDbContext context = new ApplicationDbContext(sqlOptions))
{
// do sth
}
Configuring indexes in an Entity Framework Core model
// unique
[Index(nameof(Url), IsUnique = true)]
// composite
[Index(nameof(FirstName), nameof(LastName))]
_context.Entry(individuCompte).CurrentValues.SetValues(individuCompteFromClient);
public enum MembershipType
{
Free,
Premium
}
// Database Entity with MembershipType property
public class User
{
public int Id { get; set; }
public string FirstName { get; set; }
public string LastName { get; set; }
public MembershipType MembershipType { get; set; }}
public class BlogContext : DbContext
{
public BlogContext(DbContextOptions<BlogContext> options)
: base(options)
{
}
protected override void OnModelCreating(ModelBuilder modelBuilder)
{
modelBuilder.Entity<User>()
.Property(u => u.MembershipType)
.HasConversion<string>()
.HasMaxLength(50);
}
public DbSet<User> Users { get; set; }}