Looking for New Opportunities

March 23, 2009

Looking for New Opportunities Today it’s not going to be my ordinary published posts. I quit my job at SRL Group. I’m not going to write the reasons for such a dramatic decision, but I can tell that I made it even though a financial crisis is occurring and I don’t have any alternative currently. I want to thank the following people for being there in good times and bad times: Maor David, Ran Wahle, Yaron Shkop, Yael Cohen,  David Halimi, Rivka Gugig, Alon Moshe, Tal Tzur, Leon Langleyben and everyone I worked with during the last two years and I...
13 comments

Mapping Stored Procedure Results to a Custom Entity in Entity Framework

March 13, 2009

Mapping Stored Procedure Results to a Custom Entity in Entity Framework In the post I’m going to explain how to map results of a stored procedure to a custom created entity which we have created with the Entity Framework designer. Map Stored Procedures to Custom Entity Sometimes we have stored procedures in our database which don’t map to any table or view of our database. The problem with that is that if we want to use those stored procedures and map them to a custom entity that we have created we will get an error while compiling the project. Entity Framework’s...

QueryView Element in Entity Framework

March 12, 2009

QueryView Element in Entity Framework In a very old post that I wrote I explained what is the DefiningQuery element and how to use it. In this post I’m going to explain what is the QueryView element, how to use it and the difference between using a DefiningQuery and using a QueryView. What is the QueryView Element? QueryView element is defined inside an EntitySetMapping in the MSL...

Enabling Xml Schema Validation in Visual Studio

March 10, 2009

Enabling Xml Schema Validation in Visual Studio The post is a simple tip which will help you to enable Xml schema validation and intellisense while writing an Xml file inside Visual Studio. The Problem Writing Xml files according to a specific Xml schema definition is sometime very hard and can be a very “painful” task for a developer. You need to remember all the small details and elements...

Project “Astoria” Went Offline

March 7, 2009

Project “Astoria” Went Offline As I said at the end of the session I had this week, the “Astoria" team is working  on an offline feature for ADO.NET Data Services. Today I saw in Guy Burstein’s blog that an alpha preview of the offline feature was released as a stand alone preview. What it’s all about? “Astoria Offline” is an end-to-end solution for the building of offline ...

Adding Many to Many Relationship between Entities

Adding Many to Many Relationship between Entities A friend of mine asked me this week a question regarding link tables in Entity Framework. In their system they have a link table of many to many relationship between more then two tables. The Problem We have a link table with more then two reference keys but Entity Framework map this table into an entity instead of an entity association of many to many. For example I have the following hypothetic database which has a relation of many to many between persons, companies and countries: The result of the mapping after using the...

Mapping Stored Procedures to ObjectContext Methods

March 6, 2009

Mapping Stored Procedures to ObjectContext Methods In the session I had on Sunday I showed a simple scenario of how to map stored procedures to ObjectContext methods in Entity Framework. In this post I’ll show the same example that I used in the session. The Stored Procedure In the example I’m going to use a simple stored procedure which returns all the courses from the database ordered by their title. ...

Entity Splitting in Entity Framework

Entity Splitting in Entity Framework One of the mapping scenarios that I talked about in the session at WDC this week but I didn’t show an example is entity splitting in Entity Framework. This post will explain what is entity splitting and how to implement this mapping scenario in Entity Framework. What is Entity Splitting? Entity splitting is a scenario that happen when our entity is constructed ...

Start Thinking with ADO.NET 3.5 Slide Deck

March 2, 2009

Start Thinking with ADO.NET 3.5 Slide Deck Yesterday I had an ADO.NET  3.5 session in the The Israeli Web Development Community (WDC). The session agenda: Entity Framework ADO.NET Data Services Datasets Enhancements  As promised, the slide deck and demos can be downloaded from here. I want to thank Noam King for the opportunity to lecture in WDC. it was a pleasure. Also, I want...