Entity Framework – Just a Few Clicks Away

Total: 1 Average: 5

Entity Framework is an open-source object-relational mapping (ORM) framework for .NET applications. It let the developers work with data on a higher level of abstraction without the need to worry about the database type or structure where the data is stored.

The focus of this article will be to show and explain how easy it is to add an Entity Framework to a .NET project.

CodingSight - Entity Framework - just a few clicks away
Read More

What is LINQ in C#? Why Do we Use it? Tutorial with Query Examples in LINQ to Objects

Total: 7 Average: 5

Less is more – this is definitely true when it comes to object collections and LINQ queries.

Among the Language Integrated Query technologies, LINQ-to-objects is the most versatile. That’s why it will be the focus of this article. We will examine and compare traditional solutions to some programming challenges based on the data collections with alternative LINQ-based solutions.

Read More

ASP.NET vs. PHP: the Best Framework for Web Development

Total: 1 Average: 5

The primary goal of web development teams is to deliver web applications with the best user experience, scalability, and sustainability. Hence, developers always look for the right technology stack to build with these goals.

There are various web technologies stacks like PHP, .Net, Ruby on Rails, Java, or Python. PHP and .NET are the most commonly used technologies in web development. As statistics claims, PHP and ASP.NET hold the lion’s share of the web technologies market. In most cases, development teams choose between these two variants.

Both options have their pros and cons. In this article, we’ll discuss the differences and applicability of PHP and ASP.NET.

Read More

Completing SQL. Part 3: Complementing SQL. The life of Visual Studio extensions. Working with IO. Using SQL in unconventional ways.

Total: 20 Average: 3.9

What is this article about?

This is the third article in the series of articles on the life of IDE developers for databases.

Its structure will be similar to the first one and the second one, even so, I am not going to tell you about the parsing of text. This article will present information on some tricks working with files and various problems of creating a big desktop application on the .NET platform.

Read More

Completing SQL. Part 2: Optimizing string processing and file opening

Total: 22 Average: 4

What is this article about?

This is the second piece from the series of articles about the life of database IDE developers. Its structure is similar to that of the previous article. Just like in the first one, I’ll talk about the issues we faced and the solutions we arrived at – both effective and not so much. To understand this article, you don’t have to read the first part in its entirety, but the first few paragraphs would be useful to help you grasp the context.

Read More

.NET – Tools for working with multithreading and asynchrony – Part 2

Total: 11 Average: 4.9

This article comprises the second part of my speech at the multithreading meetup. You can have a look at the first part here. In the first part, I focused on the basic set of tools used to start a thread or a Task, the ways to track their state, and some additional neat things such as PLinq. In this part, I will fix on the issues you may encounter in a multi-threaded environment and some of the ways to resolve them. Read More

.NET: Tools for working with multi-threading and asynchrony – Part 1

Total: 22 Average: 4.7

The need to do things in an asynchronous way – that is, dividing big tasks between multiple working units – was present long before the appearance of computers. However, when they did appear, this need became even more obvious. It is now 2019, and I’m writing this article on a laptop powered by an 8-core Intel Core CPU which, in addition to this, is simultaneously working on hundreds of processes, with the number of threads being even larger. Next to me, there lies a slightly outdated smartphone which I bought a couple of years ago – and it also houses an 8-core processor. Specialized web resources contain a wide variety of articles praising this year’s flagship smartphones equipped with 16-core CPUs. For less then $20 per hour, MS Azure can give you access to a 128-core virtual machine with 2 TB RAM. But, unfortunately, you cannot get the most out of this power unless you know how to control interaction between threads. Read More