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

 | Details:

Duration: About 6:30 Hours

Publish Date: 20/07/2020

Featured Reviews:
Samuel MBONGA:
Excellent course. thaugth this is for beginner. it has helped so much and had put me on the rail.
Mohammad Javed:
Great Course.

Entity Framework in c# & Sql

| Tutorial Contents of this course :

Easily use Entity Framework ,EF to create the database Apps with C# in SQL Database in EF, Entity Framework , Entity


| Tutorial Overview:

Hi There!

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


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


| Table of Contents:

 Show AllDurationDownload

Section 1 . Introduction

 Introduction to this course04:33
 About Me01:57
 How to increase sound volume of tutorials?02:01

Section 2 . What is Entity Framework?

 What is the Entity Framework and ADO.Net?04:20
 Entity Framework Vs ADO.Net?05:40
 Steps to Start Using the Entity Framework02:16

Section 3 . Quick Review of SQL Server

 Who should watch this section!01:20
 Download SQL Server 2014 express & requirements08:07
 Install SQL 2014 express in Windows 711:47
 Install SQL 2014 express in Windows 1010:17
 What is SQL Server & its structure?03:10
 Common parts of SQL Server02:13
 What is SQL Server Management Studio (SSMS) ?07:22
 Customize SQL Server Environment05:53
 What is SQL Server database?03:45
 Create SQL Database03:29
 Different parts of the SQL database03:33
 Rename and delete SQL Database03:17
 Default location of the SQL Database files03:09
 Different type of SQL database files05:05
 Using SQL Server configuration manager06:24
 What is SQL table?03:03
 Add table to the SQL Database12:31
 Add data to the SQL table05:24
 Load data in to the SQL table05:00
 Change the design of table & save it04:17
 Rename and delete the SQL table02: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 file04:31
 Make SQL database offline and online03:27

Section 4 . Create C# Project and Install Entity Framework

 Create C# project for Entity Framework06:57
 Nuget and It's usage to install the Entity Framework!01:20
 Start using the Nuget03:21
 Searching the packages in Nuget05:14
 Install the Nuget in Visual Studio03:18
 Install Entity framework by Nuget Package Manager04:00
 Install Entity framework by Nuget Console04:13

Section 5 . Design SQL Database for Entity Framework

 Project types of Entity framework06:20
 Create Employee Database in the SQL03:38
 Add "Employee Info" table to SQL Db09:22
 Add sample SQL data in Employee table04:32

Section 6 . Start Using Entity Framework in C#

 Structure of Entity Framework07:59
 Start EF in C# App by Connecting SQL Db to Project08:13
 Introduction to: DbContext,Model and Dbset09:27
 DbSet in-depth04:53

Section 7 . Using DataGrid View with EF

 Add the Datasource to C# Project05:31
 How to Backup & Restore C# Project?05:00
 Automatically Add DataGridView and bind it to DbSet04:56
 Manually Add DataGridView and bind it to DbSet08:25

Section 8 . Load and Save Data with EF in C#

 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 changes06:35
 Show last inserted new ID in DGV )DataGridView)03:13

Section 9 . Using Data Entry Controls with EF

 Automatically Add Data Entry Controls and bind it to DbSet08:17
 Manually Add Data Entry TextBox to form and bind it to DbSet05:10
 Binding (DateTimePicker, ComboBox , Checkbox) to DbSet05:03
 Save Data in SQL with C# and data entry controls on form04:09

Section 10 . Using Binding Navigator in EF

 Working with BindingNavigator08:43
 Design Custom BindingNavigator06:28
 Write C# code for custom BindingNavigator to navigate12:37

Section 11 . Design Data Entry Form in C#

 Add and design the data entry ToolStrip at the top of form06:38
 C# code to enable or disable (Add, Edit, Delete, Save, Cancel) buttons08:36
 Write "Add New " button code in C#04:28
 Write "Edit " button code in C#08:11
 Write "Delete" button code in C#09:46
 Write "Save Changes" button code in C#07:08
 Write "Cancel" button code in C#06:04
 Write the code to reload the data05:24

Csking1981.com, 2003-2020