Partial mapping in Entity Framework 4

I want to be able to do the following:

I have a model and inside there I do have an entity.

This entity has the following structure:

public class Client
{
    public int Id { get; set; }
    public string Name { get; set; }
    public string Description { get; set; }
}   

What I want now, is to just get the client name based on the id. Therefore I wrote a stored procedure which is doing this.

CREATE PROCEDURE [Client].[GetBasics]
@Id INT
AS
BEGIN
-- SET NOCOUN开发者_Python百科T ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;


SELECT 
    Name
FROM Client.Client
INNER JOIN Client.Validity ON ClientId = Client.Id
WHERE
    Client.Id = @Id; 
 END

Now, going back to VS, I do update the model from the database with the stored procedure included.

Next step is to map this stored procedure to the client entity as a function import.

This also works fine.

Trying now to load one client's name results into an error during runtime...

"The data reader is incompatible with the specified 'CSTestModel.Client'. A member of the type, 'Id', does not have a corresponding column in the data reader with the same name."

I am OK with the message. I know how to fix this (returning as result set Id, Name, Description).

My idea behind this question is the following:

I just want to load parts of the entity, not the complete entity itself. I have a restriction here to just use stored procedures for the entire communication towards/from the database.

Is there a solution to my problem (except creating complex types, LINQ on the result set itself)? And if yes, can someone point me to the right direction?

Many thanks,

Dimi

Just project onto a POCO:

var q = from c in Context.Clients
        select new NameOnlyPresentation
                   {
                       Id = c.Id,
                       Name = c.Name
                   };

... or just the name:

public string ClientName(int id)
{
    return (from c in Context.Clients
            where c.Id == id
            select c.Name).FirstOrDefault();
}