playing with dotnet core 52 - dataStorage19 using dotnet ef migrations to create MariaDb databases

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


Duration: 18:24
29 views
0

to install dotnet ef for migrations

dotnet tool install --global dotnet-ef
dotnet tool update --global dotnet-ef

in your project folder with the csproj file, you need to install:
dotnet add package Microsoft.EntityFrameworkCore.Design

to check if the dotnet ef tools are installed


To use dotnet ef for migrations if you have more than one DbContext

dotnet ef migrations add InitialCreate --context AppDbContext
dotnet ef database update --context AppDbContext

substitute AppDbContext with whatever the name of your Application DbContext is.

If you want to remove the migrations,
dotnet ef migrations remove --context AppDbContext

What do migrations do?
They initialise C# files used to interact with mariaDb, you will execute or invoke these files when you use dotnet ef database update --context AppDbContext.



------------------ Useful Links ------------------------------------
Credits to Kudvenkat PragimTech
https://www.youtube.com/watch?v=qJmEI2LtXIY&list=PL6n9fhu94yhVkdrusLaQsfERmL_Jh4XmU&index=49

EF Core Tools Installation
https://docs.microsoft.com/en-us/ef/core/cli/dotnet

dotnet core migrations, create database
https://docs.microsoft.com/en-us/ef/core/managing-schemas/migrations/?tabs=dotnet-core-cli


------ Video Sections ------
Chapters:
0:00 Introduction
1:35 installing dotnet ef
4:45 why use migrations?
6:47 starting out with fresh database
9:19 reminder: don't mix create API with migrations!
11:30 shut off dotnet watch before applying migrations
12:38 dotnet ef migrations add
13:10 dotnet ef migrations remove
13:58 dotnet ef migrations add (remember to specify which dbcontext you are using)
14:23 dotnet ef databse update
14:58 checking databases with mariadb
16:47 reminder: specify which dbContext you want to use
17:05 checking autogenerated C# files
17:34 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-19manjaro tricks open terminal in vim with split screen
2022-04-14playing with dotnet core 61 - libraries3 calling a vb library in a C# project
2022-04-13playing with dotnet core 60 - libraries2 calling a C# library in another project
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


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