How Entity Framework Core 6 or 7 projects can take advantage of EF Core 8's OpenJson without having to migrate to EF Core 8 - using a custom NuGet Package for SQL Server

All Articles

top

Entity Framework

Entity Framework: Storing Complex Properties as JSON Text in Database

18 Jan 2017 by Jovan Popovic(MSFT)

Mapping properties in EF model to database columns that contain JSON

HTML

.NET

entity-framework

SQL-Server

Dev

Architect

Entity Framework Fundamentals

5 Dec 2022 by Kenji Elzerman

Fundamentals of Entity Framework

.NET6

.NET

entity-framework

Learning Entity Framework (Day 4): Understanding Entity Framework Core and Code First Migrations in EF Core

9 Oct 2018 by Akhil Mittal

Entity framework core, code first migrations and data annotations in EF Core

Build a Visual Doctor Appointment Scheduling System in ASP.NET Core (.NET 6)

12 Jan 2022 by Dan Letecky

Use ASP.NET Core, Entity Framework, DayPilot and vanilla JavaScript to build a web application for doctor appointment scheduling.

Improvements and Enhancements of a Data Access Web Service Using WCF and Entity Framework

27 Mar 2014 by Shenwei Liu

An article with sample application showing how and what we can do to improve and enhance a WCF and EF data access web service

Dynamically Querying Entity Framework with ASP.NET

15 May 2017 by Charles d'Avernas

A ready-to-use solution for dynamically querying an Entity Framework DbContext in ASP.NET

EF Data Annotations and Code Fluent

17 Apr 2012 by Nadege Rouelle

Shows how to configure Entity Framework Code First with Data Annotations and Code Fluent.

entity-framework

SQL-Server

Dev

Angular Single-Page Applications - Cool Privilege Control System

29 Mar 2016 by wells cheung

Angular Single-Page Application, MEF, Privilege Control, WCF Restful Service, ui-router,

LINQ to Entities, Cross Apply, and Left Outer Join

12 May 2017 by DaveDavidson

In this article, I show LINQ to Entities syntax that will produce queries with CROSS APPLY and LEFT OUTER JOIN clauses.

Using Stored Procedure, User Defined Function and Views in a Custom Repository with ASP.NET Boilerplate

21 Feb 2018 by Yunus Emre Kalkan

How to create custom repostories in ASP.NET Boilerplate and use stored procedure, view, user defined functions inside your repository

entity-framework

ASP.NET-Core

ADO.NET

Database First with Entity Framework

15 Feb 2023 by Kenji Elzerman

Learn the basics of Entity Framework with the database-first approach

entity-framework

.NET7

Inheritance in Entity Framework: Table per Hierarchy

11 Jul 2014 by Sourav Kayal

This is the first article demonstrated inheritance in Entity Framework. In this article I have implemented the Table per Hierarchy approach.

entity-framework

Entity Framework Dynamic Report

5 Sep 2015 by Maxim Kurayan

EF Dynamic Report is a small open source project which allows you to use Entity Framework mapping between types and tables as a dynamic report data source

Mission Impossible: Migrating .NET Core 1.x to 2.0

19 Aug 2017 by Afzaal Ahmad Zeeshan

.NET Core 2.0 brings a lot of improvements to the system, and it brings a lot of pain to the developers as well. I had a lot of problems upgrading .NET Core 1.x apps to .NET Core 2.0; I yet have to feel the promise it makes about performance and so, but let us see how to upgrade our existing applica

Integrate Reporting Services with Silverlight and RIA Services

28 Jul 2010 by Ernesto Herrera

Integrate Reporting Services with your Silverlight Line-of-Business applications.

How to Use enum with Entity Framework 5 ?

26 Nov 2013 by Sampath Lokuge

This blog post shows how to use enum with Entity Framework 5.

.NET4.5

.NET

entity-framework

Highly Effective Data Insertion at Case of Oracle DB

31 Oct 2016 by SlavaUtesinov

EF implementation of BulkInsert operation and "Arrays in a Bind" solution at case of absence of EF.

