linqpad - SubmitChanges Extension

Question

Is it possible to get SubmitChanges() to work from within an extension method?

I currently have this:

void Main()
{
    // Write code to test your extensions here. Press F5 to compile and run.
    Helper.ConfirmSubmitChanges();
}

public static class Helper
{
    // Write custom extension methods here. They will be available to all queries.
    public static void ConfirmSubmitChanges() 
    { 
        if (MessageBox.Show("Save?", "Do you really want to save all changes?", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
        {
            SubmitChanges(); 
        }
    }
}

// You can also define non-static classes, enums, etc.

But SubmitChanges() is out of context here. Is there anything that i can pass it from my queries that will use this extension to make it work?

Thanks, Kohan

score 2 · Accepted Answer · answered Dec 02 '11 at 14:41

2

You can do it with the by passing the current Context (this) into the static method:

Your program:

void Main()
{
    //Do Stuff  
    ConfirmSubmitChanges(this);
}

In My Extensions.linq:

static void ConfirmSubmitChanges(DataContext context)
{
    if (MessageBox.Show("Submit Changes?", "OK?", MessageBoxButtons.YesNo) == DialogResult.Yes)
    {
        context.SubmitChanges();
        "Saved".Dump();
    }
}

answered Dec 02 '11 at 14:41

DaveShaw

52,123
16
112
141

How do i get hold of the datacontext from within a linqpad query? – 4imble Dec 02 '11 at 15:54
It took me 20 minutes to find that. I have written some aweful code in previous queries to get hold of the current context. Answered this question's taught me what "this" is :). – DaveShaw Dec 02 '11 at 16:01
I googled it, found this (http://stackoverflow.com/questions/852687/is-there-a-linqpad-equivalent-to-a-datacontext-class) answer and realised you'd already told me the answer. Many thanks. Have a +1 – 4imble Dec 02 '11 at 16:04
@Kohan are you happy to mark this as the answer? It cover's everything asked (I think?). Thanks. – DaveShaw Dec 02 '11 at 16:11

score 1 · Answer 2 · answered Feb 02 '12 at 17:20

In case anyone wants to know, after passing "this" to the Extension. This is what i created in the end. It's nice because it also confirms the number of changes.

#region ConfirmSubmitChanges(DataContext dc)
public static void ConfirmSubmitChanges(DataContext dc)
{
    ConfirmSubmitChanges(dc, string.Empty);
}

public static void ConfirmSubmitChanges(DataContext dc, string AdditionalMessage)
{
    ChangeSet set = dc.GetChangeSet();
    var countChanges = 0;
        countChanges += set.Deletes.Count();
        countChanges += set.Inserts.Count();
        countChanges += set.Updates.Count();

    if (countChanges>0) {
        if(!string.IsNullOrEmpty(AdditionalMessage)) { AdditionalMessage = "\n\n(" + AdditionalMessage + ")"; }
        if (MessageBox.Show("Do you really want to save "+ countChanges+" changes?" + AdditionalMessage, "Save all changes?", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
        {
            dc.SubmitChanges();
        }
    }
}

#endregion

linqpad - SubmitChanges Extension

2 Answers2

Linked