Linq to Sql custom property

[Chuck P]

I have a table called Personnel.
I would like to have a property in the created object Table that is not in
the physical SQL table.
For example a field like IsEligibleForRetirement.

I saw I could use sprocs for Insert/Update/Delete on the objectTable created
and
that I could add a method to the context object that returns a objectTable.

What is the best way to add a property to the object table so that is loaded
from a sproc on a select? Also if the table had keys to look-up tables,
would they still be automatically mapped in LINQ queries? For example in
Personnel you have EthnicID and the lookup table lutEthnicities has
(EthnicID, EthnicDescription).

var query= from a in ctx.Personnel
select new {LastName, EthnicDescription,
IsEligibleForRetirement};

thanks,

 

[Steven Cheng[MSFT]]

Hi Chuck,

From your description, it seems you're wantting to do some customization on
the default generated Linq context class and the query statement it uses,
correct?

Based on my research, I've found a good article on Scott's blog which has
introduced something about custoimze the linq classes:

#LINQ to SQL (Part 8 - Executing Custom SQL Expressions)
http://weblogs.asp.net/scottgu/archive/2007/08/27/linq-to-sql-part-8-executi
ng-custom-sql-expressions.aspx

Hope this helps.

Sincerely,

Steven Cheng

Microsoft MSDN Online Support Lead



==================================================

Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.



Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.

==================================================


This posting is provided "AS IS" with no warranties, and confers no rights.




--------------------

 

[Chuck P]

I ended up
extending a property on the object table,
writing a select sproc that returns the table with the additional field.
specifing the upd, ins, del, sprocs to use in the class.

Seems strange that the object table lets you specify upd, del, ins, but not
select.