Please enable JavaScript.
Coggle requires JavaScript to display documents.
WORKING-DATA - Coggle Diagram
WORKING-DATA
ENTITY
Framework
Is-ORM
DbContext
Gateway
To-DB
Has
>=1
DbSet
LINQ
Query
DbSet
Translates
To-SQL
At-Runtime
Track-Changes
In-DbSet
Add/Modify/Delete
Persisting
Cmd
Applies
Changes
CODE-FIRST
PM-Console
Tools > NuGet Pkg Mgr
Migration
Enable
Enable-Migrations
Folder
Migrations
Created
Create
Add-Migration <MigName>
Recreate
-force
Run
Update-Database
MigFile
CreateTable
dbo.AspNet<>
Roles
UserRoles
Users
Identity
Authenticate
Authorize
IdentityModels.cs
AppDbContext
Extends
IdDbContext
AppUser
Extends
IdUser
On-AddMigration
EF
Looked
DbContext
Discovers
DbSets
In
IdDbContext
ModelTable
In-AppDbContext
Add
public
DbSet<MyModel>
MyModels
{get; set;}
OVERRIDING
Conventions
Using
System
DataAnnotations
ComponentModel
Add
Above-Field
[Required]
[StringLength(255)]
Create-Mig
QUERYING
In-Controller
private
AppDbContext
_context
Init
public CustomerController() {..}
_contex =
new AppDbContext()
Dispose
Override
_context.Dispose()
In-Actions
var customers
= _context.Customers
Deferred
Exec
Iteration
ListConvert
Eager-Load
RelatedObj
In-Controller
using
System
Data
Entity
Include
_context.Customers
.Include(..)
c => c.RelatedField
View
@customer
.RelatedField.Field
WORKFLOW
Types
Db-First
Generate-Tables
EF
Generates
DomainCls
Code-First
Create
DomainCls
EF
Generates
Tables
MODEL-CHANGING
Changes
Aim
SmallMig
Treat
GIT-commits
Entity
Every
PrimaryKey
Id
ModelNameId
Navigation
Property
Refer
OtherModel
public
OtherModel
OtherModelVar
Load
Obj
With
RelatedObj
ForeignKey
To-Not
Load
RelatedObj
public
int
OtherModelId
SEEDING-DB
Create
EmptyMig
Add-Migration MigName
Up()
Add
Sql("...")