Resolving “System.IO.IOException: The process cannot access the file because it is being used by another process” CLR Error

In the world of .NET development, encountering CLR errors is not uncommon, and one of the most frequently faced issues is the “System.IO.IOException: The process cannot access the file because it is being used by another process.” error. In this article, we will be discussing about the possible root causes of this error and explore … Read more…

System.IO.FileLoadException: could not load file or assembly…

Hi friends, in this article, we will be discussing about, how to resolve the below error, when working with CLR assemblies in SQL Server: An error occurred in the Microsoft .NET Framework while trying to load assembly id… The server may be running out of resources, or the assembly may not be trusted. Run the … Read more…

The type or namespace name ‘Office’ does not exist in the namespace ‘Microsoft’ – How to Resolve

Hi friends, in this article, we will be discussing about, how you can resolve the following error you might get in your Visual Studio project: CS0234 The type or namespace name ‘Office’ does not exist in the namespace ‘Microsoft’ (are you missing an assembly reference?)   Why I Received this Error Message? The reason you … Read more…

How to Build a Simple Image Viewer with .NET WinForms and C# in Visual Studio

Hi friends! In this post, which is actually a 30-min video guide, we will see together, step-by-step, how you can easily build a simple image viewer with .NET WinForms and C# in Visual Studio. Our Simple Image Viewer App’s Functionality The functionality of the simple image viewer app we will be developing in Visual Studio, … Read more…

Tip of the Week No.16 – Available Visual Studio Editions

Check our Tip of the Week, which this week discusses about the available Visual Studio editions and discuss about their main differences. Tip of the Week #16 There are 3 Visual Studio editions. There are: Community Edition (free) In comparison with the other editions, the Community Edition of Visual Studio lacks some features, mainly about: … Read more…

What Entity Framework Core is and How to Enable it in your C# Projects in Visual Studio

In this article, you will learn what Entity Framework Core is and how to enable it in your C# Projects in Visual Studio. Entity Framework Core, is the Cross-Platform version of ADO .NET Entity Framework. In one of my older articles, I have provided an introduction to Entity Framework. Entity Framework Core, as mentioned above, is its … Read more…

There was an error reflecting type… (.NET/C#)

Let’s say you have a C# (or VB.NET) project with namespace “MyProject” and you are trying to serialize a class named “MyClass” and you get the error message: There was an error reflecting type ‘MyProject.MyClass’. The first thing to check, is that the class which you want to serialize (that save it to disk), contains … Read more…

Microsoft SSIS Service failed to start. Configuration system failed to initialize

In this article, we will be discussing about the error message: “Microsoft SSIS Service failed to start. Configuration system failed to initialize”.  We will talk about what this error message means, as well as, how you can resolve it.   About the “Microsoft SSIS Service failed to start” Issue It happened at some point to … Read more…

Using the C# SqlParameter Object for Writing More Secure Code

C# SqlParameter is a handy feature allows you to safely pass a parameter to a SqlCommand object in .NET. A security best practice when writing .NET data access code, is to always use parameters in SqlCommand objects (whenever parameters are required of course). The reason for this, is that parameters help prevent SQL injection attacks. … Read more…

The Net.Tcp Port Sharing Service service on Local Computer started and then stopped

This article, discusses the root cause for the error message “The Net.Tcp Port Sharing Service service on Local Computer started and then stopped” and suggests a solution to the issue.   The Root Cause for the Error Message Under certain circumstances, you might be experiencing problems with the “Net.Tcp Port Sharing” Service on Windows Server, … Read more…

How to Establish a Simple Connection from a C# Program to SQL Server

This article, provides a basic example, on how to establish a connection to SQL Server from a C# program with the use of the “using” statement in C# which help you better managing your database connections.   Using the System.Data.SqlClient Use the System.Data.SqlClient namespace in the top section of your code as below: using System.Data.SqlClient;   … Read more…