Transient Failure handling in .net core 2.1 MVC for MySQL Database

.net-core asp.net-core entity-framework-core mysql

Question

services.AddDbContext<MyContext>(options =>
{
    options.UseSqlServer(mysqlConnection,
    sqlServerOptionsAction: sqlOptions =>
    {
        sqlOptions.EnableRetryOnFailure(
        maxRetryCount: 10,
        maxRetryDelay: TimeSpan.FromSeconds(30),
        errorNumbersToAdd: null);
    });
});

I found this code snippet at:

https://docs.microsoft.com/en-us/dotnet/standard/microservices-architecture/implement-resilient-applications/implement-resilient-entity-framework-core-sql-connections

My DB is MySQL 5.7

I changed the above code to :

enter image description here

That means EnableRetryOnFailure is not available for MySQL DB. How do i set the retry, delay etc.. policies now?

Also if i try to set the ExecutionStrategy function i get this:

enter image description here

Then i tried Create my own Strategy using:

public class MyStrategy: ExecutionStrategy
{
   ......
}

but how to use this class now?

1
1
3/30/2019 2:35:55 PM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Accepted Answer

There is a library for this: https://github.com/PomeloFoundation/Pomelo.EntityFrameworkCore.MySql

Setup steps:

  1. Donwload Pomelo.EntityFrameworkCore.MySql from NuGet.

  2. Add this using to your class:

    using Pomelo.EntityFrameworkCore.MySql.Infrastructure;

  3. Add this to your ConfigureServices method:

    services.AddDbContextPool<ApplicationDbContext>( 
options => options.UseMySql("Server=localhost;Database=ef;User=root;Password=123456;",

    mySqlOptions =>
    {
        mySqlOptions.ServerVersion(new Version(5, 7, 17), ServerType.MySql)
        .EnableRetryOnFailure(
        maxRetryCount: 10,
        maxRetryDelay: TimeSpan.FromSeconds(30),
        errorNumbersToAdd: null); 
    }
));
3
3/30/2019 7:59:20 PM

Related Questions

EF Core 2.0/2.1 - How to efficiently handle large, infrequently accessed columns?

I have a table as follows:...CREATE TABLE MyTable ( ID INT NOT NULL PRIMARY KEY, NAME VARCHAR(50) NOT NULL, LARGEBLOB VARBINARY(MAX) NULL ) ...With an Entity defined as:...public class Entity { public int Id {get;set;} public string Name {get;set;} public virtual byte[] LargeBlob {get;set;} } ...99% of my use cases involve displaying I...
ef-core-2.0 entity-framework entity-framework-core
asked by ubienewbie

.net Core 2.1.x EntityFramework | DatabaseGeneratedAttribute annotations could not be found

After a exploring the ...API docs... for the annotations, I figured that one needs to include the following using statement:...using System.ComponentModel.DataAnnotations.Schema; ...The tutorials of .NET Core Entity Framework that I was referring to seems to be misleading as it only had this "using" statement:...using Microsoft.EntityFrameworkCore;...
.net entity-framework-core
asked by b.sodhi

.NET Core 2.1 and EF Framework 2.1

Despite the short-sited nature of .NET Core applications being hosted by IIS as a proxy front end, it appears that the AppPool running the IIS Proxy requires access to the same database server that the SQL Account used for the database requires... YUCK! ...Thanks to Edward (who posted a comment), it led me to this post:...https://weblog.west-wind.c...
.net-core c# entity-framework entity-framework-core odata
asked by Stewart Basterash

.Net Core 2.1 EF Core Null Reference Exception when searching database with Where linq query

Turns out my Engine table had CompanyId instead of Company. All I had to do was change it to:...var context = _context.Engine .Include(e => e.EngineType) .Where(e => e.CompanyId == user.CompanyId);
.net-core entity-framework-core
asked by Ian Gleeson

Best way to coordinate atomic transactions between different business services in .NET Core / EF Core 2.1?

If your transaction extend across service boundaries that is so called ...Transactional integration antipattern.... ...One way to coupe with that issue is to use external orchestration service (for example ...Camunda...). It's responsibility would be to handle business flow and do some compensation actions on failure. It wouldn't be totally "transa...
.net asp.net-core c# entity-framework entity-framework-core
asked by nikita

.net core 2.1 multiple DbContext for same database

The concept of having bounded contexts is fine, per se. It's based on the idea that the particular application shouldn't have access to things it doesn't need. Personally, I think it's a tad bit of overkill, but reasonable people can disagree on the issue....However, what you have here, is simply wrong. If your application needs access to all these...
asp.net-core-2.1 dbcontext entity-framework entity-framework-core
asked by Chris Pratt

.NET Core 2.1 Identity : Creating a table for each Role + bridge M:M table

I'm having issues in figuring out the best design that fits my needs regarding a Role based authorizations using Identity in a .NET Core 2.1 project....I already extended the User class from Identity with an ApplicationUser class. I need 5 different roles to control the access to the different features of the app :...Admin, Teacher, Student, Parent...
.net-core asp.net-core-identity entity-framework-core
asked by Gapwe

Using multiple models in tabs with Razor Pages Viewcomponent .Net Core 2.1

There's a few options available to you. Your best path forward, honestly, is a wrapper class, essentially a model of models, if you will. You simply create a class with properties on it for each of the individual models you actually need. This then allows you to use this as the model for your page, but still access all your individual models for th...
asp.net-core-2.1 asp.net-core-viewcomponent c# entity-framework-core razor
asked by Chris Pratt

Getting acces to List<T> in model in ASP .Net Core MVC 2.1

Everything seems to be okay, however try to explicitly include the animals... Farm theFarm = _context.Farms.Include(f => f.Animals).Where(f => f.Id == farmId); ...the object theFarm will contain all fields of the farm and also the list with animals. and farmId is the id of the farm you want to get....use this to get all farms with their animals:...
asp.net c# entity-framework-core razor
asked by Daan

.Net Core 2.1 seems to be ignoring modelBuilder.Entity<TEntity>().HasData

You should pay attention to compiler warnings....Here...protected internal virtual void OnModelCreating(ModelBuilder modelBuilder) ...you are shadowing the base ...OnModelCreating... method (there must be a compiler warning telling that). And of course EF Core infrastructure is not calling your method, but the one defined in ...DbContext... class. ...
.net-core c# entity-framework entity-framework-core enums
asked by Ivan Stoev

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge
View more on Stack Overflow

Prime Library

Performance

Expression Evaluator

More Projects...

Related

Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow