EntityFramework.MoqHelper library to work with Entity Framework 6 and Moq libraries doing mocks of Entity Framework main methods that access database.

.NET

EF6.0

entity-framework

mocking

TDD

Organizing Fluent Configurations into Separate Classes in EF Core 1.0

20 Aug 2017 by Mohsen Esmailpour

Organizing Fluent configurations into separate classes in EF Core 1.0

.NET

entity-framework

Dynamically creating a predicate delegate

29 May 2014 by Randy Kroeger

Created a POC that dynamically builds a predicate using Expression and Reflection.

Exclude Type from the Model in Entity Framework Code First

12 Oct 2014 by Dukhabandhu Sahoo

Know how to exclude types from the Model in Entity Framework Code First

Entity Framework DiagnosticsContext: Get Detailed Information on ChangeTracker Entries

13 Nov 2015 by OrlandoCurioso

An EF base DbContext that provides detailed information on current and totalized changes

15.2 What's New for XAF

29 Nov 2015 by Michael Bogaerts

What brings the 15.2 release for XAF (win) developers

Entity Framework and Views, if a PK Not Available

18 Nov 2017 by Norman Paterson

Performance issue using ROW_NUMBER() OVER in a database view for the PK

.NET

entity-framework

Dev

LINQ To Entity Outer Join

21 Apr 2010 by Mr Orange

Introduction...

.NET

entity-framework

LINQ

Entity Framework Code First Migrations Alternative

30 Jul 2014 by DiponRoy

How to handle database scheme changes with normal SQL scripts, without migration in Entity Framework code first

Business Logic Server as Windows Service (Architectural Prototype)

23 Jan 2016 by Igor_A

An architectural prototype of a business logic server as Windows Service. Sample service implementation and test utility.

Entity Framework 5.0 - Performance Tuning Using SqlBulkCopy

22 Jul 2016 by Abhay@Accenture

Performance tuning using SqlBulkCopy

Entity Framework: Separate Entity Class Mapping using Fluent API

6 Nov 2018 by MdAsifBd

Separate entity class mapping using Fluent API

Update Entity Framework ConnectionString Editor

6 Apr 2014 by Kaj Bromose

Helper class

entity-framework

Dev

Entity Framework Migrations enabled in Data Access Class Library used in MVC project

10 Nov 2014 by Valentino_Lokesh

Migrations enabled in Class Library (Data Access Layer) and the same is referenced to MVC ProjectNo need to maintain the Data Access and Model classes in the MVC Project. We can have separate Class library for Model and Data Access and have migrations enabled in Data Access where DbContext resides.

Easing Non-standard EntityFramework Migrations

5 Jan 2018 by #realJSOP

When you have a customized DbContext constructor.

VS2022, ver. 17.6.2 – EntityFramework6 Broken

6 Jun 2023 by Mark Pelf

Fix for adding new DB tables does not work in VS 2022, ver. 17.6.2, EF6 (Classic)

entity-framework

Visual-Studio

Change database name created by Code First

17 Apr 2012 by Nadege Rouelle

Let's see how to define our own database name using Entity Framework Code First

entity-framework

Dev

Generic Entity Framework AddOrUpdate Method with Composite Key Support

10 Aug 2016 by Nathan Minier

Generic AddOrUpdate for EF with composite key support

Improving How ASP.NET Security Tables are Scaffolded

8 Sep 2017 by Brady Kelly

How to improve the naming and change the naming and schema of all the Identity tables like AspNetUsers

entity-framework

Dev

Architect

Entity Framework Dynamic Include Hierarchy

11 Sep 2017 by Alen Toma

Entity Framework Dynamic include hierarchy

Expression-blend

entity-framework

ASP.NET

Getting Started with IdentityServer4 - Quick Reference

8 Oct 2019 by Ger Hayden

These notes are based on my experience getting started with IdentityServer4.

Extension Method to help with EF Code First updating

1 Nov 2011 by Daniel Lo Nigro

As far as I know, the "UpdateModel" method is designed to do this. Something like this should work, but I haven't tested it:public ActionResult Edit(Entity entity){ var entityInDbSet = _context.Set.SingleOrDefault(x => x.Id == entity.Id); UpdateModel(entityInDbSet); ...

entity-framework

extension

Linq Except Operator to Get NonEmployee And Employee collection

