SQL For .Net Developers – Entity Framework 4 Second Cycle Slide Deck

June 28, 2010

SQL For .Net Developers – Entity Framework 4 Second Cycle Slide Deck Yesterday’s evening I delivered a session at Microsoft Raanana about Entity Framework 4 as a part of Microsoft’s SQL For .Net Developers series of sessions. I want to thank all the attendees who came to the session. I really enjoyed to talk about Entity Framework and the audience was very cooperative with a lot of really good questions. As I promised, I uploaded the session slide deck and demos to my Skydrive and you can download it from here. Pay attention that in the demos main directory...

Eager Loading with Repository Pattern and Entity Framework

June 22, 2010

Eager Loading with Repository Pattern and Entity Framework One question that I received yesterday after I published the Revisiting the Repository  and Unit of Work Patterns with Entity Framework post was how to include the eager loading ability of Entity Framework. This post is offering a solution. Revisiting Eager Loading and Lazy Loading Lazy loading is a design pattern that is commonly used to defer initialization of an object up until it is needed by the program. The gains of using the pattern include efficiency (if it’s used right) and sometime performance. Eager loading is the opposite pattern of lazy loading....

Revisiting the Repository and Unit of Work Patterns with Entity Framework

June 21, 2010

Revisiting the Repository and Unit of Work Patterns with Entity Framework In the past I wrote two posts about the Repository and the Unit of Work patterns (here and here). Today I want to show a better and less naive solution for imposing the Unit of Work and the Repository patterns with Entity Framework. Revisiting The Repositoy Implementation In the Repository pattern, I added to the interface two new methods for adding and removing an entity: public interface IRepository<T> where T : class{ T GetById(int id); ...

Consuming OData Feed using Microsoft PowerPivot

June 20, 2010

Consuming OData Feed using Microsoft PowerPivot PowerPivot is a data analysis add-in for excel that brings to it computational power. It also helps “to create compelling self-service BI solutions, facilitates sharing and collaboration on user-generated BI solutions” (taken from the PowerPivot site). This post will help you to understand how to consume OData feed from PowerPivot in order to use the data the OData...

Using Paging in WCF Data Services

June 19, 2010

Using Paging in WCF Data Services One of the mechanisms which were provided in WCF Data Services from the start was client side paging. In the new release of WCF Data Services we also get a server side paging and this will be addressed in this post. WCF Data Services Client Side Paging From the early days of WCF Data Services we could achieve paging on the client side using the $top and $skip query parameters. For example the following URI for a data service will bring the 11-20 courses which were requested: http://localhost:8322/SchoolDataService.svc/Courses?$skip=10&top=10 The problem starts when you expose resources with a lot...

FeedBurner Counter Hiccups

June 15, 2010

FeedBurner Counter Hiccups I’m using the FeedBurner counter in my blog from day one in order to see how many readers I have in my blog. Using the service I could see that during time the amount of readers in my blog started to grow. In the last couple of weeks I could see some counter hiccups. One day I had above 400 readers and in the next day all the readers that are registered with Google Feedfetcher suddenly disappeared and the counter dropped to 200 readers. This behavior was written in the FeedBurner Status Blog.  Today suddenly my...
no comments

Using Conditional Mapping in Entity Framework

Using Conditional Mapping in Entity Framework There are times that we want to retrieve only a portion of data from a table in the database permanently by some filter. For that purpose we can use the conditional mapping in Entity Framework. What is Conditional Mapping? Conditional mapping is a fixed condition that helps use to filter the result set that is being returned from the database for a specific entity. Also it enforces that an entity is mapped to data in the database under only certain conditions which are supplied inside the conditional mapping. In order to use conditional mapping we need...
2 comments

Cache Retrieval Pattern

June 13, 2010

Cache Retrieval Pattern In my previous post I wrote about cache layer and its position in every application. In this post I’m going to explain what is the cache retrieval pattern and show an example of how to implement it. Cache Retrieval Pattern When we implement a cache layer we need a strategy in order to retrieve cached items. The cache retrieval pattern is very simple and can be imposed into any application very fast. So how does it work? The business logic component will use the cache API in order to check whether some data exists in the cache. If the...

Cache Layer

June 11, 2010

Cache Layer Lately I found myself in some architecture consulting sessions at some customers. In every one of those customers I found myself explaining how to implement a cache layer in order to decrease the amount of round trips to the database and for better scalability. In this post I’ll try to explain in high level how to build a cache layer. Deciding to Build a Cache Layer Every application that performance is important to its developers and managers must contain some sort of caching. The cache is a veryfast in memory resources container which holds relevant data close to the application...

Microsoft Israel Sites were DNS Hijacked Yesterday

Microsoft Israel Sites were DNS Hijacked Yesterday Yesterday there was a DNS hijacking attack on some of Microsoft Israel sites including this Microsoft blog community. The sites were defaced with some offensive content which show that the people behind the attack are very childish and narrow minded.  This blog community is sharing its experience and knowledge with all the Microsoft community all over the world. Denying its service only hurts the people who...
no comments