ITORIAN BLOG

Migrating database from ASP.NET Identity to ASP.NET Core Identity

2019-10-11T12:33:00.001-07:00

As you know ASP.NET Core Identity (table structure) is different from what we had earlier in ASP.NET Identity. Actually the identity system which we have today with .NET Core is very mature and continuously evolved be it ASP.NET Membership, ASP.NET Identity 1, ASP.NET Identity 2 and now ASP.NET Core Identity. Recently I had to migrate few application to ASP.NET Core and similar its identity

Lambda two tables and three tables inner join code samples

2019-10-11T11:19:00.000-07:00

In this blog post you will learn inner join using lambda queries. There will be two samples, in first sample you will see how you can join two tables and in second sample you will see how you can extend even further to join three tables and so on. I will sample in-memory data, but the same implementation will work with IQueryable (lazy query) too. Here's the code snippet:- namespace

How to move web.config connectionStrings in a separate web.config file ?

2019-03-29T05:31:00.001-07:00

In this post you will learn how to create a separate web.config file in ASP.NET or MVC to store development and production versions of connection strings. Step 1. Create a PrivateConn.config file on root with below code <connectionStrings> <add name="DataConn1" connectionString="Data Source=server;Initial Catalog=database1;Persist Security Info=True;User ID=sa;Password=xxxx

How to move web.config appSettings in a separate web.config file ?

2019-03-29T05:09:00.000-07:00

