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...

ASP .NET Data Repeater for hierarchical data source

by Ahmad F Hassan

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

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

by Bhushan Mulmule

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

Business Logic Server as Windows Service (Architectural Prototype)

by Igor_A

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

Change database name created by Code First

by Nadege Rouelle

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

Changing Databases at Run-time using Entity Framework

by Matthew Givens

How to change databases at run-time in a user-friendly manner.

Convert LINQ to Entity Result to a DataTable

by Mohammad Al Hoss

Convert LINQ to Entity Result to a DataTable

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,...

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

by Uladzislau Baryshchyk

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

Create SQL Contained Database Users using EntityFramework Code First

by Islam Refaei

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

CRUD Many-to-Many Entity Framework

by Jean Carlo S. Passos

CRUD over Association Entity that maps to association tables

Data validation framework at entity level using Data Annotations

by sathya88

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

Database Migration in Entity Framework 7

by Mostafa Asaduzzaman

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

Delete All Rows in a Table in Entity Framework

by DiponRoy

Delete all the records from the table using EF

Dynamic paging in Entity Framework

by Maninder Singh Puhi

Appropriate query to fetch required no of results from DB instead of getting all at on time for binding controls like Gridview, listview etc

Dynamically creating a predicate delegate

by Randy Kroeger

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

Easing Non-standard EntityFramework Migrations

by #realJSOP

When you have a customized DbContext constructor.

Entity Framework 2.1 - npg PostgreSql Error

by Wael Al Wirr

PostgreSQL exception 42P01

Entity Framework 5.0 - Performance Tuning Using SqlBulkCopy

by Abhay@Accenture

Performance tuning using SqlBulkCopy

Entity Framework 7 - How to Retrieve Dynamic Data

by ChristineBoersen

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

Entity Framework and Views, if a PK Not Available

by Norman Paterson

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

Entity Framework Code First

by Soulus83

Unique constraints

Entity Framework Code First Migrations Alternative

by DiponRoy

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

Entity Framework Code First Navigation Property is null - solution

by Nejimon CR

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

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

by DiponRoy

EF Core first publishing multiple DB contexts in same DB

Entity Framework Core Triggers in Action (Unofficial Package)

by Fiyaz Hasan

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

Entity Framework DiagnosticsContext: Get Detailed Information on ChangeTracker Entries

by OrlandoCurioso

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

Entity Framework Dynamic Include Hierarchy

by Alen Toma

Entity Framework Dynamic include hierarchy

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

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.

Entity Framework Multi DB Support

by Efe Erdoğru

An alternate method for multi db provider support for entity framework

Entity Framework Not Inserting Rows into SQL Server Database Table

by GuyThiebaut

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

Entity Framework, Hybrid Approach

by Sherjil_Ahmed

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

Entity Framework: Separate Entity Class Mapping using Fluent API

by MdAsifBd

Separate entity class mapping using Fluent API

EntityWorker.Core - An Alternative to Entity Framework

by Alen Toma

EntityWorker.Core - an alternative to entity Framework

Exclude Type from the Model in Entity Framework Code First

by Dukhabandhu Sahoo

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

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

by Master DJon

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

Extension Method to help with EF Code First updating

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.

Extension Method to help with EF Code First updating

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); ...

Extension points for ADO.NET Entity Framework

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...

Generic Entity Framework AddOrUpdate Method with Composite Key Support

by Nathan Minier

Generic AddOrUpdate for EF with composite key support

Generic JqGrid Implementation in MVC

by Arun Chandrasekhara Pillai

Generic JqGrid implementation in MVC with custom filtering and dynamic sorting

Generic Method to Convert DataReader Result into List of CLR Objects

by Bankey Sharma

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

Get an Entity Framework Object anyway

by Harry von Borstel

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

Getting Started with IdentityServer4 - Quick Reference

by Ger Hayden

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

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

by David_Cui

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

How to force eager fetch on entity framework especially with inheritance

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.

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

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

How to Use MySql Database with ASP.NET Identity

by Ajit Hegde

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

IDbContextFactory which gets Connection String at runtime and triggers Automatic Migrations

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.

Implementing Common Audit Fields with EF Core’s Shadow Property

by Fiyaz Hasan

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

Implementing Connection Resiliency with Entity Framework 6

by Pharylon

Connection Resiliency with EF 6

Improving How ASP.NET Security Tables are Scaffolded

by Brady Kelly

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

Lazy Behavior of IQueryable

by Bohdan Stupak

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

Left Outer Join extension for Entity Framework

by Tony Sherlock

Snippet for Left Outer Join, Entity Framework

Linq Except Operator to Get NonEmployee And Employee collection

by santosh poojari

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

LINQ To Entity Outer Join

by Mr Orange

Introduction...

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

by DiponRoy

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

Mastering LINQ by Samples - LINQ Basics

by alrosan

Mocking EF DbContext

by MaDOnos

Adapter implemantation to mock DbContext easily

Mocking EF DbContext and DbContextTransaction with Proxy

by MaDOnos

How to mock EF DbContext and DbContextTransaction with Proxy

Move Entity Framework Core v5.0 to a Separate Project

by mark_worrall

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

Optimizing Entity Framework Performance

by Ponkarthikeyan Thangavel

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

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

by DiponRoy

Use same EDMX file with different Oracle database schemas

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

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.

Organizing Fluent Configurations into Separate Classes in EF Core 1.0

by Mohsen Esmailpour

Organizing Fluent configurations into separate classes in EF Core 1.0

Overloaded Server: Quick Fix

by Igor_A

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

Pagination with Entity Framework

by Lộc Nguyễn

On Chinook digital media store sample database

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

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.

Property Mapping in Entity Framework Code First

by Dukhabandhu Sahoo

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

Render Exceptions in an Entity Framework application

by Harry von Borstel

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

Replace an Entity in Entity Framework Context

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...

Repository Pattern with Entity Framework 4.1 and Code First

by Massimiliano Peluso "WeDev Limited"

Repository Pattern with Entity Framework 4.1 and Code First

Retrieve Multiple Dynamics CRM 2011 Entity Records from BizTalk 2010 Server

by mkader

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

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

by Alexandre Paula

aspnet Membership Login in any project you want.

Simplest Way to Make an OUTER JOIN in LINQ to Entity

by Super Lloyd

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

SQL Dependency using Entity Framework in WPF

by CyberMakarov007

SQL table dependency with entity framework in WPF

SqlServer: Parameterized Query With IN() Clause C#

by DiponRoy

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

Stored Procedure Returns No Fields Even After Refresh Fields

by Member 10295860

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

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

by Mina Talaat Ghaly

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

Testing with mock on Entity Framework 6

by Richard Silveira

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

Update Entity Framework ConnectionString Editor

by Kaj Bromose

Helper class

Use of Database.SetInitializer() Method in Code First

by Dukhabandhu Sahoo

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

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

by xbadenx

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

Validate a Unique Constraint at dbContext ValidateEntity in Entity Framework

by Wahid Bitar

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

Very Basic Console Application Using Entity Framework

by Md. Mainul Islam

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

Visualization in VS2010

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...

VS2022, ver. 17.6.2 – EntityFramework6 Broken

by Mark Pelf

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