entity-framework

Oracle

Entity Framework Introduction Using C# - Part One

10 Jun 2016 by Emiliano Musso

In this article, we will see how to use entity framework in our Applications, developed through the various languages that Visual Studio allows us to use. The examples in this article and probably in the next, will be C # used under WinForms, but - as mentioned - this choice is not going to affect a

ASP.NET Core Razor Pages Using EntityFramework Core with Enums as Strings - Part IV

23 Nov 2018 by Leonard E. James

Add Project and Project Skills Processing

.NET-Core

entity-framework

Autogenerate DataContracts for WCF from POCO Classes

7 Dec 2016 by Kuv Patel

Convert a class library of POCO classes to datacontracts for use with WCF without having to write DataContract and DataMember attributes directly to the POCO classes.

Best Ways of Implementing Uniqueness or Unique Key Attribute on a Model Property in ASP.NET MVC Code First: Part 2

29 Sep 2016 by Tanvir Ahmad Arjel

There are lots of ways to implement Uniqueness or Unique Key attribute on a model property other than primary key, but here I am going to discuss two possible best and easiest ways to do so in two parts of these series. This is Part 2.

Entity Framework DAL with Generic Seeding from JSON, Using Reflection

6 Mar 2017 by Michael Doleman

A simple DAL with an integrated, lightweight model for database seeding from a JSON source, using the code-first method in Entity Framework.

Hello World Angular 2+ Data Sample Using JavaScriptServices .Net Core and PrimeNG

13 Mar 2017 by defwebserver

You can create database driven .Net Core applications using JavaScriptServices, and PrimeNG.

Application Triggers for ASP.NET Core 2.1 Entity Framework Core

12 Nov 2018 by Vlad Neculai Vizitiu

Application triggers for ASP.NET Core 2.1 Entity Framework Core

entity-framework

ASP.NET-Core

ASP.NET

Using SPMetal

15 Mar 2011 by Not Active

Using SPMetal to generate Linq to SharePoint classes

Attaching Detached POCO to EF DbContext - Simple and Fast

11 Apr 2013 by MVukoje

Simple generic extension method that will attach detached POCO to DbContext without reloading it form DB

entity-framework

Entity Framework Core with multiple DB Contexts, Schemas and Projects

30 Mar 2018 by Milan Stanacev

How to use EF Core code-first approach when DB schemas are split into multiple projects and DB contexts.

Performance Tuning of Entity Framework Core with Azure SQL Server

22 Nov 2018 by Fred Song (Melbourne)

Dynamic Dashboard Web Application using ASP.NET Core, JavaScript, PostegreSql and ChartJs

12 Feb 2021 by O.Nasri

Steps to create a nice dashboard web page using .NET MVC Core

DSL and SQL Server Modeling CTP

22 Sep 2010 by Hossein Ghahvei Araghi

This article is about DSL and SQL Server Modeling

Building WPF Applications with Self-Tracking Entity Generator - IClientChangeTracking Interface

29 Dec 2011 by Weidong Shen

This article describes the IClientChangeTracking interface generated by Self-Tracking Entity Generator for WPF/Silverlight.

Forums application using MVC4 and Entity Framework

15 Feb 2013 by demouser743

I would like to share the application which is done in MVC4 using Entity Framework.

entity-framework

MVC4

EntityFramework Configuration Provider for .NET Framework & .NET Core

24 Oct 2016 by PatrickJNolan

Configuration.EntityFramework is a custom configuration provider for the .NET Core Configuration system built on EntityFrameworkCore.

Angular 7 SPA CRUD With ASP.NET Core And Entity Framework Core

17 Nov 2018 by Mangesh_Gaherwar

Article with Angular 7 and Entity Framework core and .net Core

.NET Core, PostgreSQL and Document Database

18 Oct 2020 by JawadHasan

Use NoSQL database functionality from within a Relational database system

A Beginners Guide for LINQ with C#

17 Dec 2022 by Kenji Elzerman