17 Dec 2012 by santosh poojari

This is most general collection operation that we come across daily. Its set based operation using LINQ Except Operator.

Entity Framework Code First Navigation Property is null - solution

19 Mar 2013 by Nejimon CR

A simple possible solution to Entity Framework Code First Navigation Property/Related Records not being loaded automatically

.NET

entity-framework

Simplest Way to Make an OUTER JOIN in LINQ to Entity

12 Jun 2014 by Super Lloyd

The title says it all! Make an outer join in 1 LINQ statement

entity-framework

Entity Framework Not Inserting Rows into SQL Server Database Table

25 Feb 2018 by GuyThiebaut

Solving the "Store update, insert, or delete statement affected an unexpected number of rows (0)" response.

Oracle DB EDMX: Switch Between Prod/Test/Stage Schema Names Dynamically using Entity Framework DB First Approach

5 Jun 2020 by DiponRoy

Use same EDMX file with different Oracle database schemas

entity-framework

Oracle

Create .NET MVC Web Application using Visual Studio on Mac OS [Part 2]

1 Dec 2021 by Uladzislau Baryshchyk

Application that can be used to work with subd and connecting Amazon RDS to the project

Extension Method to help with EF Code First updating

24 Oct 2011 by George Danila

An Extension Method that might help you copy over the values from one object to another, provided they are of the same type.

entity-framework

extension

IDbContextFactory which gets Connection String at runtime and triggers Automatic Migrations

4 Feb 2013 by retsnoM

Sample code showing how to implement IDbContextFactory for retrieving ConnectionString at runtime and trigger automatic migrations. For use with DI and IoC or if you have different databases with the same model.

.NET

entity-framework

Dev

Retrieve Multiple Dynamics CRM 2011 Entity Records from BizTalk 2010 Server

9 Jun 2013 by mkader

Dynamics CRM 2011 and BizTalk 2010 Server Integration - Retrieve Multiple Dynamics CRM 2011 Entity Records from BizTalk 2010 Server

entity-framework

CRM

biztalk

Entity Framework 2.1 - npg PostgreSql Error

17 Feb 2019 by Wael Al Wirr

PostgreSQL exception 42P01

Oracle DB EDMX: Upgrade ASP.NET Project and Entity Framework to use Oracle.ManagedDataAccess.Client

14 Jun 2020 by DiponRoy

Upgrade a legacy ASP.NET project to use managed Oracle.ManagedDataAccess.Client instead of unmanaged Oracle.DataAccess.Client while using Entity Framework DB first or EDMX.

Executing SQL Code within EntityFrameworkCore Migration in Correct Order (SQLite)

10 Mar 2022 by Master DJon

New MigrationSqlGenerator to generate SQL from MigrationOperations having attribute "ExecuteAfter" or "ExecuteBefore"

entity-framework

SQLite

Big n Bulky "How To" Document for ASP.NET MVC, Entity Framework, LINQ, HTML 5 and JQuery

28 Sep 2014 by Bhushan Mulmule

This is terribly unorganized document with mix of MVC, Entity Framework, LINQ, HTML 5 and JQuery how tos...

Pagination with Entity Framework

24 Feb 2016 by Lộc Nguyễn

On Chinook digital media store sample database

entity-framework

Move Entity Framework Core v5.0 to a Separate Project

7 Apr 2021 by mark_worrall

How to move Entity Framework Core v5.0 into a separate Visual Studio Project

ASP .NET Data Repeater for hierarchical data source

16 May 2014 by Ahmad F Hassan

An easy way to view hierarchical data in a simple ASP .NET Repeater

Data validation framework at entity level using Data Annotations

11 Nov 2013 by sathya88

A simple framework for data validation using data annotations at entity level.

Generic JqGrid Implementation in MVC

8 Feb 2017 by Arun Chandrasekhara Pillai

Generic JqGrid implementation in MVC with custom filtering and dynamic sorting

Left Outer Join extension for Entity Framework

11 Feb 2014 by Tony Sherlock

Snippet for Left Outer Join, Entity Framework

Render Exceptions in an Entity Framework application

8 Feb 2012 by Harry von Borstel

Extension Method for exceptions that give a useful text even on Entity Framework Exceptions

.NET

entity-framework

exceptions

Mocking EF DbContext

