Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Development Tools No-Code Development
Business
Entrepreneurship Communications Management Sales Business Strategy Operations Project Management Business Law Business Analytics & Intelligence Human Resources Industry E-Commerce Media Real Estate Other Business
Finance & Accounting
Accounting & Bookkeeping Compliance Cryptocurrency & Blockchain Economics Finance Finance Cert & Exam Prep Financial Modeling & Analysis Investing & Trading Money Management Tools Taxes Other Finance & Accounting
IT & Software
IT Certification Network & Security Hardware Operating Systems Other IT & Software
Office Productivity
Microsoft Apple Google SAP Oracle Other Office Productivity
Personal Development
Personal Transformation Personal Productivity Leadership Career Development Parenting & Relationships Happiness Esoteric Practices Religion & Spirituality Personal Brand Building Creativity Influence Self Esteem & Confidence Stress Management Memory & Study Skills Motivation Other Personal Development
Design
Web Design Graphic Design & Illustration Design Tools User Experience Design Game Design Design Thinking 3D & Animation Fashion Design Architectural Design Interior Design Other Design
Marketing
Digital Marketing Search Engine Optimization Social Media Marketing Branding Marketing Fundamentals Marketing Analytics & Automation Public Relations Advertising Video & Mobile Marketing Content Marketing Growth Hacking Affiliate Marketing Product Marketing Other Marketing
Lifestyle
Arts & Crafts Beauty & Makeup Esoteric Practices Food & Beverage Gaming Home Improvement Pet Care & Training Travel Other Lifestyle
Photography & Video
Digital Photography Photography Portrait Photography Photography Tools Commercial Photography Video Design Other Photography & Video
Health & Fitness
Fitness General Health Sports Nutrition Yoga Mental Health Dieting Self Defense Safety & First Aid Dance Meditation Other Health & Fitness
Music
Instruments Music Production Music Fundamentals Vocal Music Techniques Music Software Other Music
Teaching & Academics
Engineering Humanities Math Science Online Education Social Science Language Teacher Training Test Prep Other Teaching & Academics
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Cisco CCNA Amazon AWS CompTIA Security+ AWS Certified Developer - Associate
Graphic Design Photoshop Adobe Illustrator Drawing Digital Painting InDesign Character Design Canva Figure Drawing
Life Coach Training Neuro-Linguistic Programming Mindfulness Personal Development Personal Transformation Meditation Life Purpose Emotional Intelligence Neuroscience
Web Development JavaScript React CSS Angular PHP WordPress Node.Js Python
Google Flutter Android Development iOS Development Swift React Native Dart Programming Language Mobile Development Kotlin SwiftUI
Digital Marketing Google Ads (Adwords) Social Media Marketing Google Ads (AdWords) Certification Marketing Strategy Internet Marketing YouTube Marketing Email Marketing Retargeting
Microsoft Power BI SQL Tableau Business Analysis Business Intelligence MySQL Data Modeling Data Analysis Big Data
Business Fundamentals Entrepreneurship Fundamentals Business Strategy Online Business Business Plan Startup Freelancing Blogging Home Business
Unity Game Development Fundamentals Unreal Engine C# 3D Game Development C++ 2D Game Development Unreal Engine Blueprints Blender
2021-01-12 13:13:22
30-Day Money-Back Guarantee
Development Development Tools Entity Framework

Entity Framework: Getting Started - Complete Beginners Guide

Learn how to connect your .NET C# Applications to SQL Server Database Using Entity Framework
Rating: 3.6 out of 53.6 (30 ratings)
128 students
Created by Artemakis Artemiou
Last updated 2/2021
English
English [Auto]
30-Day Money-Back Guarantee

