playing with dotnet core 45 - dataStorage12 Configuring MariaDb ServerVersion and Connection String

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


Duration: 21:04
29 views
0

------------------ Useful Links ------------------------------------
dbContext and how to configure it
https://docs.microsoft.com/en-us/ef/core/dbcontext-configuration/#dbcontextoptions

dbContextOptionsBuilder class
https://docs.microsoft.com/en-us/dotnet/api/microsoft.entityframeworkcore.dbcontextoptionsbuilder?view=efcore-6.0

Where UseMySql is defined in pomelo EF Core
https://github.com/PomeloFoundation/Pomelo.EntityFrameworkCore.MySql/blob/957d15122023718108783b81e02815b42383a619/src/EFCore.MySql/Extensions/MySqlDbContextOptionsBuilderExtensions.cs


How to add and remove users in MariaDb (video)
https://www.youtube.com/watch?v=s_ki6l_RqSM&list=PLhPfNw4V4_YQSTR8sqz0aRVzWlQBq3QUw&index=34

CSharpCorner how to Configure EFCore to use MariaDb with aspNetCore 3.1
https://www.c-sharpcorner.com/article/how-to-configure-a-net-core-3-1-with-mariadb/

MariaDb User Configuration (ArchLinux wiki)
https://wiki.archlinux.org/title/MariaDB#Configuration

MariaDbServerVersion class
https://github.com/PomeloFoundation/Pomelo.EntityFrameworkCore.MySql/blob/ade47ba2358e5a8cfbd147db11beb7d64e15b02d/src/EFCore.MySql/Infrastructure/MariaDbServerVersion.cs

------------------ Video Sections --------------------------------
Chapters:
0:00 Introduction
0:29 UseMySql overload with connectionString and ServerVersion
2:11 Configuring a MariaDb ServerVersion Object
9:25 Making a new connection string
13:17 Making a new Privileged User in MariaDb that matches connection String
19:10 putting in connectionString into the dbContextOptionsBuilder Object
20:10 Conclusion

---------------------[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-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
2022-04-06playing with dotnet core 38 - dataStorage5 debugging the form and adding a repository interface
2022-04-06playing with dotnet core 37 - dataStorage4 adding forms for user input (and some bugs)
2022-04-05playing with dotnet core 36 - dataStorage3 injecting and testing a object with a list as singleton
2022-04-05playing with dotnet core 35 - dataStorage2 working with lists and preparing it as a singleton


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