Following the Microsoft tutorial for building a .Net Standard library with Visual Basic from here, I have decided to make a video for .Net Standard library with C#. Pretty much, it is one and the same. The library contains one …

C# – Build a .NET Standard library with Visual C# – Video Read more »

Exactly 1 month and 5 days after the first video tutorial for the ASP.NET MVC with EF Core series, the last 10th video tutorial, following the Microsoft ones, is published. It is about advanced scenarios, and I have mentioned the …

C# – Learn about advanced scenarios – ASP.NET MVC with EF Core Read more »

After updating the related data in the ASP.NET tutorial, it is time for the next step – handling concurrency in the MVC Application. These are the points, followed by the video: Learn about concurrency conflicts Add a tracking property Create …

C# – Handle concurrency – ASP.NET MVC with EF Core Read more »

After reading complex the data, it is time to be able to update it. This video fills the following points from the ASP.NET MVC tutorial: Customize Courses pages Add Instructors Edit page Add courses to Edit page Update Delete page …

C# – Update related data – ASP.NET MVC with EF Core Read more »

Web API with Visual Studio 2019 is quite a bolierplate task – it is doable in less than 45 minutes, following the Microsoft.com tutorial: The video tutorial is here: The TodoController , implementing the CRUD actions looks like this: using System.Collections.Generic; …

C# – Create a web API with ASP.NET Core – Video Read more »

The longest palindromic substring algorithm exists since 1975. It is different (and easier) than the longest palindromic subsequence. The idea of the substring is to return “anana”, if “bananazorro” is given. This is achieved with a 2 dimensional boolean array matrix and …

VBA – Longest Palindromic Substring Algorithm with Excel – GIF Read more »

Reading from Excel in C# is actally not at tough as many VBA developers would assume. The simple reading is actually quite straightforward – there is only small little trick, requiring the adding of the Microsoft.Office.Interop.Excel reference to the Visual …

C# – Reading from Excel Spreadsheets with Asynchronous Programming (Async) Read more »

Getting the last row of a given column in Excel with a formula or with VBA is quite a trivial task. It is explained here quite well 🙂 However, when we come to C#, the only “trick” that is provided …

C# – How to get the last filled cell of a given row in Excel Read more »

Finding the biggest square of specific units in a given matrix of these units is a standard dynamic programming problem. The examples in Google for it are above 18 million, thus I would simply show how it is done with …

C# – Find the Biggest Square in a Matrix – What can Excel and VBA add to it? Read more »

In this article, I present an Entity Framework example, building two tables with foreign keys, using code first. The sample I am using is building over the previous article for EF. Pretty much, when you are running your application, if …

C# – Foreign Keys in Entity Framework – Code First – Query with Linq Read more »