Tip 46 – How to exclude a property using Code-Only

This time a real simple one prompted by this question on StackOverflow. Problem: If you tell the Entity Framework about this class using Code-Only, by default every property becomes part of Entity, and as a result stored in the database. Usually this is what you want. But not always, imagine this class: public class Person{…

1

Tip 44 – How to navigate an OData compliant service

I recently did a crash course in Data Services and OData. While doing so I realized my notes might be useful for you guys. So here is my little cheat sheet to quickly get up to speed with OData Urls. Note: OData Services may not necessarily support all of the following features: but if they…

7

Tip 43 – How to authenticate against a Data Service

Problem: When writing code against a Data Service, like say SharePoint, the client application must provide a valid set of credentials, or you will see a dreaded “401 Unathorized” response. For Silverlight applications hosted on the same site as the DataService, this is generally handled for you automatically. But WPF applications, for example, need manual intervension. Solution: The…

0

Interesting series of Posts exploring Code-Only

Daniel Wertheim left a couple of comments on Tip 42, that point to a series of posts he has written about using Code-Only to write clean code. The series is really interesting as he delves into topics like: facades, relationships between non-public properties, integrating pluralization, using structure map etc. All well worth a read, so…

1

Tip 42 – How to create a dynamic model using Code-Only

Background: When we give examples of how to use Code-Only we always start with a strongly typed Context derived from ObjectContext. This class is used to bootstrap the model. For example this (property bodies omitted for simplicity sake): public class MyContext : ObjectContext {     public ObjectSet<Category> Categories { get; }    public ObjectSet<Product> Products…

5

Tip 41 – How to execute T-SQL directly against the database

Sometimes you’ll find you need to issue a query or command that the Entity Framework can’t support. In fact this problem is common to most ORMs, which is why so many of them have a backdoor to the database. The Entity Framework has a backdoor too… .NET 3.5 SP1 In .NET 3.5 SP1 you can…

4

Tip 40 – How to materialize presentation models via L2E

Problem: Imagine that you have these entities public class Product {     public int ID { get; set; }     public string Name { get; set; }     public virtual Category Category { get; set; } } public class Category {     public int ID { get; set; }     public string Name { get;…

5

Tip 39 – How to set overlapping Relationships – EF 4.0 only

Scenario: In EF 4 we have FK relationships, available for the first time in .NET 4.0 Beta 2, so it is now possible to have a model something like this: public class Division {    public int DivisionID {get;set} // Primary Key    public string Name {get;set;}    public virtual List<Lawyer> Lawyers {get;set;}    public…

1