A Blog About Random Computer Subjects
Frank DeCaire Why is there No Documentation? I’m surprised at the number of developers who don’t create any documentation. There are ways to self-document code and there are packages to add automatic help to an API to document the services. Unfortunately, that’s not enough. I’ve heard all the arguments: It chews up programming time. It rapidly becomes … Read moreDocumentation
Introduction In this post, I’m going to talk about basic dependency injection and mocking a method that is used to access hardware. The method I’ll be mocking is the System.IO.Directory.Exists(). Mocking Methods One of the biggest headaches with unit testing is that you have to make sure you mock any objects that your method under … Read moreMocking Your File System
The Basics The IBM 701 computer was one of IBM’s first commercially available computers. Here are a few facts about the 701: The 701 was introduced in 1953. IBM sold only 30 units. It used approximately 4,000 tubes. Memory was stored on 72 CRT tubes called Williams Tubes with a total capacity of 2,048 words. … Read moreVintage Hardware – The IBM 701
There is this debate raging among developers: “Is it better to use stored procedures or not use stored procedures”. From first glance, this seems like a simple question, but there are some complicated implications around this question. Here’s the basic pros and cons of using stored procedures in your system: Pros You can isolate table … Read moreStored Procedures Vs. No Stored Procedures
Summary This subject is much larger than the blog title suggests. I’m going to discuss some basics of using a caching system to take the load off of your database and speed up your website. I’ll also discuss how cache should be handled by your software and what the pitfalls of caching can be. Caching … Read moreCaching
Summary In this blog post I’m going to demonstrate a simple .Net MVC project that uses MS SQL server to access data. Then I’m going to show how to use Redis caching to cache your results to reduce the amount of traffic hitting your database. Finally, I’m going to show how to use the AutoFac … Read more.Net MVC Project with AutoFac, SQL and Redis Cache
The Contenders Dapper Dapper is a hybrid ORM. This is a great ORM for those who have a lot of ADO legacy code to convert. Dapper uses SQL queries and parameters can be used just like ADO, but the parameters to a query can be simplified into POCOs. Select queries in Dapper can also be … Read moreDotNet Core vs. NHibernate vs. Dapper Smackdown!
In this post I’m going to describe the cleanest way to setup your Entity Framework code in .Net Core. For this example, I’m going to create the database first, then I’ll run a POCO generator to generate the Plain Old C# Objects and their mappings. Finally, I’ll put it together in a clean format. The … Read moreEntityFramework .Net Core Basics
One of the most frustrating changes made in .Net Core is the NuGet package manager. I like the way the new package manager works, unfortunately, there are still a lot of bugs in the way the package manager works. I call it the tyranny of intelligent software. The software is supposed to do all the … Read moreDot Net Core and NuGet Packages
Attempting to use the correct NuGet packages for your code in .Net Core can be challenging. In this instance there is no project.json error and yet this one property is missing: This will happen when your EF database project contains at least these two NuGet packages: “dependencies”: { “Microsoft.EntityFrameworkCore”: “1.1.1”, “NETStandard.Library”: “1.6.1” … Read moreDBContextOptionsBuilder does not contain a definition for ‘UseSqlServer’