13 Oct 2016 by MaDOnos

Adapter implemantation to mock DbContext easily

Entity Framework 7 - How to Retrieve Dynamic Data

9 Nov 2015 by ChristineBoersen

A technique to return dynamic data from a SQL Query using Entity Framework 7

C#6.0

entity-framework

Very Basic Console Application Using Entity Framework

5 Nov 2015 by Md. Mainul Islam

This tip will show the ways to incorporate Entity Framework in .NET applications.

How to Easily Map EntityFramework/EntityFrameworkCore Entities from/to DTOs

22 Oct 2023 by David_Cui

To introduce a free library to save some tedious work for writing mapping code between entities and DTOs

EF-Core

entity-framework

JSON

Repository Pattern with Entity Framework 4.1 and Code First

7 Jan 2012 by Massimiliano Peluso "WeDev Limited"

Repository Pattern with Entity Framework 4.1 and Code First

C#4.0

entity-framework

Stored Procedure Returns No Fields Even After Refresh Fields

15 Jul 2015 by Member 10295860

Using stored procedure type for binding data to dataset in SSRS or adding entity to Entity data model

Pivot Table Using Linq Entity and SQL Server 2008 R2 for Dynamic Columns

20 Nov 2014 by Avinash Narnaware

How to create Pivot Table in SQL Server 2008 R2 and in C# Linq to Entity Framework in a step by step manner with two different instances.

EntityWorker.Core - An Alternative to Entity Framework

3 Oct 2018 by Alen Toma

EntityWorker.Core - an alternative to entity Framework

Using C#, MVC, WebAPI, OData, Entity Framework, DI/IoC, and Kendo UI MVC and Efficient Data Retrieval

13 Aug 2013 by xbadenx

WebAPI, OData, Entity Framework (EF DB First), MVC

Table Auditing (Created By, Creation Date, Last Modified By, Last Modification Date)

29 Jan 2015 by Mina Talaat Ghaly

Add the auditing properties with one SQL query and fill them from one place.

Use of Database.SetInitializer() Method in Code First

3 Sep 2014 by Dukhabandhu Sahoo

The use of different Database initializer options in Entity Framework Code First

EF6.0

entity-framework

Convert LINQ to Entity Result to a DataTable

20 Apr 2011 by jonx

Very good stuff. Learned me a lot about how to access to the physical structure of the query.There is also a CopyToDataTable : http://msdn.microsoft.com/en-us/library/bb386921.aspx[^]And for the record here is a C# version:protected DataTable EntityToDatatable(IQueryable Result,...

SqlServer: Parameterized Query With IN() Clause C#

14 Feb 2019 by DiponRoy

A utility class to send parameters for IN() operator in SQL using parameterized queries

How to get output parameter values from stored procedure using Entity Framework.

13 Oct 2014 by SRS(The Coder)

This tip gives an explanation with example on how to get output parameter value from stored procedure using Entity Framework in ASP.Net

Entity Framework Multi DB Support

7 Dec 2015 by Efe Erdoğru

An alternate method for multi db provider support for entity framework

Windows

entity-framework

VS2013

Implementing Connection Resiliency with Entity Framework 6

24 Oct 2014 by Pharylon

Connection Resiliency with EF 6

entity-framework

Validate a Unique Constraint at dbContext ValidateEntity in Entity Framework

7 Nov 2016 by Wahid Bitar

Validated the unique constraints at dbContext ValidateEntity in a generic way by reading the IndexAttribute values.

Generic Method to Convert DataReader Result into List of CLR Objects

24 Apr 2014 by Bankey Sharma

Converting DataReader Result into List of Objects Using Generic Type, Property Attribute and Reflection

Entity Framework Core Triggers in Action (Unofficial Package)

18 Apr 2018 by Fiyaz Hasan

This article shows you how to work with database triggers in entity framework core using a third party library.

.NET-Core

ASP.NET-Core

entity-framework

SQL Dependency using Entity Framework in WPF

6 Apr 2018 by CyberMakarov007

SQL table dependency with entity framework in WPF

Setup your ASP.NET Membership Login in MVC (or any project you want)

6 Mar 2015 by Alexandre Paula

aspnet Membership Login in any project you want.

Property Mapping in Entity Framework Code First

14 Oct 2014 by Dukhabandhu Sahoo

