Category: C Sharp Tricks

Why do Java developers wear glasses?
Because they do not C#.

C# – Create a web app with ASP.NET Core MVC – Video

Creating a web application with ASP.NET could look as a hard task. Still, with the pre-built MVC models from Visual Studio, the task is a bit easier. This is how the application looks like, with 2 search buttons and fully

Tagged with: , , , , , ,

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

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:

The

Tagged with: , , , ,

C# – ASP.NET Core MVC Application with Basic Database Access using Entity Framework – Video

The title somehow looks like random words, picked from a hat at one of those college games we are not supposed to talk about. Anyway, at the second reading it hopefully becomes a bit clearer. And it is simply the

Tagged with: , , , ,

ASP – Data Entry MVC Application with Database – Video

After the first video for MVC here, I have decided to make a next part, in which I save the entries to a database and display them:             Sounds like a tiny update. However, it

Tagged with: , , , , ,

C# – xUnit Test Implementation in Fibonacci Calculation – Video

Good software comes with tests. Fortunately, Visual Studio 2019 provides quite nice ways to test the software you are creating. One of these is xUnit – xunit.net. Thus, I have decided to make a video, showing how to implement xUnit

Tagged with: , , , ,

ASP – Data Entry MVC Application – Video

I have started reading the 2nd edition of the Pro ASP.NET Core MVC book and after reading the first couple of chapters, I have decided to make a video of the application in the second chapter. The code is about

Tagged with: , , , ,

C# – Look at the Variables’ Values, while Debugging in Visual Studio

Debugging is like being the detective in a crime movie where you are also the murderer. In order to debug well, we need to know the value of the current variable. In Visual Studio, this could be acquired through multiple ways.

Tagged with: , , , ,

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

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

Tagged with: , , , ,

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

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

Tagged with: , ,

C# – Refactoring a Problem

Some days ago I have decided to take a look at one of the homeworks problem of the OOP course at SoftUni. Then, I have decided to solve it with my VBA OOP knowledge, implementing it in C#. Whether VBA

Tagged with: , ,

C# – Quick Reference for Abstract Classes

Abstract Classes in C# are classes, intended only to be a base class of other classes. Members marked as abstract, or included in an abstract class, must be implemented by classes that derive from the abstract class. Reference With other

Tagged with: , ,

Visual Studio – How to create a custom shortcut

If you want to create a custom shortcut to a command in Visual Studio, these are the steps to be taken: Ribbon>Tools>Options Environment>Keyboard Show commands containing (write the command) Press shortcut keys Assign and OK

Tagged with: , ,

C# – Entity Framework – Using LINQPad for Queries – Just Getting Started

After the previous two articles for C# – Foreign Keys in Entity Framework – Code First – Query with Linq and Entity Framework – Linq vs Extension Methods (Example) it is a good idea to present some actions with LINQPad. LINQPad5 is

Tagged with: , ,

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

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

Tagged with: , , ,

Entity Framework – Linq vs Extension Methods (Example)

This article presents a simple example of querying with Linq and Extension Methods in Entity Framework (EF). To set the EF, create a C# Console application. Then add the Package Manager Console from Tools: Then run Install-Package EntityFramework in the Package

Tagged with: , , ,

C# – Split String in One Line and Get the First SubString

Imagine, that you are given a string in C# with some separator in it, and you need to split it and refer to the first or the second part of the splitted string. E.g., you are having  *AAAaa*SEPARATOR*zzZZZ* and with one line,

Tagged with: ,

C# – Casino Black and Red Simulation – is it Worthy?

Going to a casino is probably quite an easy way to lose money. In the long term. Let’s say that you are following the strategy – always double when you lose and you bet on numbers above 18 on the

Tagged with: , , ,

.Net – Reading Excel file in C# and transferring it to a matrix

There is an ERP joke, claiming that the third most popular button of an ERP system is “Export to Excel” (after OK and Cancel). Thus, working with Excel from .Net is happens often. There are some pitfalls, that you should

Tagged with: , , , ,

C# – Looking for a value in Excel with C# & VisualStudio

Using Visual Studio and Excel is actually quite fun – the Visual Studio advanced environment provides a bit more possibilities than the Visual Basic Editor, built-in Excel. In this article, about a year ago I have shown how to loop

Tagged with: , , ,

C# – CodeForces – Chtholly’s request

Solving problems at CodeForces is a kind of hobby. Lately, in round 449, division 2, there was a problem which has met my interest. It has to do with palindromes and really big numbers. The problem is easy to calculate,

Tagged with: ,

VBScript Simple Program – Problem in CodeForces

In order to learn a language, the best way is to practise it! Thus, I have decided to challange myself to solve a task on CodeForces with VBScript.  As far as VBScript is not one of the official CodeForces languages

Tagged with: , , ,

C# – CodeForces – Borya’s Diagnosis

Every time, wherever I decide to take a look at CodeForces and to code & publish some of the easy problems, I am thinking that this is probably the last one, because it is too easy. However, I always find

Tagged with: , ,

C# – SoftUni – Natural Order Sequences

Another SoftUni algorithm problem that I have considered interesting is presented here: You are given an integer S. Generate all non-empty sequences of numbers in range [1…S], which have sum of elements ≤ S. Display the sequences in their natural order,

Tagged with: , , ,

C# – CodeForces – Tell Your World

Y = mX+B This formula is the basics of the Cartesian coordinate system. And about 70% of the knowledge, needed to solve problem B in the 2. Division of CodeForces. The problem looks like this: There are n points on a coordinate

Tagged with: , ,

C# – CodeForces – Two TVs

Having two TVs is great. Or it used to be in the 90s. Anyhow, the latest problem in CodeForces that I have resolved was concerning a guy with a schedule of TV shows, which he was planning to watch on his

Tagged with: , ,

C# – CodeForces – Luba And The Ticket

Magic tickets are considered the tickets in which the sum of the left digits is equal to the sum of the right digits. E.g., if you ticket is number 124016 it is a magic ticket, because 1+2+4 = 0 +

Tagged with: , ,

C# – CodeForces – Game of Rows

CodeForces.com has become something like a hobby – instead of thinking about a topic for an article, I simply solve a problem there and blog about it. Thus, lately I have taken a look at Round 428, Division 2, problem

Tagged with: , , ,

CodeForces – Star Sky

CodeForces.com is one of the reasons why I blog quite often. Last week, in round 427 there was an interesting problem, which I was eager to solve. The problem was described as follows: The Cartesian coordinate system is set in

Tagged with: ,

C# – CodeForces – Keyboard Layouts

CodeForces.com is the web site, which shows problems for competitive programmers. Today I have decided to take a look at the 2. problem of the 2. division of Round 424 –Keyboard Layouts. The problem is pretty simple to explain for

Tagged with: ,

C# – CodeForces – A. Mister B and Book Reading

Codeforces has easy and tough questions. However, the easy are not always easy, but the tough are always tough. Thus, after writing the Excel article here for Sumproduct, I have decided to go a bit easy and start with the

Tagged with: ,
Top