now you are teacher too??

dude

What/where is the "With" in With.Transaction?

Naked CLR is boring, but once the light bulb turns on and they "get it" you'll see a huge difference. It's the same when I'm mentoring guys on refactoring. I make them (and myself) go through the pain and suffering of doing refactorings manually so that they know why they're doing them. Then I show them ReSharper. Then I introduce them to the keyboard and live templates. Then their heads explode. It's all a very natural progression.

@Bil:

I guess I still have a head explosion ahead of me, since I'm not using ReSharper yet (it slowed my machine too much, and I use rather a strogng enough machine, 3.0HT+2GB), and my laptop is a poor 1.7+756MB so no ReSharper will fit in currently :(

@Ayende:

Is this "teaching" a part of mentoring new members, or is it a paid activity (thus, you have clients who pay you to mentor their employees? I guess those are clients worth working for )

Hi man

Even though you're not a native English speaker, I find your blog to be one of the most enjoyable & interesting to keep up with, even if you post like 5 times a day :-).

I hope a major publisher approaches you to write a book on enterprise architecture one day - that is if you want to.

Chris

Slight bogosity in that Transaction method. It's missing the type parameter and it's void, the exec return value is discarded. Posting a little too fast? :)

Very interesting stuff

Alk.

[Oren]

That's what I figured after I'd read two of your earlier scathing posts.

Thank you for confirming it.

Beginner, here is is, in its naked glory:

using System;

using System.Collections.Generic;

using System.Text;

using System.Data;

using System.Data.SqlClient;

using BookStore.Properties;

namespace BookStore.Util

{

public static class With

{

    public delegate T Func<T>(SqlCommand command);

    public delegate void Proc(SqlCommand command);


    public static T Transaction<T>(Func<T> exec)

    {

        T result = default(T);

        Transaction(delegate(SqlCommand command)

        {

            result = exec(command);

        });

        return result;

    }


    public static void Transaction(Proc exec)

    {

        using (SqlConnection connection = new SqlConnection(Settings.Default.Database))

        {

            connection.Open();

            SqlTransaction tx = connection.BeginTransaction();

            try

            {

                using (SqlCommand command = connection.CreateCommand())

                {

                    command.Transaction = tx;

                    exec(command);

                }

                tx.Commit();

            }

            catch

            {

                tx.Rollback();

                throw;

            }

            finally

            {

                tx.Dispose();

            }

        }

    }


}

}