In this post you will learn how to create a separate web.config file in ASP.NET or MVC to store development and production versions of application settings. Step 1. Create a Private.config file on root with below code <appSettings> <add key="data1" value="value1"/> <add key="data2" value="value2"/> </appSettings> Step 2. Open main web.config file (on

Can test automation replace manual testing?

2019-03-13T03:51:00.000-07:00

Short and simple answer, NO. It cannot. Let's talk why, we cannot replace manual testing.Consider, a form screen showing a extra textbox or a wrong color in any control or a wrong modal, but the entire functionality works fine otherwise. Such things would easily be missed if you have a 100% automated test cases with 100% test coverage, because automated testing looks more at what is expected and

Reading NS records in C# using ARSoft packages

2019-03-04T04:50:00.000-08:00

In this post you will learn about reading NS records in C# using ARSoft packages. This package is handy to read domain NS records. Here's a sample code which will help: using System;using System.Linq;using ARSoft.Tools.Net;using ARSoft.Tools.Net.Dns;namespace ConsoleApp14{ class Program { static void Main(string[]

Customizing "Edit Top 200 Rows" in SQL Server Management Studio

2019-02-20T21:15:00.002-08:00

It is a very common requirement that, sometimes we want to change the edit top 200 rows query. This is very much possible and easy in SQL Server Management Studio. Right click on table and select "Edit Top 200 Rows" Press "Ctrl + 3" on rows in edit mode window Now you can see the query which returned 200 rows allowing you to edit On this query window, right click to execute the query on window

Create virtual machine using PowerShell command

2017-12-15T06:02:00.002-08:00

Just run this PowerShell script to create virtual machine, you can change setting in order to have other operating system and pricing. Hope this helps.

Free SSL Certificate for your website - from CloudFlare

2017-06-03T09:35:00.001-07:00

In this video post you will learn about free SSL certificate and its installation. This free SSL certificate is from CloudFlare but due to lack of installation guidelines and step by step we as a developer ignores this. Using CloudFlare SSL is a great advantage because you get other service for free too. Off-course, with paid plans you will get all the gems. Remember this never affects your SEO

Migrating Azure VMs on VNet from Azure Service Management (Classic or ASM) to Azure Resource Manager (Resource Manager or ARM)

2017-05-05T09:53:00.002-07:00

In this post you will find code snippet to migrate your classic Azure VMs that is part of virtual networks. That is, you will learn Migrating Azure VMs on VNet from Azure Service Management (Classic or ASM) to Azure Resource Manager (Resource Manager or ARM). Without too much discussion, let's start step by step. You need to have PowerShell installed. In the process of migration you first

Slug URL in MVC

2016-12-04T00:11:00.000-08:00

Creating a human friendly URL is one of the important goal in content management system. Recently one developer asked me this question. Like he always sees 'id' in URL in MVC application which is not human friendly. He mentioned stack-overflow example when explaining issue to me, so let’s discuss about this. Open stack-overflow page https://stackoverflow.com/questions/40956081 you will be

Azure Media Service Encoding with custom presets

2016-08-31T21:06:00.002-07:00

In this post you will learn how to use custom preset for Azure Media Service Encoding. But before that let's look at a case study or issue which I faced. When I uploaded a 55.5 MB mp4 file and encoded with "H264AdaptiveBitrateMP4Set720p" encoder preset, I received following output files: Look into green rectangular highlighted video files in the image, this looks good

Microsoft MVP: Honored to have received the Microsoft MVP award for the 5th year

2016-07-02T11:16:00.000-07:00

MVP Again J 1st July 6:30 PM IST has a very special meaning to me, this day starts with full of expectations and fast heartbeats which lasts until the moment of receiving email from Microsoft. Earlier we had a trick to know renewal status even before official confirmation, but this is that hole is closed ;) So, once again Microsoft awarded me with the MVP (Most Valuable Professional

Caching in MVC with Donut Caching - excluding caching login

2016-06-17T21:32:00.001-07:00

The main purpose of using caching is to dramatically improve the performance of your application. This is nothing but output caching that means whatever you see is cached, and exact similar things is display to everyone. I recommend you to read Output Caching in MVC post before you read here, because you should be very careful when using any caching mechanism. Or, if you already know output

Credential parameter can only be used with Organization ID credentials - Azure Deployment or Continuous Deployment Error

2016-04-26T04:49:00.000-07:00

I faced this error while Azure Web App Deployment starts in after Continuous Integration. Here's the detailed information you see in the error: -Credential parameter can only be used with Organization ID credentials. For more information, please refer to http://go.microsoft.com/fwlink/?linkid=331007&clcid=0x409 for more information about the difference between an organizational account and

Azure media services transcoding JobState.Error handling

2016-04-18T23:12:00.001-07:00

In case you are facing error in scheduled transcoding task like the one which I can see on my dashboard (image give below): You can use below code snippet to get more details about the error: Here is the output after using above code snippet: More details here: https://gist.github.com/itorian/4ac5fa723b3d5267258450a2c1a00294 Hope this helps.

Comparing two List to find match in both list, 1st list only, 2nd list only that is Insersect, Minus and Minus Except

2016-04-13T02:17:00.001-07:00

In this code snippet post you will learn how to compare two List<T> using lambda expressions. Below code is simple and self-explanatory if you read: Output:

Moving SQL Azure to local SQL or Azure SQL to VM SQL

2016-03-10T22:50:00.003-08:00

There are many requirements like moving database between: 1. SQL Azure to local development SQL Server 2. SQL Azure to Virtual Machine SQL Server 3. Development SQL Server to Production SQL Server 4. Production SQL Server to Development SQL Server In above all requirements a very generic option “Export Data-tier Application” and “Import Data-tier Application” will always work. So, in

Rename database data files and logical files in SQL Server

2016-03-10T21:42:00.000-08:00

When I rename database using SQL Server Management Studio I always change its data files (mdf, ldf) name as well as logical file name of the resource. And this is very common need for SQL Server guy. Here's the script which you can use to do this easily. Rename Files -- Note: must backup your database ALTER DATABASE databaseName SET OFFLINE GO -- databaseName => this is instance

Presenting session on "Building BOT on Telegram using C#" in C# Corner's Delhi Chapter

2016-01-30T22:15:00.000-08:00

I will be attending C# Corner Delhi Chapter on 7th Feb again. I have attended this event couple of times before. This time I will be presenting Building BOT on Telegram using C#. Why should you attend my session? When I want to attend any session, I try to reason myself about why should I attend any particular session. Well, if you are wondering the same for me, here are my reasons

Self referencing loop detected for property 'xxxx' with type 'System.Data.Entity.DynamicProxies.XXX_XXX'. Newtonsoft.Json.JsonSerializationException

2015-12-18T02:43:00.001-08:00

This is a very common serialization exception we see when forget to use loop handling strategies in Web API. Look at the below screenshot which you have noticed: Now if you want to resolve this issue, you can use following code in web api configuration, here's how you can resolve this issue: var json = config.Formatters.JsonFormatter;

My session on Azure Media Services in C# Corner Delhi Chapter

2015-12-13T21:37:00.000-08:00

After I moved to Delhi, first time I got an opportunity to speak with developers in C# Corner Delhi Chapter meeting, Dinesh Beniwal is awesome guy managing community so well in Delhi. He invited me to be a part of Delhi Chapter and engage with developers and help community to grow by sharing and learning. In this event I delivered session on Azure Media Services which is my current domain

Sorting in WebAPI - a generic way to apply sorting

2015-12-02T03:30:00.001-08:00

In this post you will learn how to implement sorting functionality in WebAPI so that client can ask for sorted data by sending columns names through query string. Client can send more than one short parameters and request for ascending or descending data in response. Sorting functionality should be generic enough so that we can reuse it. Data source So, let's get started. First of all,

Field level data selection in WebAPI

2015-12-01T03:05:00.000-08:00

In this post you will learn how to implement field level data selection functionality in WebAPI so that client can ask for less data by sending individual columns names through query strings variable fields. Introduction Service should be smart enough to split command separated column names from query string and convert it into object that can be used with EF query. If client sent no

How to remove/update default header and footer from PayPal sandbox page

2015-11-30T03:53:00.000-08:00

I was updating an old website that uses PayPal as one of the payment gateway option. When I was testing the website I realized default header and footer texts. As I was working on older setup, so I was not sure if its default header footer or developer who developed intentionally used this on PayPal portal. In either situations, I stumbled in finding way/link to edit that on PayPal portal.

Upload video on YouTube in ASP.NET or MVC

2015-11-29T22:47:00.002-08:00