Skip to content

Category: C#

Enabling Cascade Delete in EF Core Code First DB Using the Fluent API

Entity Framework Core Default Behaviour on Delete Cascade delete saves a developer time by not needing to write boilerplate code for related data when the parent data in the relationship has been deleted. However in Entity Framework Core it is not the default behaviour. It takes a more conservative view and sets the on delete behaviour to restrict (StackOverflow Question where EF Core Team Member Confirms) which the documentation defines as: Restrict: The delete operation is not applied to dependent entities. The dependent entities remain unchanged. – EF Core Documentation Compared with the definition of cascade: Cascade: Dependent entities are also deleted. – EF Core Documentation Enabling Cascade Delete Using The Fluent…

Setting Up SQLite and Entity Framework Core in ASP.Net Core

For small applications such as prototypes and small side projects, SQLite is a great choice for a relational database. It is really easy to setup because: Its self-contained Its just one database file in your project. No server Because its just one database file in your project which holds all your data there is no extra server setup. No configuration All you need is to create your schema and the database is ready to store data. Letting Entity Framework Core Manage Your Database Schema For all its ease to setup, you still need a schema to define your tables and the relationships between them. Unless…

Creating a Visual Studio Code Task for Building a .NET Core Project

Visual Studio Code is a great new multi-platform code editor from Microsoft currently in beta. It is a lot more lightweight than Visual Studio. But when writing code I in VS Code I missed the Ctrl-Shift-B shortcut. It makes sense that VS Code doesn’t have it – after all, it doesn’t know what is being written and the build targets, and you can always build without it in .NET Core using dnu build but it can be added back in. Visual Studio Code Tasks Turns out you can integrate your own tasks into VS Code – when combined with Gulp it becomes easy…

Making a GET Request in C# using HttpClient

With my new job at New Orbit I am moving towards full stack web development in ASP.NET and AngularJS. The first issue I encountered was how to make a GET request to an external API. WebClient vs HttpWebRequest vs HttpClient. Which one?! It doesn’t help that are multiple options. Such as the WebClient, HttpWebRequest and HttpClient classes which all can be used to make a GET request – so which one to choose? Diogo Nunes has a nice discussion of the differences. After speaking with one of the Principle developers here it seemed HttpClient was the best option. Compared to WebClient it is closer…