Advertisements I use these statements: using (var factory = _contextFactory.CreateDbContext()) { var itemsQueryable = factory.Set<AppUser>().AsQueryable(); var result = itemsQueryable?.Where(c => c.AccessFailedCount <= maxMedals); … } this is a factory of my identityContext, but when I run the code, there is an error: System.ObjectDisposedException: Cannot access a disposed context instance. A common cause of this error… Read More _contextFactory.CreateDbContext() not working

Advertisements I am Injecting GenericRepository into BL service that calles it in order to get data from entity framework. No Exception is thrown until I am trying to add the other BL Service as scoped I get the following Exception: System.AggregateExceptionHResult=0x80131500 Message=Some services are not able to be constructed (Error while validating the service descriptor… Read More Injecting Generic Service

Advertisements I have 2 models, one for Poll and for PollOption. In the create action, I want to add 1 Poll to the database and a list of PollOptions as well. Each PollOption has a foreign key PollId. When I submit the form, an error occurs because the foreign key is null or 0. I… Read More Foreign key merge statement error in asp.net when submitting form

Advertisements I have a list of IDs and I need to retrieve entities from a database in exact same order, that IDs in the list. Such query will return wrong order: List<Guid> listOfIds = targetIds; var result = await dbContext .TargetEnities .Where(x => listOfIds.Contains(x.Id)) .ToListAsync(); I see a way to make requests in a loop… Read More EF Linq. How to keep "Where in" sorting

Advertisements I have a mysql database and I can not delete it. I lost my migrations in asp.net project and I changed some things in dbcontext files. When I try make a new migration and update-database it says Table ‘aspnetroles’ already exists. What should I do? How can restore migration or how can ı equate… Read More How to restore databases migration

Advertisements So I have a context class EFCoreMContext with defined property EFCore.DBSet<AccessTime> AccessTime public class EFCoreMContext : Microsoft.EntityFrameworkCore.DbContext { public Microsoft.EntityFrameworkCore.DbSet<User> Users { get; set; } public Microsoft.EntityFrameworkCore.DbSet<AccessTime> AccessTime { get; set; } … } Then I have a repository class CAccessTimeRepository public class CAccessTimeRepository : IRepository<AccessTime> { private EFCoreMContext db; public CAccessTimeRepository(EFCoreMContext context) {… Read More EF Core async LINQ Where(predicate).ToListAsync() Error: CS1061 IEnumerable does not contain ToListAsync()

Advertisements I’m making an app for a bootcamp where I call a third party API to get dog breeds, then I use 2 created apis to store users and the users favorites to 2 SQL database created with EF. I have an Angular front end that is where all of these will interact. I’m trying… Read More API call link in angular not calling API but created link works in postman

Advertisements I have the following Entities: public class CounterOwner { public int Id { get; set; } public string Name { get; set; } = null!; public ICollection<CounterEntry> CounterEntries { get; set; } = new List<CounterEntry>(); } public class CounterEntry { public int Id { get; set; } public DateTime DateTime { get; set; }… Read More EFCore GroupBy nested List

Advertisements I am receiving the following error: Cannot implicitly convert type: ‘Microsoft.EntityFrameworkCore.DbContextOptions<TvApi.Data.TvMazeContext>’ to ‘TvApi.Data.TvMazeContext’ TvApi Something is wrong in this part db = context of my controller but I don’t know what: public ShowsController(ILogger<ShowsController> logger, DbContextOptions<TvMazeContext> context) { _logger = logger; db = context; } This is my controller: using Microsoft.AspNetCore.Mvc; using Microsoft.EntityFrameworkCore; using TvApi.Data;… Read More Cannot implicitly convert type probably in controller

Advertisements public enum GeneticModificationTypes { SomeType = 1, AnotherType = 2, ThirdType = 3 } public class GeneticModification: FullAuditedEntity<Guid> { public ICollection<GeneticModificationTypes> Types { get; set; } } modelBuilder.Entity<GeneticModification>() .Property(e => e.Types) .HasConversion( v => string.Join(‘,’, v), v => v.Split(‘,’, StringSplitOptions.RemoveEmptyEntries).ToList() ?? new List<GeneticModiciation>()) .Metadata.SetValueComparer(valueComparer); var valueComparer = new ValueComparer<ICollection<string>>( (c1, c2) => c1.SequenceEqual(c2), c… Read More List of enums EF Core LINQ query