Working with Entity Framework 6.3 and .NET Core 3.0

In May 2019, Microsoft announced that the first preview of Entity Framework 6.3 was available on NuGet. Entity Framework 6.3 will be the first version of Entity Framework 6 that can run on .NET Core and therefore, work cross-platform. This development, will make it easier to migrate existing applications that use Entity Framework 6 to .NET Core 3.0. … 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…

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

This is 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;   Setting … Read more…