I would like to proudly announce the release and availability of my new Beginning C# and .NET 2021 Edition book, which was co-authored with Jon Reid. The book contains over 800 pages of material relating to the skills and knowledge required to become a great C# programmer. The book is designed around the premise that […]
Read More →Tags: Entity Framework
How to install Entity Framework Core 2.1
I wrote this post about installing ASP.NET Core 2.1, plus these others which may be of interest: Create a .NET Core 2 application on Linux with Visual Studio Code How to enable C# 7 in Visual Studio 2017 How to install .NET Core 2.0 How to install .NET Standard 2.0 How to install ASP.NET Core […]
Read More →ASP.NET Core with Entity Framework Core SqlException: cannot openserver
I am doing some ASP.NET Core self study and experienced this issue. The thing is that my client IP changes from time to time and need to add it to the the firewall so that database connections are allowed to it. This happens mostly when I am debugging or coding from my workstation while the […]
Read More →ASP.NET Core with Entity Framework Core error, Login Failed
I was working with the EF NuGet package Microsoft.EntityFramework.Tools.DotNet and executed the command-line interface (CLI), also shown in Figure 1. dotnet ef database drop Running this method resulted in the same behavior: context.Database.EnsureDeleted(); Figure 1, Entity Framework Core, CLI I am not sure what exactly I was thinking, but it I did not really expect […]
Read More →ASP.NET Core with Entity Framework Core – ASPNETCORE_ENVIRONMENT
This is another one, Figure 1, that just kind of happened because I dropped my database. Once I re-created the database and my ASP.NET Core application could access it, all was back to normal. Figure 1, ASPNETCORE_ENVIRONMENT environment variable to Development, and restarting the application. Error. An error occurred while processing your request. Development Mode […]
Read More →Online SQL Formatter for ORM generated SQL
With the recent introduction of so many ORM’s (Object-relational mapping) tools onto the market it is becoming less and less needful to write SQL statements. Tools like NHibernate, Entity Framework and SubSonic to name a few will take your database mappings and write an optimized query for you. However, during development, testing or production support […]
Read More →Using Entity Framework and Web API, I get a 500 Internal Server Error or a Hang
I was working on some code that used Entity Framework and an ASP.NET WebAPI as the interface for accessing the data. With my experience so far, when I publish my WebAPI and then access it, the result is a JSON formatted file that I can open or save via a message popup similar to that […]
Read More →Using NuGet to install your ORM into Visual Studio
I have spent a lot of time Working with NHibernate 3.0 and now am also giving some attention to the Entity Framework. One of the road blocks for using NHibernate is the initial configuration requirements. There are a significant number of actions which must be taken to get NHibernate working, where as, the Entity Framework […]
Read More →NHibernate and Entity Framework
Prior to getting my job here at Microsoft, I was, and in many aspects still am passionate about NHibernate. I discovered a particular liking to ORM’s in general. I liked it so much that I wrote a book called “Working with NHibernate 3.0” which is available on Amazon or from the Wrox.com website. What I […]
Read More →