How do you use the LINQ to SQL designer to generate accessor methods for subclasses?

Posted by Pricey on Stack Overflow See other posts from Stack Overflow or by Pricey
Published on 2010-03-29T23:36:40Z Indexed on 2010/03/29 23:43 UTC
Read the original article Hit count: 430

Filed under:

linq-to-sql

|

inheritance

|

object-relational-mapping

|

accessors

alt text

Above is the LINQ to SQL designer view for my data context.

Below is the relevant code:

        public System.Data.Linq.Table<ActivityBase> ActivityBases
        {
            get
            {
                return this.GetTable<ActivityBase>();
            }
        }

...

    [Table(Name="dbo.Activities")]
    [InheritanceMapping(Code="1", Type=typeof(ActivityBase), IsDefault=true)]
    [InheritanceMapping(Code="2", Type=typeof(Project))]
    [InheritanceMapping(Code="3", Type=typeof(ProjectActivity))]
    [InheritanceMapping(Code="5", Type=typeof(Task))]
    [InheritanceMapping(Code="4", Type=typeof(Activity))]
    public abstract partial class ActivityBase : INotifyPropertyChanging, INotifyPropertyChanged
    {

...

Is there a way to generate accessor methods for the subclasses as shown in the inheritance mapping above (Project, Task, etc...) without doing it manually? I added them manually but then a change in the designer overwrites any manual changes.

Am i doing this wrong? should I not be making accessors for the sub classes? filtering from ActivityBase seems worse to me.

Thanks for any help on this.

© Stack Overflow or respective owner

Related posts about linq-to-sql

how can i page my linq to sql result set

as seen on Stack Overflow - Search for 'Stack Overflow'
Remembering MySQL could use the instruction "limit" to indicate where I was starting my result set and how many wanted to have included. Select * FROM Users Limit [start], [Length] How can I do this in LinqToSql >>> More
LINQ to SQL and missing Many to Many EntityRefs

as seen on West-Wind - Search for 'West-Wind'
Ran into an odd behavior today with a many to many mapping of one of my tables in LINQ to SQL. Many to many mappings aren’t transparent in LINQ to SQL and it maps the link table the same way the SQL schema has it when creating one. In other words LINQ to SQL isn’t smart about many to many mappings… >>> More
Comparing LINQ to SQL vs the classic SqlCommand

as seen on Dot net Slackers - Search for 'Dot net Slackers'
tweetmeme_url = 'http://alpascual.com/blog/comparing-linq-to-sql-vs-the-classic-sqlcommand/';tweetmeme_source = 'alpascual';When you are coming from using SqlCommand and SqlConnection is difficult to move to another library for your database needs. For those people still in the limbo to make the decision… >>> More
Comparing LINQ to SQL vs the classic SqlCommand

as seen on Dot net Slackers - Search for 'Dot net Slackers'
tweetmeme_url = 'http://alpascual.com/blog/comparing-linq-to-sql-vs-the-classic-sqlcommand/';tweetmeme_source = 'alpascual';When you are coming from using SqlCommand and SqlConnection is difficult to move to another library for your database needs. For those people still in the limbo to make the decision… >>> More
LINQ to SQL Profiler

as seen on Dot net Slackers - Search for 'Dot net Slackers'
In this article we will be taking a look at the new LINQ to SQL Profiler from HibernatingRhinos. This tool gives you a view into the goings on of LINQ to SQL. Not only does it allow you to see the SQL that is generated by your LINQ queries but it also shows you information about your connections… >>> More

Related posts about inheritance

Single Table Inheritance (Database Inheritance design options) pros and cons and in which case it us

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, I study about today about 2 database design inheritance approaches: 1. Single Table Inheritance 2. Class Table Inheritance In my student opinion Single Table Inheritance make database more smaller vs other approaches because she use only 1 table. But i read that the more favorite approach… >>> More
How to use Private Inheritence aka C++ in C# and Why not it is present in C#

as seen on Stack Overflow - Search for 'Stack Overflow'
I know that private inheritance is supported in C++ and only public inheritance is supported in C#. I also came across an article which says that private inheritance usually defines a HAS-A relationship and kind of an aggregation relationship between the classes. EDIT: C++ code for private inheritance: The… >>> More
[PHP] Singleton class and using inheritance

as seen on Stack Overflow - Search for 'Stack Overflow'
I have am working on a web application that makes use of helper classes. These classes hold functions to various operation such as form handling. Sometimes I need these classes at more than one spot in my application, The way I do it now is to make a new Object. I can't pass the variable, this will… >>> More
Difference between Inheritance and Composition

as seen on Stack Overflow - Search for 'Stack Overflow'
Are Composition and Inheritance are the same? If I want to implement the composition pattern, how can I do that in Java? >>> More
C# Interface Inheritance (Basics)

as seen on Stack Overflow - Search for 'Stack Overflow'
Why does the following produce a compiler error: public interface OwnSession : ISession { } [...] OwnSession s = SessionFactory.OpenSession(); // compiler error (in german unfortunately) [...] "SessionFactory" returns a "ISession" on "OpenSession()" (NHibernate) >>> More