A lot of times we come across a requirement to bulk insert data in SQL server. Now there are several ways to bulk insert data in SQL server table but in this example I’ll use SqlBulkCopy. Why use SqlBulkCopy SqlBulkCopy is super fast as compared… Read More »Bulk insert records in the database (C# & SQL server)
When we are working with the Episerver website there are few page types that we want Content editors to create only one instance of the page. Such as the “Search result page”. We only want one search result page on the whole website. Few similar… Read More »Allow Single Instance of the page type in Episerver CMS
Recently I come across a requirement to create .NET Core Web API using JWT (JSON Web Token) authentication. I have used ASP.NET identity to provide a role-based authentication model. I have used .NET core 3.x to create this example. For the sake of simplicity, I… Read More ».NET Core Web API Jwt (JSON Web Token) Authentication with ASP.NET identity model
Last week I come across a requirement to get Episerver commerce list of customers based on filtered criteria such a get customers based on the validity of a certain field. As we all know Episerver store customer data in Business Foundation class called “Contact”. In… Read More »Get filtered results from Episerver Business Foundation class
A lot of times we come across an issue when we forgot Episerver administrator password in our local environment or if we have restored the database from other environments and we might don’t know its administrator user name and password. The following steps show you… Read More »Change Episerver Admin Account Password
Recently I come across the requirement to do personalization based on UK postcodes. The format of UK postal codes is very well structured. It consists of two alphanumeric codes called “Outward code” and “Inward code”. Outward code consists of 2 to four-letter defining area and… Read More »Episerver Personalisation Criteria based on UK postcodes
Lot of times we come across the requirement to apply personalization based on visitor’s GeoCoordinates (latitude & longitude) & if visitor location is within specified distance to a ‘centre point location’. For example, showing personalized content for visitors accessing website from certain part of city/town… Read More »Episerver Personalization Criteria based on GeoCoordinates & radius
we often need to use existing database and blobs to create new environment. For example, new Dev or staging environment using blobs and database from integration environment If for some reason blobs are not copied properly then we will have new environment with missing images… Read More »EpiServer: Investigating missing blobs using Sql queries
This article explains how to add images to Azure blob storage container using C# .NET Core. The Complete code can be downloaded from following GitHub repository Nuget Url: https://www.nuget.org/ packages /ailogica.Azure.Helpers/ Source Code: https://github.com/ nulhaq /Azure-Helpers Before starting please make sure you have already created azure… Read More »Add images to Azure blob storage in .NET Core
While working with Episerver commerce a lot of times we come across a challenge to copy production website data down to integration and pre-production environment. Since integration is normally a Dev environment and pre-production a test environment we do not want customer’s information to be… Read More »A handy script to anonymize Epicommerce data