Let's take a look at the very fundamentals of LINQ and how to use it.

Return Multiple Result Sets or DataSet Using Entity Framework

29 Jun 2024 by DiponRoy

Select data as DataSet object for a database using Entity Framework and map results them to entity lists

Building WPF Applications with Self-Tracking Entity Generator and Visual Studio 2012 - IClientChangeTracking Interface

7 Mar 2013 by Weidong Shen

This article describes the IClientChangeTracking interface generated by Self-Tracking Entity Generator and Visual Studio 2012.

Silverlight Application with Management Entity Framework and WCF Service

20 Dec 2014 by Roger C Moore

A guide to constructing an application using Expression Blend and Silverlight for the front-end which obtains data from a WCF service and SQL Server back-end

Through ASP.NET Web API 2... !

21 Nov 2015 by KK Kod

Designing and Development of a simple ASP.NET Web API.

Case Insensitive Search Filter in OData ASP.NET Core 2.0 Web API as an OWIN Middleware

31 Jan 2018 by Pawel idzikowski

How to replace the web API request query string to provide case insensitive OData search

Using SQL Server 2017 Docker Container for Local Web API development in .NET Core

14 Jul 2019 by Viswanatha Swamy

In this article, we will be looking at how to use SQL Server 2017 Docker image for Local Web API development.

EF Core Contexts Sharing Transaction

26 Nov 2022 by Rudi Breedenraedt

How to share a transaction across multiple Entity Framework contexts

SQL

entity-framework

Entity Framework 7 – Database First – Using EFCorePowerTools

25 May 2023 by Mark Pelf

Tutorial on EF7 – Database First approach using GUI tools EFCorePowerTools

.NET

entity-framework

database

.NET8/EF8 - Exception: Microsoft.Data.SqlClient.SqlException (0x80131904): Incorrect syntax near '$

27 Sep 2024 by Mark Pelf

NET8/EF8 Breaking Change. Old servers/databases might not understand queries from EF8.

Building WPF Applications with Self-Tracking Entity Generator - Data Validation

21 Jan 2012 by Weidong Shen

This article describes how to do data validation with Self-Tracking Entity Generator for WPF/Silverlight.

Comparing Transparent Lazy Loading between NHibernate and Entity Framework

14 Jan 2012 by Henry He

In this article, I will explain what transparent lazy loading is and how it's implemented in NHibernate and Entity Framework.

Provide Html.LabelFor Value for Model Fields from Database at Runtime

7 Nov 2012 by Aydin Khatamneajd

Using ModelMetadataProvider to Set Display Name Metadata for the Model Fields at Runtime

Books and Help Resources on Entity Framework

11 Oct 2013 by ASP.NET Community

Programming theMicrosoft® ADO.NET Entity Framework by David SceppaPublisher : MicrosoftProgramming EntityFrameworkBuilding Data Centric

Build your own WebAPI using new ASP.NET 5 with EF and IdentityUser inside OSX

29 Dec 2015 by arif_uap

Build your own web-api using new ASP.NET 5 with EF and IdentityUser inside OSX

ASP.NET5

entity-framework

authentication

AngularJS and REST API - Part 2

19 Apr 2018 by charles922

AngularJS and REST API Tutorial - Part 2

[TinyERP: SPA for Enterprise Application]Manage Staffs - Part 2

27 Dec 2018 by tranthanhtu.vn

[TinyERP: SPA for Enterprise Application]Manage Staffs - Part 2

Testing Entity Framework Core

12 Nov 2018 by Vlad Neculai Vizitiu

How to write automated tests using entity framework core

O-Data Rest API in .NET with Entity Framework and AutoFac

8 Dec 2019 by Sunny Makode

This is an introductory article about creating an Odata Rest API in collaboration with Entity Framework. We are also going to use Autofac as our IOC container. Also, Repository and Unit of Work pattern will be used for cleaner access of persistence model through our ORM (Entity Framework).

Entity Framework 7 – Code First – Using CLI

1 Jun 2023 by Mark Pelf