What you'll learn

  • What are the 3 Entity Framework workflows "Code First", "Model First" and "Database First" and how to use them
  • How to build .NET applications and connect to SQL Server using Entity Framework
  • What Entity Framework and Entity Framework Core are and how they work
  • The pros and cons of the 3 workflows and when it is best to use each one of them
  • How to build a C# Console App with Entity Framework Code First in Visual Studio
  • How to build a C# Windows Forms (GUI) App with Entity Framework Code First in Visual Studio
  • How to handle data model/database changes in Code First
  • How to build a C# Console App with Entity Framework Model First in Visual Studio
  • How to build a C# Windows Forms (GUI) App with Entity Framework Model First in Visual Studio
  • How to handle data model/database changes in Model First
  • How to build a C# Console App with Entity Framework Database First in Visual Studio
  • How to build a C# Windows Forms (GUI) App with Entity Framework Database First in Visual Studio
  • Handle data model/database changes in Database First
  • How to use Language-Integrated Query (LINQ-to-Entities) in C# to query data model entities
  • How to get started with Entity Framework Core on Linux

Course content

10 sections • 51 lectures • 5h 0m total length

  • Preview03:31

  • Preview03:11
  • How Does Entity Framework Work?
    02:59
  • What we’ve Learned in this Section
    01:01
  • Introduction to Entity Framework
    5 questions

  • DbContext and DbSet
    01:53
  • Preview01:59
  • Preview03:44
  • Model First
    01:59
  • Database First
    01:20
  • What we’ve Learned in this Section
    01:12
  • Entity Framework Concepts and Workflows
    5 questions

  • Before Building the Apps: Let's Create a Sample Database
    02:27
  • Build a .NET Console App Using Entity Framework Code First (New DB)
    21:02
  • Build a .NET Console App Using Entity Framework Code First (Existing DB)
    11:50
  • Build a .NET Windows Forms App Using Entity Framework Code First (New DB)
    13:38
  • Build a .NET Windows Forms App Using Entity Framework Code First (Existing DB)
    08:52
  • What we’ve learned in the Code First Demos
    00:53
  • Build a .NET Console App Using Entity Framework with Model First
    17:26
  • Build a .NET GUI App Using Entity Framework with Model First
    11:38
  • What we’ve learned in the Model First Demos
    00:50
  • Build a .NET Console App Using Entity Framework with Database First
    10:44
  • Preview09:43
  • What we’ve learned in the Database First Demos
    00:27

  • About this Section
    00:22
  • More About Entity Framework Core
    07:54
  • Creating and Configuring a Model in Entity Framework Core Using Fluent API
    10:51

  • About this Section
    01:49
  • Supported Linux Distributions by SQL Server 2017 or later
    00:56
  • How to Install SQL Server 2019 on Ubuntu Linux (Demo)
    07:34
  • Preview01:06
  • How to Install the SQL Server command-line tools on Ubuntu Linux (Demo)
    04:53
  • Introducing Azure Data Studio: A Cross-Platform SQL Server Client Tool
    02:00
  • How to Access SQL Server 2019 on Ubuntu Linux Using Azure Data Studio
    09:00
  • Installing .NET Core
    05:44
  • Entity Framework Database Providers
    04:27
  • Creating an Entity Framework Core Project on Linux (Code-First - New DB)
    12:14

  • Preview00:42
  • How to Install and Start Using Entity Framework 6.3 with .NET Core 3.0
    13:45

  • Preview00:24
  • Create Sample Database for Special Topics Demos
    03:38
  • Example of Inheritance in Entity Framework
    03:32
  • How to Install SQL Server
    11:54
  • Connecting to SQL Server via SSMS
    01:53
  • Creating a Database and Other Objects in SQL Server
    09:04
  • Running Queries in SQL Server and Scripting Procedures to T-SQL
    07:10
  • Preview03:57
  • How to Perform an Offline Installation of SQL Server 2019 on Linux
    11:47
  • How to Import Data in SQL Server Using the OPENROWSET Function
    04:03
  • How to Import & Export Data Using SQL Server Integration Services (SSIS)
    11:38
  • How to Install SQL Server on CentOS Linux
    11:10

  • What we’ve Learned in this Course
    01:16
  • Entity Framework: Getting Started
    15 questions

  • Bonus Lecture
    03:24

Requirements

  • Basic Programming Principles
  • Basic C# Programming Language Knowledge
  • Basic Visual Studio Knowledge

Description