Learn how property is automatically mapped to column and how to manage it in entity framework code first.

Database Migration in Entity Framework 7

6 May 2015 by Mostafa Asaduzzaman

How to migrate database in Entity Framework 7 and Visual Studio 2015

entity-framework

MVC

How to force eager fetch on entity framework especially with inheritance

4 Jun 2017 by Puresharper

Lazy loading is a nice feature but sometimes it is more efficient to eager fetch. However entity framework does not provide an easy way to do it.

.NET

entity-framework

Delete All Rows in a Table in Entity Framework

28 Dec 2021 by DiponRoy

Delete all the records from the table using EF

Mocking EF DbContext and DbContextTransaction with Proxy

12 Oct 2016 by MaDOnos

How to mock EF DbContext and DbContextTransaction with Proxy

Overloaded Server: Quick Fix

7 Dec 2015 by Igor_A

Review of an approach of increase clustered server performance. Library sample and test utility.

Create SQL Contained Database Users using EntityFramework Code First

19 Aug 2018 by Islam Refaei

How to create contained DB users to be used among your application

How to Use MySql Database with ASP.NET Identity

3 Mar 2018 by Ajit Hegde

This tip describes how to use ASP.NET identity entity framework with mysql database.

Get an Entity Framework Object anyway

4 Feb 2012 by Harry von Borstel

How to get an Entity Framework object - either from ObjectContext, from database or from scratch

.NET

entity-framework

Entity Framework Code First

26 May 2011 by Soulus83

Unique constraints

C#4.0

entity-framework

Replace an Entity in Entity Framework Context

24 Feb 2010 by RobertFall

I was struggling recently with a problem I KNEW had to be solvable in a much easier way than replacing ALL the fields in my managed entity by hand and then saving it. I wanted a way that I could simply replace the managed entity with a new one that had been created from an XML document.Turns...

C#4.0

entity-framework

Implementing Common Audit Fields with EF Core’s Shadow Property

22 Mar 2017 by Fiyaz Hasan

Know how to use Entity Framework's new shadow property feature for easily implementing common audit fields for entities

EF-Core

entity-framework

auditing

List Batching/Paging With Entity Framework or Any IEnumerable in C#

19 May 2019 by DiponRoy

The aim of this helper class is to divide a large IEnumerable into multiple small list.

Lazy Behavior of IQueryable

22 Feb 2019 by Bohdan Stupak

Here’s a workaround how to fix exception "DbContext has been disposed"

.NET

entity-framework

Entity Framework Core Code First Publishing Multiple Db Contexts in the Same Database

7 Aug 2022 by DiponRoy

EF Core first publishing multiple DB contexts in same DB

EF-Core

entity-framework

CodeFirst

Entity Framework, Hybrid Approach

1 Jun 2017 by Sherjil_Ahmed

Mixing DB-First and Code First Approach for using SPs in EF-Way

Visualization in VS2010

4 May 2010 by dswersky

If you have Visual Studio 2010 Ultimate, you have some serious architectural tools. One of my favorites (so far) is the Dependency Graph.Select Architecture-Generate Dependency Graph and you'll see that you can generate a graph by Assembly, Namespace, Class, or Custom. Try the Assembly...

VS2010

entity-framework

Visual-Studio

About Entity Framework

26 Dec 2009 by Vinayaka Krishna Shenoy

From past few days i was doing some R & D on the upcoming Entity framework from Microsoft, and i found it was interesting in many ways,The first part which i liked the most is -Querying to the Entity Data Model(EDM) rather than the real data store.At a high level , we have plenty of...

.NET

.NET3.5

entity-framework

Optimizing Entity Framework Performance

23 Sep 2015 by Ponkarthikeyan Thangavel

This article decries optimizing entity framework performance when using Code First approach with lazy loading enabled

Mastering LINQ by Samples - LINQ Basics

23 Sep 2010 by alrosan

.NET

entity-framework

LINQ

Extension points for ADO.NET Entity Framework

31 Dec 2009 by Vinayaka Krishna Shenoy

I explored a bit more on Entity framework,during last week of 2009 and here goes my observations on how to extend the Entity Framework functionality if you want to customize the normal/ideal flow of Entity framework execution engine.1) OnContextCreatedBy default a declaration of this...

.NET

entity-framework