Visual Studio – Build – Error “NETSDK1045: The current .NET SDK does not support targeting .NET Standard 2.1. Either target .NET Standard 2.0 or lower, or use a version of the .NET SDK that supports .NET Standard 2.1.”

Background Trying to build .Net Application, but running into an error. Error Error Image Error Text TroubleShooting Outline Project File Review .csproj file DotNet Installation Version dotnet application dotnet --info dotnet --list-runtimes dotnet --list-sdks Tasks Project File .csproj file Source Code Image Text Explanation Target Framework netstandard2.1 dotnet.exe dotnet.exe -- info Syntax Example Output Output … Continue reading Visual Studio – Build – Error “NETSDK1045: The current .NET SDK does not support targeting .NET Standard 2.1. Either target .NET Standard 2.0 or lower, or use a version of the .NET SDK that supports .NET Standard 2.1.”

Microsoft .Net – OleDbDataReader – Null Values

  Background A few days ago I found myself reviewing entries in a table and discovered records completely missing in some cases. TroubleShooting Source As I dug in further traced the issue back to a source data source. SQL Here is the SQL that gathers metrics for each file Issue Issue - Immediate The problem … Continue reading Microsoft .Net – OleDbDataReader – Null Values

Entity Framework – Model – Approach – Code First – Database – New Database

Background Continuing down the path of understanding how Entity Framework - Code First approach works with our SQL Server. Queries Submitted by Entity Framework to Database Connection Request Connection Request - Failed Exception Column :- TextData Database 'dbFriend' does not exist. Make sure that the name is entered correctly. Audit Log Failed Column :- TextData … Continue reading Entity Framework – Model – Approach – Code First – Database – New Database

Entity Framework – Model – Approach – Code First – Day 01

Background Without much in terms of conversation wanted to share the simplest files needed to put together an Entity Framework - Code First sample project.   Files Outline Source Code POCO Files friend.cs DBContextFiles dbContextFriend.cs Other Files app.cs Configuration Files app.config   In Depth Source Code POCO Files Friend.cs Class friend Property id name Annotation … Continue reading Entity Framework – Model – Approach – Code First – Day 01

.Net – Entity Framework – Error – “Error CS1070: The type name ‘TableAttribute’ could not be found. This type has been forwarded to assembly ‘System.ComponentModel.DataAnnotations’

Background A quick follow up to our last post on adding annotations to our plain old C# class ( POCO). Lineage .Net – Entity Framework – error CS0246: The type or namespace name ‘DatabaseGenerated’ could not be found Link   Error Error Text Error Image Remediation Outline Please be sure to add System.ComponentModel.DataAnnotations.dll to the … Continue reading .Net – Entity Framework – Error – “Error CS1070: The type name ‘TableAttribute’ could not be found. This type has been forwarded to assembly ‘System.ComponentModel.DataAnnotations’

.Net – Entity Framework – error CS0246: The type or namespace name ‘DatabaseGenerated’ could not be found

Background Here is our first post on adding annotations to our plain old C# class ( POCO). Lineage .Net – Entity Framework – error CS0246: The type or namespace name ‘DatabaseGenerated’ could not be found Link Error Error Text Error Image TroubleShooting Source Code Source Code - Included Namespaces Here are the originally included namespaces :- … Continue reading .Net – Entity Framework – error CS0246: The type or namespace name ‘DatabaseGenerated’ could not be found