LINQ to SQL: Is it possible to reference the data context when extending a table object?

Question

If I'm extending OnCreated for a LINQ to SQL table object, is it possible to get a reference to the data context to which the table belongs? For example, if I add a property to the data context:

Partial Class MyDataContext

    Private _myValue As String
    Public ReadOnly Property MyValue As String
       Get
           Return _myValue
       End Get
       Set(ByVal value As String)
           _myValue = value
       End Set
    End Property

End Class

is there any way to access that value in the create event of the table, i.e.:

Partial Class MyTable

    Private Sub OnCreated()
        Dim contextValue = [data_context_reference_here].MyValue
    End Sub

End Class

I don't want the property on the data context to be Shared, because it could be different per instance. I've been pouring over the designer code to figure out where the reference might be, but no luck yet. Any ideas?

What reason makes you think you need to access that property? Perhaps it isn't necessary to do it this way... more info please — Josh E
– Josh E, Commented Jul 27, 2009 at 16:33
It's for debugging. I'd like to pass one instance of the debugging class to the context, then be able to access it from any event on any table in that context. (So "MyValue" would be the debugger instance - I just made it a string for simplicity.) — gfrizzle
– gfrizzle, Commented Jul 27, 2009 at 17:38

Ben M · Accepted Answer · 2009-07-27 16:51:37Z

1

There are no generated table objects in LINQ to SQL--only row objects, of which the DataContext owns one Table(Of TRowType) per. So the partial OnCreated method you implement is in a row class, and will be called whenever a row is created.

Generated row objects implement INotifyPropertyChanged and INotifyPropertyChanging, but are not derived from any base class. Since OnCreated takes no parameters, there is no way for the row to determine (via that method) which Table it belongs to, much less which DataContext it was created for.

You'll have to find some other way to do what you want.

edited Jul 27, 2009 at 16:51

answered Jul 27, 2009 at 16:45

Ben M

22.6k3 gold badges69 silver badges71 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Bogdan_Ch · Accepted Answer · 2009-07-27 17:02:32Z

1

I will say it is an incorrect pattern for Linq 2 SQL

In Linq2sql, it is supposed that any row object like your MyTable can be created without context. Later you can attach it to a table (with a specified context)

For example

Dim myTable as new MyTable()
dataContext.GetTable(Of MyTable).Attach(myTable)

So in reality, you should not create any logic inside MyTable classes that will depend on datacontext that was used to create this object, because some of them can be created without dataContexts, some can be attached and detached...

answered Jul 27, 2009 at 17:02

Bogdan_Ch

3,3565 gold badges26 silver badges40 bronze badges

Comments

Community · Accepted Answer · 2017-05-23 12:13:35Z

0

A simple google search (linq event data context) would have led you to where this question was already asked and answered:

Determine the source DataContext for a Linq to Sql query

edited May 23, 2017 at 12:13

CommunityBot

11 silver badge

answered Jul 27, 2009 at 16:42

Dave

4,4223 gold badges26 silver badges30 bronze badges

Collectives™ on Stack Overflow

LINQ to SQL: Is it possible to reference the data context when extending a table object?

3 Answers 3

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related