Video: Entity Framework Code First (Bulgarian)
Video lecture about the code first approach in Entity Framework.
The video is recorded in 2014 in a training I was delivering in Burgas, Bulgaria.
Entity Framework Code First is a method of developing software applications that utilizes the Entity Framework and focuses on the code-first approach. The modeling workflow of Entity Framework Code First involves defining domain classes or models that represent the objects in the application. These models are then used to create a database using the DbContext and DbSets classes.
A database connection is established and managed by the DbContext class, and the database is created based on the models defined in the domain classes. Code First Migrations are used to manage database changes and keep track of the evolution of the database over time.
The mappings between the domain classes and the database are configured using either Data Annotations or Fluent API. Data Annotations are attributes that are added to the models to specify the properties of the database, such as the primary key, data type, etc. Fluent API is a more flexible way of defining mappings that allows developers to use a fluent API syntax instead of data annotations.
Topics covered:
- Modeling Workflow
- Code First Main Parts
- Domain Classes (Models)
- DbContext and DbSets
- Database connection
- Using Code First Migrations
- Configure Mappings
- Data Annotations and Fluent API
Video: Introduction to the Entity Framework (Bulgarian)
Video lecture with an introduction to the Entity Framework ORM.
The video is recorded in 2014 in a training I was delivering in Burgas, Bulgaria.
Topics covered:
- ORM Technologies – Basic Concepts
- Entity Framework – Overview
- Reading Data with EF
- Create, Update, Delete using Entity Framework
- Extending Entity Classes
- Executing Native SQL Queries
- Joining and Grouping Tables
- Attaching and Detaching Objects
Video: Introduction to the SQL Language (Bulgarian)
Video lecture with an introduction to the SQL language.
The video is recorded in 2014 in a training I was delivering in Burgas, Bulgaria.
Topics covered:
- SQL and T-SQL Languages
- Introducing the SELECT SQL Statement
- Allowed Operators
- The WHERE Clause
- Sorting with ORDER BY
- Selecting Data From Multiple Tables
- Selecting Data From Multiple Tables
- Natural Joins
- Join with USING Clause
- Inner Joins with ON Clause
- Left, Right and Full Outer Joins
- Cross Joins
- Inserting Data
- Updating Data
- Deleting Data
Video: Introduction to SQL Server (Bulgarian)
Video lecture with an introduction to SQL Server.
The video is recorded in 2014 in a training I was delivering in Burgas, Bulgaria.
Topics covered:
- SQL Server Services
- Types of Databases
- Authentication and Permissions
- SQL Server Management Studio
- Moving a SQL Server Database
- Through Backups and Restore
- By Detaching and Attaching
Video: Database Systems Summary (Bulgarian)
Video lecture with a brief summary of the database systems.
The video is recorded in 2014 in a training I was delivering in Burgas, Bulgaria.
Topics covered:
- Database Models
- Relational Database Model
- DBMS & RDBMS Systems
- Tables, Relationships, Multiplicity, E/R Diagrams
- Normalization
- Constraints
- Indices
- The SQL language
- Stored Procedures
- Views
- Triggers
- Transactions and Isolation Levels
- NoSQL Databases