Tutorial on EF7 – Code First approach using Command Line (CLI)

.NET

entity-framework

database

Entity Framework 7 – Database First – Using CLI

25 May 2023 by Mark Pelf

Tutorial on EF7 – Database First approach using Command Line (CLI)

.NET

entity-framework

database

Connection Scope for the Entity Framework

6 Apr 2010 by Rainer Halanek

A Connection Scope for the Entity Framework that allows to execute commands in a single connection

Web RSS Builder Part 2: The ASP.NET Application

5 Nov 2010 by SofianH

A description of the open source Web RSS Builder

Web RSS Builder Part 3: The Silverlight Application

5 Nov 2010 by SofianH

A description of the open source Web RSS Builder

Simple 3-layer App Based on MVC, EF and Fluent Validation

23 Oct 2015 by alex_lviv

In this article, I will try to describe my vision on creation of simple 3-layer application based on .NET technologies.

A Bug Fix That Has Least Impact On Existing and Future Codes

15 Nov 2016 by scott_liu

Sometimes, a bug fix cannot meet the challenges by a regression test. So thinking twice for a better solution is worthwhile for troubleshooting and bug fixes.

entity-framework

ASP.NET

Dev

EntityFrameworkCore Seeding Component

9 May 2017 by Adriaan Booysen

Adding Seeding Framework towards EntityFrameworkCore that can be wired up in either a dotnet core Web Application or WebAPI

In Memory Entity Framework Testing via Effort Library, In Practice

19 Sep 2017 by SlavaUtesinov

Practical guidance how to use Effort library in your unit tests including workaround with views and triggers and some pitfalls

EF6.0

entity-framework

testing

Create .NET MVC Web Application Using Visual Studio on Mac OS [Part 1]

29 Nov 2021 by Uladzislau Baryshchyk

This series of articles consists of three articles, in which I will demonstrate step by step how to create a .NET core MVC project

Improve EF Core 6\7 "Contains" Performance with OpenJson (SQL Server) - NuGet Package

28 May 2024 by Bert O Neill

How Entity Framework Core 6 or 7 projects can take advantage of EF Core 8's OpenJson without having to migrate to EF Core 8 - using a custom NuGet Package for SQL Server

Four Simple Steps: Creating a Silverlight Business Application Using DevForce

25 Mar 2009 by IdeaBlade, Inc.

Creating a Silverlight Application Using IdeaBlade DevForce Silverlight

discount ASP.NET

3 Sep 2009 by John Meeks

Award-Winning, Innovative, Feature-Rich ASP.NET Hosting starting from $10/month

POCO Entities Through RIA Services

10 Dec 2010 by Beavis Killer

This article demonstrates how to generate plain old class objects (POCO) from the Entity Framework v4 (EF4) and use them through RIA Services in SilverLight version 4.

Introducing the Rabbit Framework and its Dynamic Idea

23 Mar 2011 by Yiyi Sun

Rabbit Framework is a new lightweight framework for building web sites using ASP.NET Web Pages / WebMatrix. This article describes one interesting idea out of many found in the framework.

Entity Framework and Enums aka EFExtensions

23 Aug 2011 by Radu Pascal

Support for enums in Entity Framework is probably the most desired feature, and it's strange it is not supported. This article will show a way to implement it using templates.

Creating a small dependency injection framework

11 Oct 2013 by ASP.NET Community

Dear Friends,Dependency injection is the buzz word in asp.net world. There are lots of frameworks available today like Sprint.Net , Unity Framework

entity-framework

Entity framework

11 Oct 2013 by ASP.NET Community

What is Entity Framework?ADO.NET Entity Framework is an object-relational mapping (ORM) framework for the .NET Framework. Basically it represents the

Is SQL Server killing your application’s performance?

13 Oct 2015 by Ben Emmett

When an application suffers from performance problems, it’s common to assume the database is at fault. Ben Emmett examines why this often isn’t the case, and shows how you can dig into a .NET application’s use of SQL Server with ANTS Performance Profiler.

