ExecuteCommand

From a post from last year (http://www.mindscape.co.nz/forums/Thread.aspx?PostID=7944) it was clear that LightSpeed doesnt have an ExecuteCommand equivalent.

But why not?

The syntax of this:

http://msdn.microsoft.com/en-us/library/system.data.linq.datacontext.executecommand.aspx

Looks so much nicer and cleaner then having to play with command's again. Definitly when you also have to use parameters.

Commands also bring back the horrid ADO feelings again (aaargggh).

Please add ExecuteCommand support :)

Regards, Jerremy

ExecuteCommand doesn't require any support from the LightSpeed core -- you can write it yourself as an extension method.  Here's my implementation:

public static int ExecuteCommand(this IUnitOfWork u, string command, params object[] args)
{
  var dbFactory = u.Context.DataProviderObjectFactory;
  using (IDbCommand cmd = dbFactory.CreateCommand())
  {
    var parameters = args.Select((a, index) => dbFactory.CreateParameter("p" + index, a));
    cmd.CommandText = String.Format(command, parameters.Select(p => p.ParameterName).ToArray());
    foreach (var parameter in parameters)
    {
      cmd.Parameters.Add(parameter);
    }
    u.PrepareCommand(cmd);
    return cmd.ExecuteNonQuery();
  }
}

WARNING: The code above achieved the coveted "worked on my machine in a couple of simple test cases" standard.  It has not been tested any further than that.