In this course, you will learn all about Entity Framework and Entity Framework Core on both Windows and Linux, what it is, how it works, what are its available workflows and their pros and cons. To this end, you will learn how to connect your C# Applications to SQL Server Database with Entity Framework and its workflows.


WHAT OTHER STUDENTS SAY ABOUT THE COURSE:

  • The course, and especially the live demos, help me start using Entity Framework easily.

  • I really enjoy this course. The instructor explains everything in simple words and the demos show step by step, how to start working with Entity Framework.

  • Cours très pertinent et complet. Touche aux différentes facettes d'approches de conception.

  • Thank you sir. This course helped me to better understand Framework!

  • Great learning experience, addressing the areas I expected to cover.


MORE ABOUT THE COURSE:

Entity Framework is an Object-Relational Mapper (ORM) development tool, that enables the Software Developer to write less data code faster, and focus more on the software logic instead of the underlying database.

Via this course and its large set of live demonstrations/guides, you will learn step-by-step, how you can efficiently build data applications using Visual Studio with C# and the different workflows of Entity Framework such as: Code First, Model First and Database First. Moreover, you will learn how to easily get started with Entity Framework Core on Linux.


AFTER THE COURSE:

  • You will know what Entity Framework and Entity Framework Core are and how they work

  • You will be able to create .NET Console and Windows Forms GUI data apps, using any of the available Entity Framework workflows:

    • Code First with Existing Database

    • Code First with New Database

    • Model First

    • Database First

  • You will be able to design .NET data applications much faster and you will be more productive.

  • You will be able to easily use Entity Framework when developing .NET data apps

  • You will be able to start working with Entity Framework Core on both Windows and Linux


PREREQUISITES:

  • Basic Programming Principles

  • Basic C# Programming Language Knowledge

  • Good to know: Microsoft® Visual Studio®

  • In this course, we will be working with .NET Framework (C#) on Windows® and Entity Framework 6 via Microsoft® Visual Studio® 2017

  • Also, we will be working with Entity Framework Core 2.2 SDK on Ubuntu® Linux.


THIS COURSE CONTAINS/OFFERS:

  • 5 hours of high-quality video lectures

  • Step by step live demonstrations and guides that can help you get started with Entity Framework and Entity Framework Core in no time

  • Downloadable resources with useful information and links

  • Downloadable infographics that will help you better understand the main concepts of Entity Framework

  • Useful practice tests/quizzes for testing your knowledge on each section

  • A major practice test in the end of the course

  • Ability to ask the instructor questions via the Q&A section

  • Certificate on course completion


Also: This course is being updated with new educational material on a regular basis.

Who this course is for:

  • People that develop data applications in .NET and want to be more productive
  • People that want to start using the Entity Framework for building robust .NET data applications
  • .NET Software Developers that want to just focus on building the software, and not the database
  • Technology enthusiasts that want to learn more about software development and .NET

Instructor

Artemakis Artemiou
Award-Winning Database Expert, Trainer, Author, Speaker.
Artemakis Artemiou
  • 4.3 Instructor Rating
  • 455 Reviews
  • 4,366 Students
  • 13 Courses

Artemakis is a Senior SQL Server and Software Architect and a former Microsoft Data Platform MVP (awarded for 9 consecutive years). He has over 20 years of experience and he has taught thousands of people to efficiently work with SQL Server, Data Access/Entity Framework, Azure, .NET/C#, Programming and more, via his video tutorials, blog and guest articles, public speaking, eBooks and online courses.

Artemakis published hundreds of articles and videos that explain in simple words, how to perform complex technical tasks and he really enjoys the interaction with the technical communities.

Besides his regular blogging activities, Artemakis is also a guest author on many prestigious online technology journals.

Moreover, he currently serves as the President of the Cyprus .NET User Group (CDNUG) and the International .NET Association Country Leader for Cyprus (INETA).

Artemakis, really enjoys sharing hands-on knowledge on a large set of technology topics, and thus helping his fellow tech community members, to easily start using these great technologies. To this end, he is really looking forward to seeing you in his online courses on Udemy!

  • Udemy for Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Terms
  • Privacy policy
  • Cookie settings
  • Sitemap
  • Featured courses
Udemy
© 2021 Udemy, Inc.