Abhimanyu Kumar Vatsa itorian

## asp-dot-net-identity-to-asp-dot-net-core-identity-migration-script.sql
-- STEP 1 : Change name of existing tables

EXEC sp_rename 'AspNetRoles', 'AspNetRoles_old';
EXEC sp_rename 'AspNetUserClaims', 'AspNetUserClaims_old';
EXEC sp_rename 'AspNetUserLogins', 'AspNetUserLogins_old';
EXEC sp_rename 'AspNetUserRoles', 'AspNetUserRoles_old';
EXEC sp_rename 'AspNetUsers', 'AspNetUsers_old';


## DevOps-Pipeline-For-Linux-Build
# ------------------------------------------------------------------------------
# 1. To build all .net core projects in a solution use below pipeline code
# ------------------------------------------------------------------------------

trigger:
- master

pool:
  vmImage: 'ubuntu-latest'

## PayPalRESTAPI.cs
using System;
using System.Text;
using System.Net.Http;
using Newtonsoft.Json;
using System.Collections.Generic;
using System.Web.Script.Serialization;

namespace ConsoleApp14
{
    class Program

## create-azure-vm-in-selected-subscription-powershell.ps1
# Login
Login-AzureRmAccount

# Set subscription to create resources in
Set-AzureRmContext -SubscriptionId "xxxxxxxxx"

# Variables for common values
$location = "westeurope"
$resourceGroup = "demo-resgroup-0"
$vmName = "demovm-0"

## create-azure-vm-powershell.ps1
# Login
Login-AzureRmAccount

# Variables for common values
$location = "westeurope"
$resourceGroup = "demo-resgroup-0"
$vmName = "demovm-0"
$publicIP = "spublicip-1"
$subnet = "subnet-1"
$vnet = "vnet-1"

## H264MultipleBitrateCustom720p.json
{
  "Version": 1.0,
  "Codecs": [
    {
      "KeyFrameInterval": "00:00:02",
      "H264Layers": [
        {
          "Profile": "Auto",
          "Level": "auto",
          "Bitrate": 1000,

## Azure media services transcoding JobState.Error handling
static public IAsset EncodeToAdaptiveBitrateMP4s(IAsset asset, AssetCreationOptions options)
{
    // Default preset settings
    //IJob job = _context.Jobs.CreateWithSingleTask(MediaProcessorNames.AzureMediaEncoder,
    //        MediaEncoderTaskPresetStrings.H264AdaptiveBitrateMP4Set720p,
    //        asset,
    //        "Test-Video-" + 100 + "-" + Guid.NewGuid().ToString() + "-Adaptive-Bitrate-MP4",
    //        AssetCreationOptions.None);

    // Custom preset settings

## Comparing two List<T> to find match in both list, 1st list only, 2nd list only that is Insersect, Minus and Minus Except
namespace ConsoleApplication6
{
    class Program
    {
        static void Main(string[] args)
        {
            List<Items> list1 = new List<Items>();
            list1.Add(new Items { name = "abc" });
            list1.Add(new Items { name = "abd" });
            list1.Add(new Items { name = "aef" });

## Exception Filter in MVC
## 1. Install log4net using NuGet

## 2. Add assembly in AssemblyInfo.cs file
[assembly: log4net.Config.XmlConfigurator(ConfigFile = "Web.config", Watch = true)]

## 3. Add settings in web.config
<configuration>
  <configSections>
    :::
    <section name="log4net" type="log4net.Config.Log4NetConfigurationSectionHandler,log4net" />

## EntityFramework vs LINQ vs ADO.NET - select query samples
    // Entity Framework
    public ActionResult GetBokaroStudentEF()
    {
        var db = GetFromDbContext();
        var data = db.Students.Where(i => i.City == "Bokaro");
        return View(data);
    }

    // LINQ
    public ActionResult GetBokaroStudentLINQ()
	-- STEP 1 : Change name of existing tables

	EXEC sp_rename 'AspNetRoles', 'AspNetRoles_old';
	EXEC sp_rename 'AspNetUserClaims', 'AspNetUserClaims_old';
	EXEC sp_rename 'AspNetUserLogins', 'AspNetUserLogins_old';
	EXEC sp_rename 'AspNetUserRoles', 'AspNetUserRoles_old';
	EXEC sp_rename 'AspNetUsers', 'AspNetUsers_old';
	# ------------------------------------------------------------------------------
	# 1. To build all .net core projects in a solution use below pipeline code
	# ------------------------------------------------------------------------------

	trigger:
	- master

	pool:
	vmImage: 'ubuntu-latest'
	using System;
	using System.Text;
	using System.Net.Http;
	using Newtonsoft.Json;
	using System.Collections.Generic;
	using System.Web.Script.Serialization;

	namespace ConsoleApp14
	{
	class Program
	# Login
	Login-AzureRmAccount

	# Set subscription to create resources in
	Set-AzureRmContext -SubscriptionId "xxxxxxxxx"

	# Variables for common values
	$location = "westeurope"
	$resourceGroup = "demo-resgroup-0"
	$vmName = "demovm-0"
	{
	"Version": 1.0,
	"Codecs": [
	{
	"KeyFrameInterval": "00:00:02",
	"H264Layers": [
	{
	"Profile": "Auto",
	"Level": "auto",
	"Bitrate": 1000,
	static public IAsset EncodeToAdaptiveBitrateMP4s(IAsset asset, AssetCreationOptions options)
	{
	// Default preset settings
	//IJob job = _context.Jobs.CreateWithSingleTask(MediaProcessorNames.AzureMediaEncoder,
	// MediaEncoderTaskPresetStrings.H264AdaptiveBitrateMP4Set720p,
	// asset,
	// "Test-Video-" + 100 + "-" + Guid.NewGuid().ToString() + "-Adaptive-Bitrate-MP4",
	// AssetCreationOptions.None);

	// Custom preset settings
	namespace ConsoleApplication6
	{
	class Program
	{
	static void Main(string[] args)
	{
	List<Items> list1 = new List<Items>();
	list1.Add(new Items { name = "abc" });
	list1.Add(new Items { name = "abd" });
	list1.Add(new Items { name = "aef" });
	## 1. Install log4net using NuGet

	## 2. Add assembly in AssemblyInfo.cs file
	[assembly: log4net.Config.XmlConfigurator(ConfigFile = "Web.config", Watch = true)]

	## 3. Add settings in web.config
	<configuration>
	<configSections>
	:::
	<section name="log4net" type="log4net.Config.Log4NetConfigurationSectionHandler,log4net" />
	// Entity Framework
	public ActionResult GetBokaroStudentEF()
	{
	var db = GetFromDbContext();
	var data = db.Students.Where(i => i.City == "Bokaro");
	return View(data);
	}

	// LINQ
	public ActionResult GetBokaroStudentLINQ()