The Complete ASP.Net Core MVC With Entity Framework Core
By the end of this course you will be in a position to implement the following : –
Entity Framework 6 Db First And Entity Framework Core 2.0 Code First :
-
Getting Started With Entity Framework Core 2.0
-
Migrations And Database Updates
-
Class Designing Techniques
-
Data Annotations And CRUD Operations
-
Select Operations
-
Immediate Mode Vs Differed Mode
-
List Vs IEnumerable Vs IQueryable
-
Eager Loading Vs Explicit Loading Vs Lazy Loading
-
Working with Raw SQL And Stored Procedures
-
Auto And Manual Transactions
-
3 Layered Approach With .Net Standard Library
ASP.Net MVC 5 And ASP.Net Core 2.0 MVC :
ASP.NET Core can target .NET Core or .NET Framework. ASP.NET Core apps targeting .NET Framework aren’t cross-platform—they run on Windows only. There are no plans to remove support for targeting .NET Framework in ASP.NET Core. Generally, ASP.NET Core is made up of .NET Standard libraries. Apps written with .NET Standard 2.0 run anywhere that .NET Standard 2.0 is supported.
-
Introduction To ASP.Net Application
-
Getting Started With First Static And ASP.Net Core MVC Web App
-
Get Vs Post And Passing Data From View To Controller
-
Razor View Engine And HTMLHelper Classes
-
ViewData Vs ViewBag And EF In MVC
-
Model Binding And TempData
-
Tag Helper And Form Validations
-
CRUD Operations And BootStrap
-
Dependency Injection And Layouts
-
Authentication In ASP.Net Core MVC Using Identity Server
-
Initial Setup And User Registration
-
LogIn And Logout
-
Email Confirmation And Forgot Password
-
-
Authorization In ASP.Net Core MVC Using Identity Server
-
Initial Setup
-
Assign Roles Dynamically
-
-
AjaxLinks And AjaxForms (Links And Partial Views)
-
AjaxLinks And Forms(AjaxForms)
-
Introduction To JQuery
-
JQuery Based Ajax Calls – Read Operations
-
JQuery Based Ajax Calls – Create-Update-Delete Operations
Note : As these videos are from a live recorded session you need to manage a little audio disturbances. Yes not much 🙂Â
The Complete Entity Framework Core 2.0 Code First Approach
The Complete ASP.Net Core 2.0 MVC
Introduction To Entity Framework and EDM [EF4 - EF5]
Querying the EDM - Basic
Working With Stored Procedures
Querying the EDM - Advance
Source Code For Entity Framework
Advanced Entity Framework - DbContext [EF6]
<#@ template debug="false" hostspecific="false" language="C#" #>
<#@ assembly name="System.Core" #>
<#@ import namespace="System.Linq" #>
<#@ import namespace="System.Text" #>
<#@ import namespace="System.Collections.Generic" #>
<#@ output extension=".cs" #>
public class MyClass
{
<# for(int i=1;i<=10;i++)
{#>
public int P<#= i#> { get; set; }
<# }#>
}
<# string[] s={"Sid","SName","Age"}; #>
class Student
{
<# foreach(var item in s)
{#>
public string <#= item#> {get;set;}
<# }#>
}
<# string[] s2= System.IO.File.ReadAllLines(@"F:MyData.txt"); #>
class NewStudent
{
<# foreach(var item in s2)
{#>
public string <#= item#> {get;set;}
<# }#>
}
// input(.txt) => .tt => .cs
// input(.edmx) => .tt => .cs
Introduction: Basically you can write LINQ queries using method syntax (some time called as Lambda Expressions) and query syntax. So, here I have tried to gather 36 T-Sql queries along with their equivalent LINQ queries in both method and query syntax.
Scenario: Let us consider a scenario where we have two tables in Sql Server database MyOrg i.e., tbl_Dept and tbl_Emp and say we have generated an entity data model with these two tables as MyOrg.edmx as shown below and we have created dev as an object of MyOrgEntities context object i.e.,
Advanced Operations
Performance Optimization
Data Access Dll
Introduction to Asp.Net MVC
Working With Data In Asp.Net
First Look At Razor View Engine
State Management In Asp.Net MVC & Layouts
Introduction To Models
