I do not have a database so I just did it in memory but if you follow my comments, it will work for you. Notice the objects I have in memory, only comment with id 2 has replies. LoadComment method is where everything happens. The rest is just setup code I needed. class Program { … Read more
According to this article and this issue, there is no way (yet?) to encrypt the database using the Microsoft.Data.Sqlite assembly (used by EF Core). Based on this, here is what I’ve done to get it working with EF Core: add the System.Data.SQLite.Core package to the project while configuring your dbContext, give the optionsBuilder your own … Read more
Is this metadata available anywhere in EF Core? Yes it is. Just additionally to the properties examine the methods (GetXXX, FindXXX etc.). And pay special attention to Relational() extension methods. For instance: foreach (var entityType in dbContext.Model.GetEntityTypes()) { var tableName = entityType.Relational().TableName; foreach (var propertyType in entityType.GetProperties()) { var columnName = propertyType.Relational().ColumnName; } } You … Read more
As others already explained, you should use a scoped dependency for database contexts to make sure it will be properly reused. For concurrency, remember that you can query the database asynchronously too, so you might not need actual threads. If you do need threads, i.e. background workers, then it’s likely that those will have a … Read more
I implemented an approach similar to this that is covered in this blog post and basically involves creating a service that will use dependency injection to inject the HttpContext (and underlying user information) into a particular context, or however you would prefer to use it. A very basic implementation might look something like this: public … Read more
Unfortunately, you have to either do it manually or create your own IUserStore<IdentityUser> where you load related data in the FindByEmailAsync method: public class MyStore : IUserStore<IdentityUser>, // the rest of the interfaces { // … implement the dozens of methods public async Task<IdentityUser> FindByEmailAsync(string normalizedEmail, CancellationToken token) { return await context.Users .Include(x => x.Address) … Read more
Here’s a very crude, incomplete, and untested implementation of .Find() as an extension method. If nothing else, it should get you pointed in the right direction. The real implementation is tracked by #797. static TEntity Find<TEntity>(this DbSet<TEntity> set, params object[] keyValues) where TEntity : class { var context = ((IAccessor<IServiceProvider>)set).Service.GetService<DbContext>(); var entityType = context.Model.GetEntityType(typeof(TEntity)); var … Read more
If you really want to create the context manually, then you can configure it like this: var optionsBuilder = new DbContextOptionsBuilder<ApplicationDbContext>(); optionsBuilder.UseSqlServer(Configuration.GetConnectionStringSecureValue(“DefaultConnection”)); _context = new ApplicationDbContext(optionsBuilder.Options); (The DbContextOptionsBuilder<ApplicationDbContext> class is the type of options argument in services.AddDbContext<ApplicationDbContext>(options =>). But in the controller, you don’t have access to Configuration object, so you would have to expose … Read more
To set the ASPNETCORE_ENVIRONMENT variable in Package Manager Console (PMC) , inside visual studio, to Production use this command first $env:ASPNETCORE_ENVIRONMENT=’Production’ Then you can use Update-Database normally.
The error message indicates that EF Core is trying to read string value for a required property, i.e. a property which should never have null value in the database, but instead the underlying data reader reports null value for that property in some record(s). Looking at your entity model and corresponding database table, you can … Read more