playing with dotnet core 46 - dataStorage13 Implementing MariaDb Repository Methods

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


Duration: 38:38
6 views
0

We implemented
getComponent using DbSet.Find(int keyvalue)
createComponent using DbSet.Add(TEntity Object)
deleteComponent using DbSet.Remove(TEntity Object)

remember to use DbContext.SaveChanges() after creating or deleting components

------------------ Useful Links ------------------------------------
Giving Credit to Kudvenkat pragim tech
https://www.youtube.com/watch?v=qJmEI2LtXIY&list=PL6n9fhu94yhVkdrusLaQsfERmL_Jh4XmU&index=50

IEnumerable
https://docs.microsoft.com/en-us/dotnet/api/system.collections.generic.ienumerable-1?view=net-6.0

DbSet
https://docs.microsoft.com/en-us/dotnet/api/system.data.entity.dbset-1?view=entity-framework-6.2.0#:~:text=A%20DbSet%20represents%20the%20collection,a%20DbContext%20using%20the%20DbContext.

List
https://docs.microsoft.com/en-us/dotnet/api/system.collections.generic.list-1?view=net-6.0


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


DbContext.SaveChanges()
https://docs.microsoft.com/en-us/dotnet/api/microsoft.entityframeworkcore.dbcontext.savechanges?view=efcore-6.0#microsoft-entityframeworkcore-dbcontext-savechanges


------------------ Video Sections --------------------------------
Chapters:
0:00 introduction
0:45 Adding DbSet to AppDbContext
4:24 changing List return type to IEnumerable so that both List and DbSet can be used
13:08 credit to pragimtech
13:38 updating the IAppDbContext interface
19:06 implementing getComponent using DbSet.Find(int keyvalue)
24:09 implementing populateComponents with dependency injection
32:41 implementing getAllComponents
33:51 clear Components (or maybe not)
34:56 implementing deleteComponent using DbSet.Remove(object)
38:25 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 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
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


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