Geeks With Blogs
Juans and Zeros EF Entity Framework
Why Entity Framework Profiler is showing SELECT TOP 2 Queries
I was running Entity Framework Profiler on one of my projects using EF5 and came across several queries that were using SELECT TOP (2) and was wondering why that was happening. There were two different reasons I came across. Reason 1: When using Linq SingleOrDefault it will check to see if 2 results are returned so an exception can be thrown. This is per MSDN Instead I switched over to using Linq FirstOrDefault which translates to a SELECT TOP ......

Posted On Thursday, April 18, 2013 4:39 PM

Building a Repository Pattern against an EF 5 EDMX Model - Part 2
I know it has been a couple months since I first wrote part 1 of building a repository pattern with an EF model, but here we are. I am finally getting around to writing part 2. If you remember, in part 1 I talked about creating an EF model (EDMX) connected to an existing SQL server database and mapping the stored procedures to the entities and creating the generic repository classes. This post will dive into how to create the concrete implementation to the repository that will be used by a WCF service. ......

Posted On Monday, January 21, 2013 5:27 PM

Building a Repository Pattern against an EF 5 EDMX Model - Part 1
I am part of a year long plus project that is re-writing an existing application for a client. We have decided to develop the project using Visual Studio 2012 and .NET 4.5. The project will be using a number of technologies and patterns to include Entity Framework 5, WCF Services, and WPF for the client UI.This is my attempt at documenting some of the successes and failures that I will be coming across in the development of the application.In building the data access layer we have to access a database ......

Posted On Wednesday, October 3, 2012 12:13 PM

Copyright © Juan | Powered by: