ADO.NET Data Services IUpdateable implementation for Linq to Sql

UPDATED WIKI: Home

elisaf_MSFT — Fri, 22 May 2009 19:40:09 GMT

Sample implementation of ADO.NET Data Services IUpdateable interface for Linq to Sql Data Sources.

The easiest way to use this is to define a partial class for your DataContext type and provide the implementation there. i.e.
public partial class nwDataContext : IUpdatable

Updated 2009-22-5:

Visual Basic version now available

UPDATED WIKI: Home

elisaf_MSFT — Fri, 22 May 2009 19:39:11 GMT

Implementation of ADO.NET Data Services IUpdateable interface for Linq to Sql Data Sources.

The easiest way to use this is to define a partial class for your DataContext type and provide the implementation there. i.e.

public partial class nwDataContext : IUpdatable

Updated 2009-22-5:

Visual Basic version now available

UPDATED WIKI: Home

elisaf_MSFT — Fri, 22 May 2009 19:38:37 GMT

(Visual Basic and C# versions available)

UPDATED WIKI: Home

elisaf_MSFT — Fri, 22 May 2009 19:38:12 GMT

UPDATED RELEASE: IUpdateable implementation (Nov 06, 2008)

Fri, 22 May 2009 19:36:52 GMT

CLOSED ISSUE: Explicitly implement IUpdateable interface

robfe — Wed, 18 Mar 2009 00:20:22 GMT

by changing:
public object CreateResource(string containerName, string fullTypeName)

to:
object IUpdatable.CreateResource(string containerName, string fullTypeName)

then the intellisense experience for any code that's using the DataContext will hide the IUpdateable methods (unless you perform an explicity cast)
IMHO, this is a good thing from the point of view of Robert Martin's "Interface Segregation Principle" (http://www.objectmentor.com/resources/articles/isp.pdf)
Comments: applied & uploaded

CLOSED ISSUE: Remove reflection calls for improved perf

robfe — Wed, 18 Mar 2009 00:19:53 GMT

UPDATED RELEASE: IUpdateable implementation (Nov 06, 2008)

Tue, 17 Mar 2009 23:22:40 GMT

COMMENTED ISSUE: Remove reflection calls for improved perf

robfe — Mon, 09 Feb 2009 22:15:27 GMT

Suggestion from Benjamín Eidelman -

If you had, have you tried improving it by avoiding some of the Reflection calls? because those they use to be expensive, and caching would be very straight-forward in this case:

e.g. create a Dictionary<string,ITable> to cache this:

(ITable)this.GetType().GetProperty(containerName).GetValue(this, null)

Comments: Note that such a dictionary would have to be static In this case, however, it's probably better to call: Type t = Type.GetType(fullTypeName, true); ITable table = GetTable(t); The Mapping object of the linq to sql datacontext contains a number of objects that will do fast property sets / gets: public void SetValue(object targetResource, string propertyName, object propertyValue) { MetaTable table = Mapping.GetTable(targetResource.GetType()); MetaDataMember member = table.RowType.DataMembers.Single(x => x.Name == propertyName); member.MemberAccessor.SetBoxedValue(ref targetResource, propertyValue); }

CREATED ISSUE: Explicitly implement IUpdateable interface

robfe — Mon, 09 Feb 2009 22:10:16 GMT

UPDATED RELEASE: IUpdateable implementation (Nov 06, 2008)

Sat, 13 Dec 2008 00:18:12 GMT

UPDATED RELEASE: IUpdateable implementation (Nov 06, 2008)

Sat, 13 Dec 2008 00:16:48 GMT

UPDATED RELEASE: IUpdateable implementation (Nov 06, 2008)

Sat, 13 Dec 2008 00:16:02 GMT

COMMENTED ISSUE: Need to implement ClearChanges

SteelePrice — Fri, 12 Dec 2008 21:06:38 GMT

Can't figure out how to easily do this with Linq to Sql.
Comments: Here is how I am doing it in the VB version... Public Sub ClearChanges() Implements System.Data.Services.IUpdatable.ClearChanges Dim mi = Me.GetType().GetMethod("ClearCache", BindingFlags.Instance Or BindingFlags.NonPublic Or BindingFlags.InvokeMethod) Debug.Assert(mi IsNot Nothing) mi.Invoke(Me, Nothing) End Sub This does invoke an internal method, but appears to be the only way to do this.

CREATED ISSUE: Remove reflection calls for improved perf

AndrewConrad — Fri, 12 Dec 2008 04:22:23 GMT

CLOSED ISSUE: Reset Resource not working correctly

AndrewConrad — Fri, 12 Dec 2008 03:19:15 GMT

Reset resource currently creates a new entity and correctly sets the default values (other then key values) however this entity is not attached to the context, therefore changes never go through
Comments: Fixed on 12/11/08. New version uploaded.

UPDATED RELEASE: IUpdateable implementation (Nov 06, 2008)

Fri, 12 Dec 2008 03:18:22 GMT

CREATED ISSUE: Need to implement ClearChanges

AndrewConrad — Thu, 11 Dec 2008 05:02:14 GMT

Can't figure out how to easily do this with Linq to Sql.

CREATED ISSUE: Reset Resource not working correctly

AndrewConrad — Thu, 11 Dec 2008 04:43:49 GMT

Reset resource currently creates a new entity and correctly sets the default values (other then key values) however this entity is not attached to the context, therefore changes never go through

UPDATED RELEASE: IUpdateable implementation (Nov 06, 2008)

Wed, 03 Dec 2008 04:23:21 GMT