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.,