Entity Framework for Beginners in C# to Design Db App in SQL
4.2 (8 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
9,539 students enrolled

Entity Framework for Beginners in C# to Design Db App in SQL

Easily use Entity Framework ,EF to create the database Apps with C# in SQL Database in EF, Entity Framework , Entity
New
4.2 (8 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
9,539 students enrolled
Created by Musavi Abdullah
Last updated 7/2020
English
English [Auto]
Current price: $13.99 Original price: $19.99 Discount: 30% off
23 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 6.5 hours on-demand video
  • 2 articles
  • 1 downloadable resource
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • Using Entity Framework in C# : Download & Install EF
  • Working with Database First method
  • Create Database App in C# & SQL by EF
  • Load data and save changes to SQL by C#
  • Load,Save,Delete & Add New By Entity Framework in C# & SQL
  • Using DbContext,Model,DbSet and BindingSource
Course content
Expand all 72 lectures 06:32:07
+ Introduction
4 lectures 09:24
How to increase sound volume of tutorials?
02:01
Download projects and files of this course
00:53
+ Quick Review of SQL Server
26 lectures 02:10:34
Who should watch this section!
01:20
Download SQL Server 2014 express & requirements
08:07
Install SQL 2014 express in Windows 7
11:47
Install SQL 2014 express in Windows 10
10:17
What is SQL Server & its structure?
03:10
Common parts of SQL Server
02:13
What is SQL Server Management Studio (SSMS) ?
07:22
Customize SQL Server Environment
05:53
What is SQL Server database?
03:45
Create SQL Database
03:29
Different parts of the SQL database
03:33
Rename and delete SQL Database
03:17
Default location of the SQL Database files
03:09
Different type of SQL database files
05:05
Using SQL Server configuration manager
06:24
What is SQL table?
03:03
Add table to the SQL Database
12:31
Add data to the SQL table
05:24
Load data in to the SQL table
05:00
Change the design of table & save it
04:17
Rename and delete the SQL table
02:17
What is the prefix "dbo" in SQL table name?
02:50
How to detach SQL database?
04:53
How to attach SQL database?
03:30
Attach SQL database without LDF file
04:31
Make SQL database offline and online
03:27
+ Create C# Project and Install Entity Framework
7 lectures 28:23
Create C# project for Entity Framework
06:57
Nuget and It's usage to install the Entity Framework!
01:20
Install Entity framework by Nuget Console
04:13
+ Design SQL Database for Entity Framework
4 lectures 23:52
Create Employee Database in the SQL
03:38
Add "Employee Info" table to SQL Db
09:22
Add sample SQL data in Employee table
04:32
+ Start Using Entity Framework in C#
4 lectures 30:32
Start EF in C# App by Connecting SQL Db to Project
08:13
Introduction to: DbContext,Model and Dbset
09:27
DbSet in-depth
04:53
+ Using DataGrid View with EF
4 lectures 23:52
Add the Datasource to C# Project
05:31
How to Backup & Restore C# Project?
05:00
Automatically Add DataGridView and bind it to DbSet
04:56
Manually Add DataGridView and bind it to DbSet
08:25
+ Load and Save Data with EF in C#
4 lectures 26:02
Load the data into DGV by DbContext & ToBindingList()
10:08
Save changes in DGV back to SQL Db like (New,Edit,Delete)
06:06
Show a MessageBox to user after saving changes
06:35
Show last inserted new ID in DGV )DataGridView)
03:13
+ Using Data Entry Controls with EF
4 lectures 22:39
Automatically Add Data Entry Controls and bind it to DbSet
08:17
Manually Add Data Entry TextBox to form and bind it to DbSet
05:10
Binding (DateTimePicker, ComboBox , Checkbox) to DbSet
05:03
Save Data in SQL with C# and data entry controls on form
04:09
+ Using Binding Navigator in EF
3 lectures 27:48
Working with BindingNavigator
08:43
Design Custom BindingNavigator
06:28
Write C# code for custom BindingNavigator to navigate
12:37
Requirements
  • General knowledge of C# and SQL Server
Description

Hi There!

With my 20 years programming skills i'm with you to share my knowledge with you.

So

If you try you will learn using Entity Framework in C# to create database Apps in C#!

If you are beginners or student looking for a tutorial to create database apps in SQL  and Entity Framework in  in C# in simplest way!


I started from beginning and show you how to :

  • Main parts of entity framework

  • Download and install entity framework in C# project

  • Build database Apps in C# by entity framework

  • Design Pro Data Entry Forms

  • Create Customer info Project in C#

  • Load,Save,Delete & New By Entity Framework by C# in SQL

  • and ...

Don't hesitate to start learning Entity Framework in C# and SQL!

Every thing will be discussed with sample project and you will have lot of fun within my course.

Say Hi EF with SQL & C# world and let's go !!!

Who this course is for:
  • Everyone that wants to create database App with Entity Framework in C# and SQL