32 items found in the Entity Framework Category

Entity Framework Core DbContext Updated

28 October 2016 08:50

Entity Framework ASP.NET Core

Redesigning a framework from the ground up provides an opportunity to implement an improved API. The team working on Entity Framework Core have certainly grabbed that opportunity in respect of the DbContext class, which sees a bunch of new data manipulation methods not available in Entity Framework 6 or earlier.

Click to read more about Entity Framework Core DbContext Updated ...

Viewed 1115 times

0 Comments for this item

Entity Framework Core TrackGraph For Disconnected Data

11 October 2016 21:40

Entity Framework ASP.NET Core

Entity Framework Core is the new lightweight version of Entity Framework designed to work with .NET Core applications. Just like ASP.NET Core, it has been rewritten from the ground up, and includes some new ways of doing things. One of those is the introduction of the TrackGraph method for handling complex data in disconnected scenarios such as MVC or Web API applications.

Click to read more about Entity Framework Core TrackGraph For Disconnected Data ...

Viewed 842 times

2 Comments for this item

Entity Framework Code First and Stored Procedures

16 June 2016 07:38

Entity Framework

A key reason behind the decision to use an ORM such as Entity Framework for your data access is to reduce or eliminate the need to write SQL as part of the development process. Nevertheless, there are times when you might need to make use of database stored procedures, and Entity Framework 6 Code First provides support for using existing stored procedures as well as generating new ones.

Click to read more about Entity Framework Code First and Stored Procedures ...

Viewed 17675 times

3 Comments for this item

Implementing SQL Server Full-Text Search In An ASP.NET MVC Web Application With Entity Framework

13 May 2016 08:13

SQL ADO.NET ASP.NET MVC Entity Framework

The search facility on this site has been rudimentary at best. I have recently upgraded it to take advantage of the Full-Text Search feature in SQL Server. Although it is still a basic implementation, it is a vast improvement on the search system that existed before, which was based on Entity Framework dynamically generating SQL LIKE clauses. This article describes how I got SQL Server Full-Text Search up and running.

Click to read more about Implementing SQL Server Full-Text Search In An ASP.NET MVC Web Application With Entity Framework ...

Viewed 6593 times

2 Comments for this item

Entity Framework Recipe: Many To Many Relationship On The Same Table

18 June 2015 13:56

Entity Framework

This article looks at how to configure Entity Framework to manage many to many relationships based on the same table. This scenario arises the same entity is related to itself in a different role. An example is the related product feature you might see in a "People also bought" section of an ecommerce site. Another is the relationship between clients and agencies in the advertising and marketing world. That scenario will form the basis of the illustration below.

Click to read more about Entity Framework Recipe: Many To Many Relationship On The Same Table ...

Viewed 16877 times

4 Comments for this item

Entity Framework Recipe: Storing And Managing Time

23 April 2015 13:19

ASP.NET MVC Entity Framework

This post explores the options available to you when your application requirements include managing and storing time using the Entity Framework. Specifically, I am thinking of durations of time, such as the time required to complete some kind of task, not the time part of a date. Relevant examples might include storing the length of a movie, or the preparation time required for a recipe.

Click to read more about Entity Framework Recipe: Storing And Managing Time ...

Viewed 7257 times

3 Comments for this item

Migrating From Razor Web Pages To ASP.NET MVC 5 - Data Access And View Models

18 February 2015 13:16

ASP.NET MVC Entity Framework ASP.NET Web Pages

If you have built sites with the ASP.NET Razor Web Pages framework, you might want to look at migrating them to ASP.NET MVC at some point. This tutorial is the second in a series of three that explores how you do that by taking a step by step approach to migrating the WebMatrix Bakery template site to ASP.NET MVC 5. Along the way, each of the core parts of MVC are discussed by way of an introduction to the framework. The tutorial is divided into three parts. The first part looked at the roles of the View and Controller. This part looks at the M in MVC, the Model. Specifically, it features data access and view models. The final part will cover model binding and form posting. A download (c. 24MB) featuring the completed application is available.

Click to read more about Migrating From Razor Web Pages To ASP.NET MVC 5 - Data Access And View Models ...

Viewed 13125 times

2 Comments for this item

Entity Framework Recipe: Grouping By Year And Month

12 January 2015 20:38

ASP.NET MVC Entity Framework

This is the latest in a series of "EF Recipes" - short articles that show through practical examples how to achieve common tasks with Entity framework and ASP.NET MVC. This particular example looks at grouping data by year and month in MVC 5 with Entity Framework 6. The article is prompted by an email I got from a reader who asked how I generate the "Archives" feature in the right hand panel on each page on this site.

Click to read more about Entity Framework Recipe: Grouping By Year And Month ...

Viewed 29930 times

3 Comments for this item

Entity Framework Recipe: Alphabetical Paging In ASP.NET MVC

29 October 2014 20:53

ASP.NET MVC Entity Framework

This article looks at using the alphabet for paging data in MVC 5 with Entity Framework 6. Where it differs from most existing articles on alphabetical paging is that this article looks at generating paging links from the data instead of the alphabet. It also features a Bootstrap-friendly helper for generating the paging links.

Click to read more about Entity Framework Recipe: Alphabetical Paging In ASP.NET MVC ...

Viewed 25316 times

17 Comments for this item

Entity Framework Recipe: Hierarchical Data Management

24 October 2014 22:20

ASP.NET MVC Entity Framework

