Dynamic Table Mapping for LINQ-to-SQL

using System;
using System.Data.SqlClient;
using Microsoft.VisualStudio.TestTools.UnitTesting;

namespace Prototype.NamedTable
{
    /// <summary>
    /// Sets of method to prepare a test database
    /// </summary>
    [TestClass]
    public class Preparation
    {
        public const string SQLTest = @"Data Source=.\SQLEXPRESS;Initial Catalog=test;Integrated Security=True;Pooling=False";

        [TestMethod]
        public void RebuildDatabase()
        {
            var connection = new SqlConnection(SQLTest);
            connection.Open();

            var command = connection.CreateCommand();
            command.CommandText = "drop table result2011";
            try { command.ExecuteNonQuery(); }
            catch (Exception) { }

            command.CommandText = "create table result2011 (id int, name varchar(50), value float)";
            command.ExecuteNonQuery();

            for (int i = 0; i < 20; i++)
            {
                command.CommandText =
                    string.Format(
                        "insert into result2011(id, name, value) values ({0},'{1}',{2})",
                        i + 1, "2011_" + i, i * 1.395896 % 100);
                command.ExecuteNonQuery();
            }

            command.CommandText = "drop table result2012";
            try { command.ExecuteNonQuery(); }
            catch (Exception) { }

            command.CommandText = "create table result2012 (id int, name varchar(50), value float)";
            command.ExecuteNonQuery();

            for (int i = 0; i < 10; i++)
            {
                command.CommandText =
                    string.Format(
                        "insert into result2012(id, name, value) values ({0},'{1}', {2})",
                        i + 100, "2012_" + i, i * 20.39548 % 100);
                command.ExecuteNonQuery();
            }
        }
    }
}