playing with dotnet core 49 - dataStorage16 mySql connectionReuse error my guess of the bug cause

Channel:
Singapore Theo Ong Science and Engineering
Subscribers:
9,750
Published on ● Video Link: https://www.youtube.com/watch?v=EKq3Z_Khy-0


Duration: 13:10
15 views
0

TLDR
Do NOT use DbContext.SaveChanges() method in a for loop
------------------ Useful Links ------------------------------------
Connection Reuse error
https://mysqlconnector.net/troubleshooting/connection-reuse/

------------------ Video Sections --------------------------------
Chapters:
0:00 intro
1:13 how i found the cause of the bug
3:43 do NOT use SaveChanges in a forloop
5:15 forloop and parallel processing
8:19 im guessing SaveChanges doesn't like to be run in parallel
11:55 possible ways of having mulitple connections at one go

---------------------[Playlists and Relevant Github Repositories]----------------------------------------------

Fluid Mechanics and Git Repos:
https://www.youtube.com/playlist?list=PLhPfNw4V4_YSmdAXc6J0XOSQ1b27qsMGt
https://github.com/theodoreOnzGit/OpenFoam_heatTrf_YouTube

Petroleum Downstream Crash Course Playlist:
https://www.youtube.com/playlist?list=PLhPfNw4V4_YQ13CnhacUqEVk-tZlU4ISE

OpenFOAM for Windows 10 Beginner Playlist and some Git Repos
https://www.youtube.com/playlist?list=PLhPfNw4V4_YRhBU4IqSaToQ8_X543YQsZ
https://github.com/theodoreOnzGit/laminar_BL_OpenFOAM

OpenFOAM Intermediate Playlist and some Git Repos
https://www.youtube.com/playlist?list=PLhPfNw4V4_YSpWX6mSOlwWEOKVa6i_iuE
https://github.com/theodoreOnzGit/thin_pipeflow_snappyHexMesh

OpenFOAM Heat Transfer Playlist and GitHub Repo
https://www.youtube.com/playlist?list=PLhPfNw4V4_YR2Qa3Q9-AzNSF2J9Dc4_qT
https://github.com/theodoreOnzGit/OpenFoam_heatTrf_YouTube

Radiation Heat Transfer Learning Journal and Git Repos:
https://www.youtube.com/watch?v=uUzh9kh-WTo&list=PLhPfNw4V4_YRUUVUydQp-n6U-7uu1kJof
https://github.com/theodoreOnzGit/heatTransferTheory_YouTube

Convection Boundary Layer and git Repos:
https://www.youtube.com/playlist?list=PLhPfNw4V4_YR9pRBpp101Mkuds49vjQ63
https://github.com/theodoreOnzGit/heatTransferTheory_YouTube

Turbulence Modelling Playlist
https://www.youtube.com/watch?v=F_Rxv9uMM3g&list=PLhPfNw4V4_YSnbYkJIBQ1kRN06Mmxe2Be
https://github.com/theodoreOnzGit/turbulenceModelling

LabView Frequency Analysis and Fun (playlist and git repo)
https://www.youtube.com/playlist?list=PLhPfNw4V4_YQYE7XqTisMBkpm7gqNS_nl
https://github.com/theodoreOnzGit/Ted_labview_YouTube

Control Systems and Frequency Response
https://www.youtube.com/watch?v=qHY6y7JmB2U&list=PLhPfNw4V4_YRUuWnrtClovPKxU_gJOXH-
https://github.com/theodoreOnzGit/matlabFrequencyResponse.git

OpenFOAM C++
https://github.com/theodoreOnzGit/C-_YouTube_OpenFoam
https://www.youtube.com/playlist?list=PLhPfNw4V4_YT9OgqS7ZPlot_Ucxzc6pQJ

OpenFOAM Bash
https://github.com/theodoreOnzGit/Bash_OpenFOAM_YouTube
https://www.youtube.com/playlist?list=PLhPfNw4V4_YT5zjBhfj5Hj4r4D5eXilcU

Basic Samba
https://www.youtube.com/playlist?list=PLhPfNw4V4_YQuWJLufBUpNplitReZX0fB
https://github.com/theodoreOnzGit/sambaVideos

Manjaro Tips and Tricks
https://www.youtube.com/playlist?list=PLhPfNw4V4_YQuyXBfJxAvzHJTl0UiWx3h

lammps and Discrete Element Modelling (DEM)
https://www.youtube.com/playlist?list=PLhPfNw4V4_YTdRlnLiu2OUXeTf5ZNVQ9E

playing with dotnet core
https://www.youtube.com/playlist?list=PLhPfNw4V4_YQSTR8sqz0aRVzWlQBq3QUw
dotnet core github repo
https://github.com/theodoreOnzGit/dotnetCoreYoutube



Other Videos By Theo Ong Science and Engineering


2022-04-13playing with dotnet core 59 - dotnet new gitignore autogenerated gitignore for dotnet
2022-04-13playing with dotnet core 58 - libraries1 calling visualBasic libraries in C# and solution files
2022-04-12playing with dotnet core 57 - vb libraries and F# libraries using dotnet CLI
2022-04-12playing with dotnet core 56 - dropdown list for inputs html select
2022-04-12playing with dotnet core 55 - making tables look nicer with bootstrap for razor pages
2022-04-11playing with dotnet core 53 - dataStorage20 using dotnet ef migrations to add a new column to databa
2022-04-11playing with dotnet core 54 - dataStorage21 updateMethod debugging and understanding change tracking
2022-04-11playing with dotnet core 52 - dataStorage19 using dotnet ef migrations to create MariaDb databases
2022-04-11playing with dotnet core 51 - dataStorage18 Setting up repository using AddDbContext Dependency inje
2022-04-08playing with dotnet core 50 - dataStorage17 AddDbContext AddDbContextPool for dependency injection
2022-04-08playing with dotnet core 49 - dataStorage16 mySql connectionReuse error my guess of the bug cause
2022-04-08playing with dotnet core 48 - dataStorage15 debugging duplicate key ID errors in EFCore
2022-04-08playing with dotnet core 47 - dataStorage14 implmentation of CRUD create drop APIs and debugging
2022-04-07playing with dotnet core 46 - dataStorage13 Implementing MariaDb Repository Methods
2022-04-07playing with dotnet core 45 - dataStorage12 Configuring MariaDb ServerVersion and Connection String
2022-04-07playing with dotnet core 44 - dataStorage11 configuring AppDbContext based on MariaDbServerVersion
2022-04-07playing with dotnet core 43 - dataStorage10 going thru documentation of DbContext family of classes
2022-04-07playing with dotnet core 42 - dataStorage9 introduction to EFCore and dBContext family of classes
2022-04-06playing with dotnet core 41 - dataStorage8 testing delete and update operations for Repository RAM
2022-04-06playing with dotnet core 40 - dataStorage7 testing Repository RAM Implementation
2022-04-06playing with dotnet core 39 - dataStorage6 implementing a RAM repository interface


Tags:
Engineering
Math
Science
Thermodynamics
Fluid Mechanics
Chemical
Nuclear
Chemical Potential
Fugacity
Enthalpy
Internal Energy
Entropy
First Law
Second law
Gibbs Free Energy
Hemholtz free energy
heat capacity
constant volume
constant pressure
tutorial
petroleum
oil
refinery
downstream
crude
jet
gasoline
gasoil
diesel
computational fluid dynamics
CFD
OpenFoam
Open
Foam
Fluid mechanics
heat transfer
turbulence
conduction
convection
radiation
Linux
Mint
Ubuntu
Manjaro