Programming

HOW TO: ZIP Multiple CSV Files In ASP.NET Members Public

Learn how to generate a ZIP file containing many CSV files in an ASP.Net Web API application. The same approach is useful to zip files of any type in any .NET application using CSharp.

Rahul Pulikkot Nath
Rahul Pulikkot Nath
Programming

Don't Let Entity Framework Fool Your Constructors! Members Public

Any state that an object can be in must be representable through the class constructor.

Rahul Pulikkot Nath
Rahul Pulikkot Nath
Programming

Back To Basics: Constructors and Enforcing Invariants Members Public

In C# or any class-based object-oriented language, a Constructor is used to create an object. The constructor is responsible for initializing the object's data members and establishing the class invariants. A constructor fails and throws an exception when the class invariants are not met. An invariant is an

Rahul Pulikkot Nath
Rahul Pulikkot Nath
Programming

Rename SQL Table and Update Naming Conventions for Associated Keys and Constraints Members Public

At work, we usually DbUp changes to SQL Server. We follow certain naming conventions when creating table constraints and Indexes. Here is an example create table Product ( Id uniqueidentifier not null unique, CategoryId uniqueidentifier not null, VendorId uniqueidentifier not null, constraint PK_Product primary key clustered (Id), constraint FK_Product_

Rahul Pulikkot Nath
Rahul Pulikkot Nath
Programming

Remote Debugging: Azure Virtual Machines With Visual Studio Members Public

It's not often that you want to debug into applications running on a Virtual Machine, but not to say that it is never required. Recently at one of my clients, I had to debug into an application running on an Azure Virtual machine. I wanted to debug an

Rahul Pulikkot Nath
Rahul Pulikkot Nath
Azure

Bulk Import CSV Files Into SQL Server Using SQLBulkCopy and CSVHelper Members Public

My recent project got me back into some long lost technologies, including Excel sheets, vb scripts, Silverlight, bash scripts, and whatnot. Amongst one of the things was a bash script that imported data from different CSV files to a data store. There were 40-50 different CSV schemas mapped to their

Rahul Pulikkot Nath
Rahul Pulikkot Nath
Programming

Handling Too Many Request Error with Auth0 Using Polly Members Public

When interacting with third-party services over the network, it is good to have a fault handling and resilience strategy in place.  Some libraries have built-in capabilities while for others you might have to roll your own. Below is a piece of code that I came across at one of my

Rahul Pulikkot Nath
Rahul Pulikkot Nath
Programming

How To Take iOS App Store Screenshots Using Google Chrome For Cordova Applications Members Public

Using Chrome Browser to take screenshots in all resolutions as required by the App Stores.

Rahul Pulikkot Nath
Rahul Pulikkot Nath
Programming