This article explores how to use Entity Framework 6 to manage the retrieval and display of hierarchical data such as you might find in a menu system. There are a number of existing items on the Internet that cover the same topic, but most of them seem unnecessarily complex and don't include any information about displaying the data once it has been retrieved.

Click to read more about Entity Framework Recipe: Hierarchical Data Management ...

Viewed 44699 times

9 Comments for this item

MVC 5 with EF 6 in Visual Basic - Advanced Entity Framework Scenarios

13 June 2014 13:42

VB.Net ASP.NET MVC Entity Framework

This tutorial is the last in a series of 12 that teach you how to build MVC 5 applications using Entity Framework for data access and Visual Basic. This final tutorial  introduces several topics that are useful to be aware of when you go beyond the basics of developing ASP.NET web applications that use Entity Framework Code First. Step-by-step instructions walk you through the code and using Visual Studio Express For Web for the following topics:

Click to read more about MVC 5 with EF 6 in Visual Basic - Advanced Entity Framework Scenarios ...

Viewed 36610 times

2 Comments for this item

MVC 5 with EF 6 in Visual Basic - Implementing Inheritance

13 June 2014 13:42

VB.Net ASP.NET MVC Entity Framework

This tutorial is the eleventh in a series of 12 that teach you how to build MVC 5 applications using Entity Framework for data access and Visual Basic. In the previous tutorial you handled concurrency exceptions. This tutorial will show you how to implement inheritance in the data model.

Click to read more about MVC 5 with EF 6 in Visual Basic - Implementing Inheritance ...

Viewed 12408 times

4 Comments for this item

MVC 5 with EF 6 in Visual Basic - Handling Concurrency

13 June 2014 13:41

VB.Net ASP.NET MVC Entity Framework

This tutorial is the tenth in a series of 12 that teach you how to build MVC 5 applications using Entity Framework for data access and Visual Basic. In earlier tutorials you learned how to update data. This tutorial shows how to handle conflicts when multiple users update the same entity at the same time. You'll change the web pages that work with the Department entity so that they handle concurrency errors.

Click to read more about MVC 5 with EF 6 in Visual Basic - Handling Concurrency ...

Viewed 16072 times

0 Comments for this item

MVC 5 with EF 6 in Visual Basic - Async and Stored Procedures with the Entity Framework

13 June 2014 13:40

VB.Net ASP.NET MVC Entity Framework

This tutorial is the ninth in a series of 12 that teach you how to build MVC 5 applications using Entity Framework for data access and Visual Basic. In earlier tutorials you learned how to read and update data using the synchronous programming model. In this tutorial you see how to implement the asynchronous programming model. Asynchronous code can help an application perform better because it makes better use of server resources.

Click to read more about MVC 5 with EF 6 in Visual Basic - Async and Stored Procedures with the Entity Framework ...

Viewed 19361 times

2 Comments for this item

MVC 5 with EF 6 in Visual Basic - Updating Related Data

13 June 2014 13:39

VB.Net ASP.NET MVC Entity Framework

This tutorial is the eighth in a series of 12 that teach you how to build MVC 5 applications using Entity Framework for data access and Visual Basic. In the previous tutorial you displayed related data; in this tutorial you'll update related data. For most relationships, this can be done by updating either foreign key fields or navigation properties. For many-to-many relationships, the Entity Framework doesn't expose the join table directly, so you add and remove entities to and from the appropriate navigation properties.

Click to read more about MVC 5 with EF 6 in Visual Basic - Updating Related Data ...

Viewed 14671 times

2 Comments for this item

Recent Comments

Sivu 19/10/2016 08:21
In response to Entity Framework Core TrackGraph For Disconnected Data
Oh that's very very very nice ! Thanks for the write up Mike, much appreciated for the taking the to...

Mark 12/10/2016 16:42
In response to ASP.NET Web Pages vNext or Razor Pages
Although "Web Pages" was removed from the roadmap, has it just been renamed to "Razor Pages"?...

Satyabrata 12/10/2016 09:20
In response to Entity Framework Core TrackGraph For Disconnected Data
Nice article. Please write more articles featuring ASP.Net web pages. Thank you...

Julian 26/09/2016 14:27
In response to Loading ASP.NET Core MVC Views From A Database Or Other Location
Fantastic, many thanks Mike! Had got half way down this road before finding your article - saved...

Abolfazl Roshanzamir 14/09/2016 05:36
In response to Loading ASP.NET Core MVC Views From A Database Or Other Location
Nice article. Thanke you so much ....

cyrus 02/09/2016 15:12
In response to ASP.NET Web Pages vNext or Razor Pages
I've got some news. As Damian stated in this link: https://github.com/aspnet/Mvc/issues/5208 “We...

Simon 01/09/2016 08:00
In response to Loading ASP.NET Core MVC Views From A Database Or Other Location
Thanks Mike, nice post and exactly what I was looking for. Like you said, I think I'll opt to the...

dave 20/08/2016 14:57
In response to ASP.NET Web Pages vNext or Razor Pages
Do SimplemembershipProvider in viewpages is supported?...

Steven 18/08/2016 04:40
In response to Entity Framework Code First and Stored Procedures
Can you provide the directives (using statements) you're using for EF7 example?...

yousaid 17/08/2016 22:08
In response to ASP.NET Web Pages vNext or Razor Pages
Increasingly, learning a Microsoft tool is no longer worth the return on investment. Too many tools...