Bringing Control Back to Database Deployment with ReadyRoll and Entity Framework Code First Migrations

12 Sep 2016 by Redgate Software, Dan Nolan

In this article, I’m going to show you how you can continue using EF Code First to model your database, while also using ReadyRoll to do the actual deployment of T-SQL change scripts and overcome the challenges of the Code First approach.

Using EF Core with MySQL in DotNet Core 1.0

2 Dec 2017 by Siddharth R Barman

Interact with MySQL database using EF Core in DotNet Core 1.0.

Automation Testing Dogma and Exploration

12 Nov 2018 by Vlad Neculai Vizitiu

Automation testing dogma and exploration

EFUpsert

16 Feb 2019 by emerR46

This is a basic Update / Insert (Upsert) Function in Entity Framework

entity-framework

10 Points to Secure Your ASP.NET Core MVC Applications

5 Sep 2018 by Saineshwar Bageri

How to secure ASP.NET Core MVC Applications against top 10 attacks

Audit Tables and Data Versioning on SQL Server

23 Nov 2021 by Rick Drizin

Simple structure for keeping SQL Server Auditing Tables and Versioned Records in the same set of tables, using Audit Triggers and Entity Framework

Microsoft Blazor - Rapid Development with SQL Forms Open-source Platz.SqlForms

17 Apr 2021 by Ev Uklad

How to develop a Blazor server application dynamically and generate UI from Entity Framework using open-source Platz.SqlForms including master-details data entry

Repository with Unit of Work, IoC and Unit Test

24 Mar 2014 by Sul Aga

Repository with Unit of Work

SqlDependency with Entity Framework 5.0

29 Nov 2012 by Rick Bassham

This article will show you how to subscribe to data changes using Entity Framework 5.0.

entity-framework

The WPF-NHibernate Toolkit

16 Jan 2010 by David Veeneman

Adapt NHibernate classes to run in WPF

RIATasks: A Simple Silverlight CRUD Example (using View Model)

16 Jul 2010 by defwebserver

An example of a Silverlight Application that implements Create, Read, Update, and Delete using web services

Custom Rule Engine in WPF - MVVM

11 Sep 2010 by Renil Joy, Bangalore

Custom Rule Engine approach which can evaluate complex combinations of business rules. A sample application is provided in WPF following the MVVM pattern.

Learning Entity Framework (Day 2): Code First Approach and Migrations in Microsoft .NET Entity Framework

28 Sep 2018 by Akhil Mittal

Code First Approach and Migrations in Microsoft .NET Entity Framework

Best Ways of Implementing Uniqueness or Unique Key Attribute on a Model Property in ASP. NET MVC Code First: Part 1

26 Sep 2016 by Tanvir Ahmad Arjel

Two Strategies for Testing Entity Framework - Effort and SQL CE

19 Sep 2012 by David Bywaters

Two approaches for unit testing Entity Framework

Silverlight YouTube Jukebox

27 Apr 2010 by Katka Vaughan

Search and play YouTube videos inside a Silverlight 4.0 application! Learn about RIA Services, right-click event handling, themes, and styles.

Speed Up ASP.NET Core WEB API Application. Part 2

2 Oct 2019 by Eduard Silantiev

Using various approaches to increase ASP.NET Core WEB API application's productivity

Returning Multiple Result Sets from an Entity Framework Stored Procedure with Function Import Mappings

22 Jul 2015 by Shenwei Liu

How to fix Function Import mappings for EF stored procedure returning multiple result sets

To Repository Or NOT

15 Feb 2015 by Sacha Barber

A look at how to unit test code that makes use of Repository vs using raw Entity Framework, where we will do this using mocks/test doubles

C# Entity Framework Class Generator for Data Layer

19 Jul 2017 by malzbiertrinker

Anytime you are developing a project using Entity Framework, you need to create a DataLayer class accessing each object within your model with different methods. This generator will do this stuff for you.

Kerosene ORM Maps In Depth

1 Mar 2015 by mbarbac