Follow @endyourif rss Facebook LinkedIn
About Jamie Munro

Welcome to my blog. I have been compiling articles since 2009! Below is a list of every post I've ever created. Some of my major focuses have been compiling the best source of jQuery tutorials on the Internet today. A recent focus of mine is now focusing on creating the best SQL Tutorials for Beginners, Intermediate and Advanced Users. This is a compiliation of all my experience about how to do common SQL commands to optimize for performance. As you might see from the links around here, I've also written and published 5 books. My first and last book are focused around ASP.NET MVC and Web API tutorials. The last book has a big focus on integrating Knockout.js as the MVVM for the front-end code. O'Reilly Media was so interested in Knockout.js that they actually commissioned me to write that book first as it is one of the only books dedicated entirely to this MVVM library. So if you're looking for the best Knockout.js tutorials, I've compiled the best list. My first book, even though it was self published, was on the PHP framework: CakePHP. I used this framework for years and many of my first ever exampes were all focused on CakePHP tutorials that provide so many fantastic PHP examples. There are so many Javascript tutorials out there, but I noticed that one of the things I work on most with Javascript is arrays. With this I've worked hard on compiling a big list of really advanced Javascript array examples. These array examples are amazing including how to group by, get distinct array elements and so many more. I've also dabbled a little bit with Node.js and during those experiments I definitely ran into some common errors like Can't set headers after they are sent, Solving No Access-Control-Allow-Origin with Node js and Express, and Uncaught ReferenceError: require is not defined. With these common errors I've compiled a list of Node.js tutorials that help solve these problems, but more importantly getting you started with the basics.

Entity Framework Core Database First (with examples)

Published on Aug 9, 2022

Entity Framework database first approach is very common with existing databases or where you need more control than EF code first. Let's look at some examples.

What is lazy loading in Entity Framework

Published on Aug 8, 2022

In this article, youíll discover why lazy loading with Entity Framework is so beneficial and how you can implement it yourself.

Executing raw SQL queries using Entity Framework Core

Published on Aug 3, 2022

Entity Framework Core allows users to execute raw SQL queries directly against the database. Let me show you how.

Updating specific fields using Entity Framework

Published on Jul 8, 2022

Let me show you how to use Entity Framework to update only changed fields when doing a SaveChanges with a handy re-usable function.

The specified type member is not supported in LINQ to Entities. Only initializers, entity members, and entity navigation properties are supported

Published on Jun 21, 2022

This morning I was writing an Entity Framework query where I was selecting an object from a model called Invoice to a table called NetsuiteErrorLog. This previously used to be an actual relationship in my EDMX; however, I needed to do some refactoring and remove the direct foreign key from Invoice to NetsuiteErrorLog. When I did this I needed to add a new partial property that mimicked this relationship. When I did that and tried to perform my query I received the generic error:

The specified type member 'NetsuiteErrorLog' is not supported in LINQ to Entities. Only initializers, entity members, and entity navigation properties are supported

Detaching specific objects using Entity Framework before SaveChanges

Published on Jun 4, 2022

Entity Framework Stored Procedure Returns No Columns

Published on Feb 22, 2020

Using ActionFilterAttribute to validate all form input

Published on Feb 1, 2020

Improving the performance of slow Entity Framework queries

Published on Apr 18, 2019

Preventing race conditions with sp_getapplock

Published on Apr 17, 2019

Entity Framework's Code-First with an ObjectContext

Published on Mar 20, 2019

Entity Framework Beginnerís Guide Done Right

Published on May 13, 2013