Programming
HOW TO: ZIP Multiple CSV Files In ASP.NET Paid 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.
Don't Let Entity Framework Fool Your Constructors! Paid Members Public
Any state that an object can be in must be representable through the class constructor.
Back To Basics: Constructors and Enforcing Invariants Paid 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
Rename SQL Table and Update Naming Conventions for Associated Keys and Constraints Paid 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_
Remote Debugging: Azure Virtual Machines With Visual Studio Paid 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
Bulk Import CSV Files Into SQL Server Using SQLBulkCopy and CSVHelper Paid 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
Handling Too Many Request Error with Auth0 Using Polly Paid 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
How To Take iOS App Store Screenshots Using Google Chrome For Cordova Applications Paid Members Public
Using Chrome Browser to take screenshots in all resolutions as required by the App Stores.