Context: I have an application in Azure that receives information from multiple clients, however, sometimes the client sends multiple messages at once which seems to cause duplicate entries in my database. The message has an externalid (id on client side),…
Deepening my knowledge in ASP.NET, I have a question that arises from the following class: public class AppDbContext : DbContext { public AppDbContext(DbContextOptions<AppDbContext> options) : base(options) { } public DbSet<Route> Routes { get; set; } } What is the difference…
I read book Ultimate ASP.NET Core Web API. And there is a code first database creation using DbContext and IDesignTimeDbContextFactory<>. public class RepositoryContextFactory : IDesignTimeDbContextFactory<RepositoryContext> { public RepositoryContext CreateDbContext(string[] args) { var configuration = new ConfigurationBuilder() .SetBasePath(Directory.GetCurrentDirectory()) .AddJsonFile("appsettings.json") .Build(); var…
I need a live demo for a product. Said product uses ASP.NET with Entity Framework. Currently I create a new in-memory database like this: var sqliteConnection = new SqliteConnection("DataSource=:memory:"); sqliteConnection.Open(); builder.Services .AddDbContextFactory<DatabaseContext> (options => options.UseSqlite(sqliteConnection, o => o.UseQuerySplittingBehavior(QuerySplittingBehavior.SplitQuery))); However, I…
Using Task.Run causes "object disposed" exception in my application if using DbContext. The code looks like (see the whole chain): UserController.cs [Route("api/[controller]")] public class UsersController : ControllerBase { private readonly UserService userService; /// <summary> /// </summary> /// <param name="userService"></param> public…
Hello I am trying to create an instance of the db in the constructor of the controller to be able to use it throughout the controller but it keep throwing an error. This is the error I am getting: InvalidOperationException:…
I have an .Net5 solution using Entity Framework 5.0.0. Im able to save data to the Backend SQL DB and all is well. But when I try to check is a record exist using the statement below im getting an…
I am implementing an API and as part of it I have setup a custom .Net Middleware service extension UseRequestLoggingModdlewareExtension() that it run between the following: app.UseHttpsRedirection(); app.UseRequestLoggingModdlewareExtension(); app.UseRouting(); The code is simple, and just logs the output of the…
I'm using a project with 1 code-first DbContext and 1 database-first DbContext in an asp.net webapi project. Running the following commands to update the db/context results in the following errors: dotnet ef dbcontext scaffold Name=ConnectionStrings:Cloud Microsoft.EntityFrameworkCore.SqlServer System.InvalidOperationException: A named connection…